Code to Remove double quotes

March 18, 2009 at 03:45:05
Specs: Windows XP
Hi,

Could you please give me the code that removes double quotes from .csv file.

The file is stored in C:\Temp location

The size of the file is 32000kb

The code should remove the double quotes very quickly.

Sample contentes of the file is

"1"|"1"|"ABC"|""|"AGA"|""|"MIS"|""|""|"L4"|"36995"|""|""|""|"GAF"|""|""|""|""
"10"|"10"|"FSASDF"|""|"4FSDA, SD."|""|"CFFSD"|""|""|"FAEQW

like this there are 70,000 lines
Thanks



See More: Code to Remove double quotes

Report •


#1
March 18, 2009 at 05:40:31
:: remove double quotes

@echo off & setLocal EnableDelayedExpansion

for /f "tokens=* delims= " %%a in (thefile) do (
set str=%%a
set str=!str:"=!
>> newfile echo !str!
)


=====================================
If at first you don't succeed, you're about average.

M2


Report •
Related Solutions


Ask Question