>I have created a dbf with a number of records each containing a long memo field with a long string - there are 2 types of records A and B
>
>When I convert this to a text file using file to string I need all B records to have a carriage return at the end of that line in the text file
>
>How can I do this
>
>I don't need a line feed character as well
>
>Thanks

This is a bit a to wide question
assuming you will remember the CRLF discussion of yesterday.

SELECT yourTable
lcx = "" &&initial
SCAN FOR [expression that filters out record b]
 TEXT to lcx TEXTMERGE NOSHOW ADDITIVE
<<field1>>,sometconstant <<fieldn>>

 ENDTEXT
ENDSCAN
STRTOFILE(lcx,YourFileName)

*or within the scan anything else that will build the string, we had examples yesterday.

other version

SELECT yourTable
COPY TO YourFileName FOR [expression that filters out record b] TYPE SDF
*or
COPY TO YourFileName FOR [expression that filters out record b] TYPE CSV

also look for TYPE DELIMITED in the help

or

SELECT;
 Cur1.*;
 FROM YoruTable AS Cur1;
 TO FILE YourFileName;
 WHERE [expression that filters out record b]

thats not all possible, but it's a start.

I while sooner or later need to move to some SQL Server anyway. would do something like

*could be replaced for SQL Server w/o changing te cursor
SELECT;
 Cur1.*;
 FROM YoruTable AS Cur1;
 INTO CurOutPut;
 WHERE [expression that filters out record b]

*this might be in some function that itself coud be replaced and be generic or what ever
lcx = "" &&initial
SCAN FOR [expression that filters out record b]
 TEXT to lcx TEXTMERGE NOSHOW ADDITIVE
<<field1>>,sometconstant <<fieldn>>

 ENDTEXT
ENDSCAN
*or something similar

*final write
STRTOFILE(lcx,YourFileName)

This gives fine control over the output.

Lutz