CR XI - Need help with formula to parse string

[ReportDr00]

Hello

I have a string field that contains data like below

med1 100mg
med2 10mg
med3 50mg

i am interested in creating the formula called strength and extract 100mg, 10mg, 50mg etc from above data.

mg is key here and get 3 to 4 characters on left of mg that will give me a number.

regards

armani

 

[CoSpringsGuy]

If the data is always in the format you indicated use this formula

//strength
SPLIT({table.field}," ")[2]



_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[ReportDr00]

no it could have more words before and after numerica value like alfenta 100mg/ml ampul or alfentanil 500mg/ml amp

thanks

 

[lbass]

If there is only one "mg" per row, try this:

stringvar array x := split({table.string}," ");
numbervar i;
numbervar j := ubound(x);
stringvar y := "";
for i := 1 to j do(
if "mg" in x then
y := x
);
y

-LB