In Linux command line console, how to get the sub-string from a file?

Question

The content of the file is fixed.

Example:

2016-03-28T00:02 AAA 2016-03-28T00:03  ADASDASD
2016-03-28T00:03 BBB 2016-03-28T00:04  FAFAFDAS
2016-03-28T00:05 CCC 2016-03-28T00:06  SDAFAFAS
....

Which command can I use to get all sub-strings, AAA, BBB, CCC, etc.

use [grep](http://www.gnu.org/software/grep/manual/grep.html) command — Billal Begueradj, Mar 30 '16 at 13:26
@BillBEGUERADJ how would you use `grep`? He wants to get all the substrings, not search for a string of text. — birdoftheday, Mar 30 '16 at 13:29
Possible duplicate of [How to use sed to extract substring](http://stackoverflow.com/questions/16675179/how-to-use-sed-to-extract-substring) — Julien Lopez, Mar 30 '16 at 13:33

score 2 · Answer 1 · answered Mar 30 '16 at 15:06

you can use cut and awk and perl for this.

cat >> file.data << EOF
2016-03-28T00:02 AAA 2016-03-28T00:03  ADASDASD
2016-03-28T00:03 BBB 2016-03-28T00:04  FAFAFDAS
2016-03-28T00:05 CCC 2016-03-28T00:06  SDAFAFAS
EOF

AWK

awk '{ print $2 }' file.data
AAA
BBB
CCC

CUT

cut -d " " -f2 file.data
AAA
BBB
CCC

PERL

perl -alne 'print $F[1] ' file.data 
AAA
BBB
CCC

birdoftheday · Answer 2 · 2016-03-30T13:33:04.177

0

You can use AWK for this:

jayforsythe$ cat > file
2016-03-28T00:02 AAA 2016-03-28T00:03 ADASDASD
2016-03-28T00:03 BBB 2016-03-28T00:04 FAFAFDAS
2016-03-28T00:05 CCC 2016-03-28T00:06 SDAFAFAS
jayforsythe$ awk '{ print $2 }' file
AAA
BBB
CCC

To save the result to another file, simply add the redirection operator:

jayforsythe$ awk '{ print $2 }' file > file2

edited Mar 30 '16 at 13:33

answered Mar 30 '16 at 13:28

birdoftheday

806
7
13

how to save the result to another file? Thanks,@stanpines – RhysJ Mar 30 '16 at 13:32
@RhysJ anytime! If you liked my answer, do you mind pressing the checkmark to mark the question as solved? – birdoftheday Mar 30 '16 at 13:34

score 0 · Answer 3 · edited Mar 30 '16 at 13:32

0

You can use cut:

cut -d' ' -f 2 file

edited Mar 30 '16 at 13:32

birdoftheday

806
7
13

answered Mar 30 '16 at 13:29

demosito

213
1
6

1

or, without the `cat`, `cut -d' ' -f2 file` – karakfa Mar 30 '16 at 13:30

In Linux command line console, how to get the sub-string from a file?

3 Answers3

AWK

CUT

PERL