Issue in printing column with gawk

Asked Dec 27 '19 at 14:26

Active Dec 27 '19 at 14:36

Viewed 34 times

This is my data stored as Exist_eutran_freqs.csv:

when I want to print them by below gawk command and switch the col1 and col2, I'm getting below output!

gawk -F'[,]' '{print $2,$1}'  Exist_eutran_freqs.csv

what is the solution for this?

edited Dec 27 '19 at 14:36

jesse_b

asked Dec 27 '19 at 14:26

yashar farzaneh

Cannot reproduce, it works for me. Your field separator is excessive though, you could just do `-F,` or `-F','` – jesse_b Dec 27 '19 at 14:28
I changed but there is no difference.gawk -F, '{print $2,$1}' Exist_eutran_freqs.csv 120 2984 1942 65 206 825 45 – yashar farzaneh Dec 27 '19 at 14:30
1

Is your file a DOS text file? – Kusalananda Dec 27 '19 at 14:30
No It's just simple *.csv file – yashar farzaneh Dec 27 '19 at 14:34
1

Yeah I can reproduce on a file with CRLF line endings – jesse_b Dec 27 '19 at 14:34
Yes, confirmed. If converted to DOS text file format, I get that exact output. Please consider converting your data to Unix text using e.g. `dos2unix Exist_eutran_freqs.csv`. – Kusalananda Dec 27 '19 at 14:36
1

I'm closing this as a duplicate of the question that Jesse_b linked to. Your issue is with the particular line-endings that DOS text files uses. The answers to that other question outlines ways to convert the file to a Unix text file. – Kusalananda Dec 27 '19 at 14:41
@Kusalananda Thanks a lot, with your solution issue solved. file originally has been generated by DOS. – yashar farzaneh Dec 27 '19 at 14:50

0 Answers0