Output selected columns

@ECHO OFF

FOR /F "usebackq tokens=1,4,8,12,16,20 delims=	" %%A IN ("a text file.txt") DO (
	ECHO %%A,%%B,%%C,%%D,%%E,%%F>>Output.txt
	ECHO %%A,%%B,%%C,%%D,%%E,%%F
)

PAUSE

Select allOpen in new window

dammit renge beet me to the bunch by mere minutes..

Got you ;-)

@zhshqzyc
Please equally split points!

Cheers,
Rene

Thats mighty nice of your ReneGe, cheers!

Well, I am glad to split the points to everybody.

But the question is that we don't know there are how many columns.
I mean that it may have coulmn 4,8,12,16,20,....80.
It also could have 4,8,....200.
It also could have 4,8,12,.....4000

If it is too hard to you, that is okay. Just let me know please.

I feel that it would require VBScript.

Have any ideas Q?

@zhshqzyc

Would it be possible that there could be data in a following empty column?

For example, if "12" is empty, we know for sure that there are no further column.

No empty column, I already used c# to finish it.
If no other way, that' s okay. I will split points soon.

I asked because, I know that it can't be done with a batch file but it most likely can be done with VBScript.

I don't know VBScript, so I was thinking doing a batch file that would do what is required, despite of it's limmitations and asking Q to make an equivalent in VBscript.

Are your happy with your C version?

Cheers,
Rene

Would you mind sharing your c# script?

Glad I could help and thanks for the points.

Cheers,
Rene

Just an FYI, I knew I had code that would better handle the unknown number of tabs somewhere, and I found it, so I just anted to give the author this (UNTESTED) update.

::- Script Name: TabColumnOutput
::- Finds only the selected columns (The first, plus those divisable by four) from a tab deliniated file and outputs them to the command prompt
@ECHO OFF
SETLOCAL EnableDelayedExpansion
SET "SrcFile=C:\Admin\TabFile.txt"
SET "TAB=	"

FOR /F "usebackq tokens=*" %%A IN ("%SrcFile%") DO (
	SET "RawData=%%~A"
	SET "Count=0"
	FOR %%B IN ("!RawData:%TAB%=","!") DO (
		SET /A "Count=!Count!+1"
		SET /A "Div=!Count! %% 4"
		IF !Count!==1 ECHO %%~B
		IF !Div!==0 ECHO , %%~B
	)
)
ENDLOCAL

Select allOpen in new window

Nice script Q! Thanks for sharing ;-)

Thanks ReneGe! =)