>>I'm studying the message thread you sent me - thanks
>>
>>By the way
>>
>>lcFileStr = filetostr('&wwx')
>>lcFileStr = chrtran(m.lcFileStr, chr(13) + chr(10),'') && to remove all of them at once - the file will be one long line now
>>strtofile(m.lcFileStr,'myFile1.txt')
>>
>>Is fine as my csv file only ever contains a single record - but there's the problem - how do I get rid of the column headers - I have no control over the way the csv file is written?
>>
>>Colin
>>
>
>You may first remove the first line with Headers, e.g.
>
>lcFileStr = substring(m.lcFileStr, at(CRLF, m.lcFileStr) + 2) && and then apply chrtran.
>
>Also, you don't need to use macro in your code above, I think.
Of course that's the way to remove the header - thank you so much
I have to use macros - the file names are contained in a table and are processed one by one
Great stuff Naomi - thanks
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing