DosTips.com

Ok I noticed the problem with both of you codes, they don't allow for a empty/null column entry. Is there any way to fix this?

Simpler : @echo off (for /F "tokens=1-5" %%a in (input.txt) do ( if "%%e" neq "" ( echo %%a %%b %%c %%d:%%e ) else ( echo %%a %%b %%c:%%d ) )) > output.txt Just be sure to insert the proper separators in echo command in each case: a TAB after %%a and %%c and a space af...

elzooilogico wrote:My fault, I didn't read carefully. I've seen a delimiter and assumed they were all the same. Then, this should do the job, as the only valid delimiter is tab.

You are amazing, it works perfectly!

I have a very large tab-delimited text file with 4 columns and many rows. I want a batch file to replace the third tab on each row with a colon. Here is an example of input and desired output: input(always 4 columns): username[tab]firstname[space]lastname[tab]email[tab]number username[tab]firstname...

I have a very large tab-delimited text file with 4 columns and many rows. I want a batch file to replace the third tab on each row with a colon. Here is an example of input and desired output: input(always 4 columns): username[tab]firstname[space]lastname[tab]email[tab]number username[tab]firstname[...