You could look for a chr(13) in the data with an AT(chr(13), AddrData) and then substring AddrData to split the lines:
Addr1 = substr(AddrData, 1, AT(chr(13), AddrData) - 1 and
Addr2 = substr(AddrData, AT(chr(13), AddrData) + 1)
>I have some data from an Excel SpreadSheet that is best dealt with as a text field. Problem is that some of the records have a carriage return in them (two lines for an address/PO box #). As a character field the data has a thick ‘|‘ in it. What is the best way to deal with these?
>
>Thanks!
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
