Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extracting data stored as a string

Status
Not open for further replies.

mjm19

Technical User
Apr 22, 2003
33
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top