search and replace string

[indepthcomputer]

Greetings,

Please help!!! I have a load of csv files which I need to format and create a pdf. This is what I have been doing.

1. Opening the csv into excel and do a search and replace to get rid of commas that are not part of the delimiter.

2. Then load it into a pre-formatted report in ms access.
3. Then kick out the PDF.

I will eventually create a program to do it all "when I learn how to program :)

I would like to start with help on creating a program that would do the first step.Getting rid of bad commas in the csv file.

*note. I created a bat file but when it reads through the csv file in it native state, it eliminates ALL the commas and no longer usable.

*One last thing: When a bad comma finds itself into the csv file it somehow incapacitate itself with quotations ex. ....time "2834 Green Street / BR , M"...

Any help to get me going would be great!

[indepthcomputer]

bump

Please, if you review this and have no solution, please reply with reason... This would help me to go into another direction.