I have one warning about strtofile in a loop and it depends on how items are in your loop.

Everytime you call strtofile() the virus scanner, if installed and running, will inspect your newly changed file. If your file gets large and you are in a tight scan with many items you will have a huge performance hit.

I love filetostr(), but in my one case I had to switch to level file operations fopen and fwrite and all that to avoid the performance hit.

Just saying...

>My file eit contains 10 memo records - I cant seem to convert the file to text with each line ending with a CR what am I doing wrong?
>
>My code is
>
>
>SELECT eit
>APPEND blank
>replace narry WITH ALLTRIM(narrative)+CHR(32)
>
>My file to string is
>
>SELECT eit
>SCAN
>strtofile(narry, 'c:\colineit.txt', 1)
>ENDSCAN
>
>As far as I can see there are no carriage return characters - I have tried using a hex editor - what is the hex value of a carriage return
>
>This is what my output file looks like
>
> "A","GOPT","12","10/16/2014","1353.00","HAYES","GBP","108.24","GB" "B","1234567","10/06/2014","123.00","7220717","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","","","EC2A 1ER","GB","CREDIT SUISSE","","1 CABOT SQUARE","CANARY WHARF","LONDON","","","GB","UKSTD 20.0" "B","2345678","10/06/2014","123.00","7220718","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","","","EC2A 1ER","GB","DEUTSCHE BANK","","3 AVENUE DE FRIEDLAND","PARIS 75008","PARIS","","","FR","UKSTD 20.0" "B","3456789","10/06/2014","123.00","7220719","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","","","EC2A 1ER","GB","BNP PARIBAS","","787 7TH AVENUE","NEW YORK","NEW YORK","","","US","" "B","4567891","10/06/2014","123.00","7220720","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","","","EC2A 1ER","GB","JAGUAR CARS","","HALL 3.1 STAND A19","IAA FRANKFURT MESSEGELANDE","FRANKFURT","","","DE","UKSTD 20.0" "B","5678912","10/06/2014","123.00","7220721","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","","","EC2A 1ER","GB","MORGAN STANLEY","","C / SERRANO 55","MADRID 28006","MADRID","","","ES","UKSTD 20.0" "B","6789123","10/06/2014","123.00","7220722","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","","","EC2A 1ER","GB","POWER FINANCIAL DO BRASIL S.A.","","AV. MARECHAL CÂMARA,","271 / 1102 – 20020-080","RIO DE JANEIRO","","","BR","" "B","7897897","10/06/2014","123.00","7220723","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","","","EC2A 1ER","GB","POWER PLATE MEXICO SA DE C.V","","PRD.PASEO DE LOS CAURELES","458 201B","MEXICO CITY","","","MX","" "B","4564567","10/06/2014","123.00","7220724","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","","","EC2A 1ER","GB","PT INDOKORES SAHABAT","","J L BUNI NO 61 RT 003 RW 05","CILAN GLAP","JAKARTA","","","ID","" "B","7897897","10/06/2014","123.00","7220725","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","","","EC2A 1ER","GB","JAGUAR & LAND ROVER CHINA","","NO 211 CENTURY AVENUE","FLOORS 21 31 32 33","CHINA","","","CN","" "B","4561234","10/06/2014","123.00","7220726","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","","","EC2A 1ER","GB","MAYER INTERNATIONAL LTD","","89 MILESKONE DELHI JAIPER HIGHWAY","SECTOR 35","INDIA","","","IN",""