Windows command for cutting columns from a text

Question

The following content is stored in a file:

chrome.exe                   512 Console                 0     73,780 K
chrome.exe                   800 Console                 0     11,052 K
chrome.exe                  1488 Console                 0     92,720 K
chrome.exe                  1600 Console                 0     32,344 K
chrome.exe                  2240 Console                 0     35,132 K
chrome.exe                  2360 Console                 0     21,276 K
chrome.exe                  3524 Console                 0     66,732 K
chrome.exe                  3924 Console                 0     23,524 K

Is there a way to extract the 5th column with the Windows command line?

Something like the UNIX cut command.

score 8 · Answer 1 · edited Dec 14 '20 at 07:10

8

Use double % in variable

for /f "tokens=5 delims= " %%i in (file.txt) DO echo %%i

edited Dec 14 '20 at 07:10

wscourge

10,657
14
59
80

answered Dec 14 '10 at 17:26

Sonny Saluja

7,193
2
25
39

Long time to pump up this thread, after ran like as your code, I got on my Windows 10: %%i was unexpected at this time. – tquang Feb 14 '23 at 05:32

score 6 · Answer 2 · answered Dec 14 '10 at 17:03

6

If you're familiar with the GNU cut utility, you might be better off using the Win32 port:

http://gnuwin32.sourceforge.net/packages/coreutils.htm

answered Dec 14 '10 at 17:03

bcosca

17,371
5
40
51

Similarly I found it easy to use use [Cmder](https://cmder.net/) which already has many unix commands installed. – Ivo Merchiers Aug 08 '19 at 11:45

score 3 · Answer 3 · edited Oct 09 '15 at 15:14

3

@ECHO OFF

for /F "tokens=2-4" %%a in (%1) DO ( echo %%a %%b %%c )

took me a long time to find out that %%a %%b %%c .... [%%z] refer to subsequent colums in a text file. So this example will extract the 2nd, 3rd and 4th column (word) from a textfile (%1).

edited Oct 09 '15 at 15:14

Walery Strauch

6,792
8
50
57

answered Oct 09 '15 at 14:55

missing awk

31
1

score -1 · Answer 4 · answered Mar 10 '21 at 11:39

-1

You can also use mobaxterm (https://mobaxterm.mobatek.net/) a ssh client, and open a local terminal. It contain unix comands like cut, grap, wc ,etc

answered Mar 10 '21 at 11:39

adilazh1

29
1

knb · Answer 5 · 2010-12-14T17:13:36.033

-3

If you had perl installed:

perl.exe -na  -e "print qq{$F[4]\n}" < myfile.txt

edited Dec 14 '10 at 17:13

answered Dec 14 '10 at 17:05

knb

9,138
4
58
85

2

If you had... isn't helpful. I'm sure poster could write code in any language to do it but that's not the question being asked. – Scala Enthusiast Apr 27 '18 at 08:31

Windows command for cutting columns from a text

5 Answers5

Linked