I am trying to parse data out of a Memo field using crystal reports 2008.

This is what I am using:

whileprintingrecords;
numbervar v_start;
numbervar v_end;

v_start := instr({YourMemoField},"Aspirin");
v_end := instr(mid({YourMemoField}, v_start + 7),chr(10)); // carriage return chr(13)

if {YourMemoField} like ["Aspirin*"] then mid({YourMemoField},v_start,(6 + v_end)) else ""


It works as far as getting the word aspirin and I have played with it enough to get more data or less data, but what I really want is the data behind the word aspirin which will be a date.   So it will look like this:

Aspirin: 01/01/2013 ( i only want to retrieve the date)

any ideas on how to do this.. I know i have to find the line of data saying aspirin but cannot pull anything after that word without getting Aspirin in it.. If I dont use the v-start, than it uses data from the first line in the Memo field... I hope I'm making sense.

Not all records will have the Word Aspirin in them. so it needs to deal with this also,

Thanks




Edited by Bernieo - 06 Aug 2013 at 11:13am

We are now looking for Colonoscopy: instead of Aspirin.

if the record does have Colonoscopy: in it .. there will
always be a date in MM/DD/YYYY format. And will have a space after the : ex. ASA Colonoscopy:spacemm/dd/yyyy.   But no space after it. I was trying different things to get the date to pull so the Chr(10) may not need to be in there.

And this might still change, so if you could explain each line, so if I do need to search for something else I can make the changes that would be great.. User has not yet decided for sure what they want to have before the date. I do know the format will be consistent and the space will be after the words I need to search for..

I forgot to mention that you will need to create a string parameter to let the user input the desired search.

Edited by DBlank - 08 Aug 2013 at 4:40am

Edited by DBlank - 08 Aug 2013 at 7:34am

Thank you again! This worked and I was able to use it in multiple formulas to get data out of the memo field.