>>>Sorry I forgot to say that each new line starts with "A" or "B"
>>>
>>>
>>>>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",""
>>
>>Hello Colling,
>>
>>CR is CHR(13)
>>CHR(32) is space.
>
>Collin,
>
>Looks OK, hex value of CR is 0D

Thank you so much for all your help