>>>>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?
>
>Check Help on Mline(), MEMLINES() functions and also ALINES()

Thanks!