How Do I turn List fo files listed Horizontally to a vertical list

[Ray at]

sListOfFiles = Replace(sListOfFiles, " ", vbCrLf)

Ray at work

 

[Ray at]

Whoops. I thought I was in a vbscript group. Ignore my reply.

Ray at work

 

[Raymond Chan]

Hi All,

Have a list of files in a text file but listed horizontally.


File1.txt file2.txt file3.txt

I would like it to be in a file like

File1.txt
File2.txt
File3.txt


regards,
Raymond

 

[Phil Robyn]

Hi All,

Have a list of files in a text file but listed horizontally.


File1.txt file2.txt file3.txt

I would like it to be in a file like

File1.txt
File2.txt
File3.txt


regards,
Raymond

C:\cmd>c:\temp\filelist
File1.txt
file2.txt
file3.txt
file4.txt
file5.txt

C:\cmd>type c:\temp\filelist.cmd
@echo off
for %%a in (
File1.txt file2.txt file3.txt file4.txt file5.txt
) do echo %%a

OR

C:\cmd>c:\temp\filelist File1.txt file2.txt file3.txt file4.txt file5.txt
File1.txt
file2.txt
file3.txt
file4.txt
file5.txt

C:\cmd>type c:\temp\filelist.cmd
@echo off
for %%a in (%*) do echo %%a

 

[Dave Patrick]

Or open the .txt file with excel as space delimited, then use the transpose
function.