Special Chracters in file
Posted: 15 Nov 2018 08:56
Folks -
I'm trying to parse the following file:
here is what I have so far - can someone assist?
Thanks!
I'm trying to parse the following file:
However, as you can imagine, I'm not able to parse the first row due to the special chracters. I think I need to toggle between delayexpansion but unable to be successful.Update,Target Type,FP&A,Workforce,Real Estate,file1,file2
Update Legal Entity,TRUE,DEV,TRUE,TRUE,FALSE,REG1, test.csv
here is what I have so far - can someone assist?
Code: Select all
@echo off
setlocal enabledelayedexpansion
set /A elementNumber=0
for /F "tokens=*" %%L in (Process_Automation.csv) do (
rem clear out elementNumber
echo %%L
call :parse %%L
)
:parse
setlocal
set list=%*
echo !list!
for /F "tokens=1* delims=," %%f in ("!list!") do (
set /A elementNumber+=1
rem if the item exist
if not %%g == "" call :parse %%g
)
endlocal
goto :eof
