Is it possible to text to column in CR IV

[sandeejh]

Hello everyone
I have created a report that includes customer’s shipping information. The shipping information comes across with carriage returns. I created a formula to replace the carriage returns//Replace(Replace({RESCARD.SHIPTOADDRESS},chr(13),"^"),chr(10),"^")//

Currently I run the report then export it to Excel and use the text to column feature to separate the shipping address field and create 5 columns/fields Name^^Address1^^City, State^^ Zip

Is there a formula for text to column in CR IV? Or is there a workaround? The ultimate goal is to hand the report over to someone else to run, however my fellow employees are not as advanced as I in Excel.

Any ideas
Thanks
Sandy

 

[Madawc]

The SPLIT command will allow you to separate different elements of a string field. If you have that in CR IV it should do the job

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP