cut out specific fields from text file [duplicate]

Question

I have a text file with 9 fields separated by :

survey:m1111771::rent:travel:::Morning:

How do I pull field 1 and 8 only to a separate file

for example it would look like this,

survey:Morning

KM. · Accepted Answer · 2016-05-19 00:18:18Z

2

One of many ways:

$ awk -F: '{print $1":"$8}' <file>
survey:Morning

and as @cas as pointed out, where OFS is the "Output Field Separator"

$ awk -F: -v OFS=: '{print $1,$8}'
survey:Morning

answered May 18, 2016 at 17:01

KM.

2,1842 gold badges18 silver badges25 bronze badges

1

hard-coding a single double-quoted : character is OK when you're only printing two fields, but it gets tedious and error-prone very quickly if you want to print more fields. It's better to set the Output Field Separator (OFS) to :. e.g. awk -F: -v OFS=: '{print $1,$8}'. hard-coding it is also a pain if you ever want to change it (e.g. to a tab or a comma), as you'd then have to manually change every occurrence.
– cas
May 19, 2016 at 0:14

Add a comment |

magor · Accepted Answer · 2016-05-18 18:29:25Z

1

Another version using cut :

cut -d: -f1,8 file > newfile

answered May 18, 2016 at 18:29

magor

3,5822 gold badges11 silver badges27 bronze badges

Add a comment |

2 Answers 2