>>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