I need a .bat file to to change a text file with one row that has 100 names, separated by comma with no quotes to one column with 100 records/rows.

Beware the following batch works in Windows NT/2K/XP only NOT in Windows 9X/ME.

@echo off > FileOUT.txt
set /P row=<FileIN.txt
:LOOP
for /f "tokens=1* delims=," %%a in ("%row%") do (
echo.%%a>> FileOUT.txt
set row=%%b
)
if not "%row%"=="" goto :LOOP
:: End_Of_Batch

how can I use the above bat file. I have created a bat file but it is only creating two blank txt file named FileOUT & IN!

Sorry, I have applied Batch file wrongly.....actually I have named one of the file In.....when I changed the name to FileIn then it works perfectly.......

Thanks IVO for this help.......:)

If you can download and install coreutils from here: http://gnuwin32.sourceforge.net/pac...

C:\test>type input.txt
jane,mike,peter
C:\test>tr "," "\n" < input.txt
jane
mike
peter
C:\test>

to save to a new file, just

c:\test> tr "," "\n" < input.txt > newfile

Hi IVO,

Can you tell me why this echos the commas?

TIA

::==
@echo off
setLocal EnableDelayedExpansion

for /f "tokens=* delims=," %%d in (my.csv) do (
echo %%d
)

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

M2