extracting values from strings

[EBH]

I need help extracting values from text strings in memo fields. The example below shows a persons name that I want to pull out and an account number. The text string is consistent for all records.
I am using version 8.5 of Crystal.

Example of memo field-
Funding Authority: John Doe
Funding Account #: 12345

Thanks much.

 

[synapsevampire]

There are a few approaches here:

Name:
stringvar MyField:= mid({table.field,19);
split(MyField,"Funding Account #: ")[1]

Account:
stringvar MyField:= mid({table.field,19);
split(MyField,"Funding Account #: ")[2]

You might have to adjust the 19, that's just how we get rid of the Funding Authority text, then you create an array using Funding Account # as the delimiter, and reference 1 or 2 of the array.

-k