CR XI - Pattern Match 100 mg/ml

[ReportDr00]

Hello,

I have below data in a field and i would like to extract 100 mg/ml from it
field data desired output
drugname 10 mg/ml testname 10 mg/ml
drug23 name test 0.1 unit/ml name 123 0.1 gram/ml

is there pattern to match to use or other way of accomplishing it?
Appreciate the guidance

Regards

 

[Charliy]

Not quite sure what you're asking. Pattern searching is easy, if you only want records with that particular text you can put this in your select formula:

"100mg/ml" in {table.field}

 

[CoSpringsGuy]

and if its the dosage you always want to remove from the string .. is it always consistent? For example is there always a "/" and proceeded by a numeric value?

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

 

[CoSpringsGuy]

If so this would work as long as there is never a "/" in the name of the drug. If so we have to work something else out....

local stringvar array s := split({datafield});
local numbervar a;
local stringvar desired;
for a := 2 to ubound(s) do
if instr(s[a],"/") > 0 then desired := s[a-1] +" "+ s[a];
a;
desired

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