i have some trouble about convert file tsv to file csv with .bat. Problem is i can't convert when i change data with tab and spaces
My current source
setlocal disableDelayedExpansion
set OUT_DIR1=%1
set input=%OUT_DIR1%\%2
set output=%OUT_DIR1%\%3
set IN_DIR=%4
type %IN_DIR%\*.tsv > %OUT_DIR1%\result.tsv
>%output% (
for /F "tokens=* delims=" %%a in (%input%) do (
set "line="
setlocal enableDelayedExpansion
for %%b in (%%a) do set "line=!line!,%%b"
echo !line:~1!
endlocal
)
)
My input file
0001 abc de mo1 abc
0001 a bc de mo2 abc
0001 abc de mo3 a bc
0001 a bc de mo4 a bc
My output i want
0001,abc,demo1,abc
0001,abc,demo2,abc
0001,abc,demo3,abc
0001,abc,demo4,abc
Please help me!!!!!!!!!!!!!!!!!!!
CodePudding user response:
@ECHO OFF
SETLOCAL ENABLEDELAYEDEXPANSION
rem The following settings for the source directory, destination directory,
rem filename, output filename are names
rem that I use for testing and deliberately include names which include spaces to make sure
rem that the process works using such names. These will need to be changed to suit your situation.
SET "sourcedir=u:\your files"
SET "destdir=u:\your results"
SET "filename1=%sourcedir%\q72797128.txt"
SET "outfile=