How to get second last field from a cut command

unix awk cut
Archit Jain picture Archit Jain · Jul 14, 2013 · Viewed 64.4k times · Source

I have a set of data as input and need the second last field based on deleimiter. The lines may have different numbers of delimiter. How can I get second last field ?

example input

text,blah,blaah,foo
this,is,another,text,line

expected output

blaah
text

Answer

Archit Jain picture Archit Jain · Jul 14, 2013

Got a hint from Unix cut except last two tokens and able to figure out the answer :

cat datafile | rev | cut -d '/' -f 2 | rev

Related questions

How to get first n characters of each line in unix data file

I am trying to get the first 22 characters from a unix data file.Here is my data looks as below. First 12 characters is column 1 and next 10 characters is 2nd column. 000000000001199998000180000 DUMMY RAG # MFR NOT ST 1999980 ZZ- 0 0 0ZZ- 000000000002199998000180000 DUMMY RAG # MFR …

Read More
Printing only the first field in a string

I have a date as 12/12/2013 14:32 I want to convert it into only 12/12/2013. The string can be 1/1/2013 12:32 or 1/10/2013 23:41 I need only the date part.

Read More
how to subset a file - select a numbers of rows or columns

I would like to have your advice/help on how to subset a big file (millions of rows or lines). For example, (1) I have big file (millions of rows, tab-delimited). I want to a subset of this file with only …

Read More