>>>>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
>>
>>Sorry I made a mistake - all records need the carriage return
>>
>>Is there now a simple way of doing this?
>>
>>Thanks for your help
>
>so, first.
>
>Does the reord or the output of the records needs a CR?
>
>I assume the output, so:
>
>Just remove the clauses
>

>WHERE [expression that filters out record b]
>*or
>FOR [expression that filters out record b]
>

>
>from the examples above.
>
>please note the FOR clause in the las example given is superfluous. It's all out of the SELECT.
>
>Lutz

I file to string the whole table but EACH record needs a carriage return

Sorry for the confusion

Can you please give the the answer again to this as I am a bit confused myself

Thanks

Colin