>>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!
>
>Try to add memo field to your table and replace this field with the content of char field. See, if memo would display address correctly.

It will go into a memo. Haven't had to parse memo fields, how do I get the seperate lines out?