the quotes are now removed and the csv's are read with another utility.
When there would have been a comma in the quoted character field, the utility will run wrong because of faulty parsing.
Question : how can i change a comma in dot-comma (replace , with ; ) between the paired quotes?
Kind Regards, Gerd.[/code]
Thanks for your reply, but i think that you have tested that with a FB file.
The input file is VB, therefor the squeezing starts at position 5.
The proposed statement will replace all commas with dot-commas, and leaves all commas between the quotes untouched.
I simplified it a bit with a FB infile :
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum