>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 = ""
SCAN FOR [expression that filters out record b]
lcx = lcx+YourMemofield+0h0D
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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]