Extracting data stored as a string

[mjm19]

I should know this, but am currently braindead. Running Crystal 8.5 and trying to capture only that data that is stored as a string that starts with ADDON. Of the 19,000
patients I had on the original report from yesterday only a few had an Order Comment of ADDON. I only need to see those few.
Thanks

 

[dgillz]

A record selection formula could be:
{YourField} startswith "ADDON"

To actually extract the data that follows, try:

If Instr({YourField},"ADDON")>0 then mid({YourField},6) else ""


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz