>>There is only 1 field in each record - it's a memo field - I need the text file created by file to string to have a carriage return at the end of each line
>>
>>So a file containing 12 records would have 12 lines in the text file each terminating with a carriage return
>>
>>This is an example of the memo filed in the dbf
>>
>>"B","4561234","10/06/2014","98.50","7220726","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","LONDON","","EC2A 1ER","GB","MAYER INTERNATIONAL LTD","","1 CABOT SQUARE","CANARY WHARF","INDIA","LO","E14","IN",""
>
>o.k.
>off topic: You can altter a message in UT by the Update link below the message
>
>For your problem
>
>

>SELECT yourTable
>lcx = "" &&initial
>SCAN FOR [expression that filters out record b]
> lcx = lcx+YourMemofield+0h0D &&I prefer the literal to the function CHR(13)
>ENDSCAN
>STRTOFILE(lcx,YourFileName)
>

>
>This will create:
>a text file,
> one line per record,
> line ends with CR,
> empty records are empty lines,
> last line ends with CR
>
>Lutz

Thanks will test it later today