Parse Data

[adrienne3562]

I have a CR report that is pulling from a SQL db. The field name is "Parameter" and dumps into the report like this:

Secondary Address City=605 VIRGINIA BEACH BLVD.
NORFOLKSecondary Address Line 1=RIDE AWAY Att:Richard Turner
6059 VIRGINIA BEACH BLVDSecondary Address Location Name=ride
RIDE

I would like to make it split out to look like the attached (table).

Field Name Previous Value New Value
Secondary Address City NORFOLK 605 VIRGINIA BEACH BLVD.
Secondary Address Line 1 6059 VIRGINIA BEACH BLVD RIDE AWAY Att:Richard Turner
Secondary Address Location RIDE ride
Nam

 

[Madawc]

The SPLIT command will split using some character, in this case the whatever-it-is that has come out as undisplayable (box) on my screen.

Also use UBIND to find how many parts in a field. Use SEARCH to see examples.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP