>>>Despite some generous help from others I am still struggling with a file to str problem
>>>
>>>My database has a file with 1 field a memo field - I am required to create a text file as shown below but with each records terminating with a carriage return
>>>
>>>I can create the lines of test OK but not the terminating carriage return
>>>
>>>So If I use the following code I get the right answer without a carriage return at the end of each record - records start with an A or a B
>>>
>>>SELECT eit
>>>scan
>>>strtofile(narry+ chr(13)+CHR(10), 'c:\colineit.txt', 1)
>>>ENDSCAN
>>>endif
>>>
>>>
>>>"A","GOPT","TEST11","10/13/2014","966.15","HAYES","GBP","61.86","GB"
>>>"B","1234567","10/06/2014","15.00","7220717","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","LONDON","","EC2A 1ER","GB","CREDIT SUISSE","","1 CABOT SQUARE","CANARY WHARF","LONDON","LO","E14","GB","UKSTD"
>>>
>>>"B","2345678","10/06/2014","46.20","7220718","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","LONDON","","EC2A 1ER","GB","DEUTSCHE BANK","","1 CABOT SQUARE","CANARY WHARF","PARIS","LO","E14","FR","UKSTD"
>>>
>>>"B","3456789","10/06/2014","53.00","7220719","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","LONDON","","EC2A 1ER","GB","BNP PARIBAS","","1 CABOT SQUARE","CANARY WHARF","NEW YORK","LO","E14","US",""
>>>
>>>"B","4567891","10/06/2014","142.00","7220720","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","LONDON","","EC2A 1ER","GB","JAGUAR CARS","","1 CABOT SQUARE","CANARY WHARF","FRANKFURT","LO","E14","DE","UKSTD"
>>>
>>>"B","5678912","10/06/2014","78.00","7220721","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","LONDON","","EC2A 1ER","GB","MORGAN STANLEY","","1 CABOT SQUARE","CANARY WHARF","MADRID","LO","E14","ES","UKSTD"
>>>
>>>"B","6789123","10/06/2014","56.28","7220722","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","LONDON","","EC2A 1ER","GB","POWER FINANCIAL DO BRASIL S.A.","","1 CABOT SQUARE","CANARY WHARF","RIO DE JANEIRO","LO","E14","BR",""
>>>
>>>"B","7897897","10/06/2014","18.00","7220723","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","LONDON","","EC2A 1ER","GB","POWER PLATE MEXICO SA DE C.V","","1 CABOT SQUARE","CANARY WHARF","MEXICO CITY","LO","E14","MX",""
>>>
>>>"B","4564567","10/06/2014","247.86","7220724","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","LONDON","","EC2A 1ER","GB","PT INDOKORES SAHABAT","","1 CABOT SQUARE","CANARY WHARF","JAKARTA","LO","E14","ID",""
>>>
>>>"B","7897897","10/06/2014","123.47","7220725","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","LONDON","","EC2A 1ER","GB","JAGUAR & LAND ROVER CHINA","","1 CABOT SQUARE","CANARY WHARF","CHINA","LO","E14","CN",""
>>>
>>>"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",""
>>
>>You are terminating each line with a Chr(13)+Chr(10) instead of just Chr(13)
>>
>>Regards
>>Pieter
>
>
>Pieter
>
>If I only put a carriaige return I get a continuous line of text - I will ask my client what he wants
>
>Thanks for ther help

Colin,

What you see depends on the editor you are using.
If you open the file using "modify command" from the VFP command window you will see different.

Regards,
Pieter