Unix , Delete first column using awk

Question

I have a file named test.txt which has the following content
123,2,1
I want to print the contents of the file without "123,"
I used the following
awk -F, '{print substr($0, index($0, $2))} text.txt'

It doesn't work properly tho, it prints 23,2,1
But when I run it for this text '123,5,1' , it works without a problem (it prints 5,1)

simple awk -F, '{print $2}' file will does the job for you. — Avinash Raj
– Avinash Raj, Commented May 11, 2014 at 13:34
I want to print all columns , it just happened here I have only 2 columns. — user3597432
– user3597432, Commented May 11, 2014 at 13:37

jaypal singh · Accepted Answer · 2014-05-11 13:40:48Z

3

You can use sub() function and remove the first field regardless of what it is.

$ echo '123,2,1' | awk '{sub(/[^,]+,/,"")}1' 
2,1

$ echo '23,2,1' | awk '{sub(/[^,]+,/,"")}1'
2,1

answered May 11, 2014 at 13:40

jaypal singh

77.6k24 gold badges108 silver badges147 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jotne · Accepted Answer · 2014-05-11 13:51:58Z

3

Another awk

echo '123,2,1' | awk -F, '{$1="";sub(/,/,"")}1' OFS=,
2,1

Removes the first field, then the separator.

answered May 11, 2014 at 13:51

Jotne

41.7k13 gold badges54 silver badges58 bronze badges

Comments

Arnaud Le Blanc · Accepted Answer · 2014-05-11 13:41:15Z

2

Use cut:

cut -d, -f2- file

-d, uses , as delimiter, and -f2- prints fields 2 to last.

answered May 11, 2014 at 13:41

Arnaud Le Blanc

100k24 gold badges211 silver badges196 bronze badges

Collectives™ on Stack Overflow

Unix , Delete first column using awk

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related