Remove all double quotes form text file 1

[Sammy145]

I want to remove all double quotes from CSV
example data

"field1","Field2",3,5,"abc"
"field4","Field8",3,5,"abttrec"
"field5","Field6",3,5,"abterc"


Can someone give me some sample code to do this the file can have a few thousand lines

thanks for all your help

Sam

 

[EBGreen]

You can do this with a straight Replace or through the use of a Regular expression. Be aware that this will possibly break your CSV.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[chrissie1]

And what code do you have so far?

Christiaan Baes
Belgium

My Blog

 

[Sammy145]

what do u mean EBGreen when u say "Be aware that this will possibly break your CSV. " how so

 

[EBGreen]

I mean that if you have a field that has a comma in the data that is contained in the field, then if you remove the ""s the data will not import properly anymore since it will see the comma that was in the data as a field sepperator now.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[Sammy145]

k thanks this got me there

http://www.microsoft.com/technet/scriptcenter/resources/qanda/jun05/hey0606.mspx

thanks guys