Forum Discussion

Redzero1's avatar
Redzero1
Frequent Visitor
2 years ago
Solved

Extract from text string with conditions

Hello All,   I have a request I'm working on and I'm a bit struggeling to get the information I want : I have one column from Excel file caled "Comments" it a free text and Iit contains the Age (th...
Need Help
Redzero1's avatar
Redzero1
Frequent Visitor
2 years ago

sure here is an example :

 

CommentExpected Result
minor results on patient1 3y after 5 iterations3
result expected on 5yr patient after ....5
lenght of treatment 6mos on alpha 18y following ...18

 

basically need to parse the text and spot the numeric values before "y" or "yr"

    • Redzero1's avatar
      Redzero1
      Frequent Visitor
      2 years ago

      Thanks worked perfectly .

      except where the age was not mentioned - I can figure it out 

       

      thanks again