[SOLVED] Odd extra space, comma, and line feed in bash awk output?

[oshunluvr]

I'm try to write a small bash command to put in ~/.bashrc on a server to identify reagion and city location from the IP address. I am using a program called "ip2locationio" and the command for this is:

ip2locationio -f region_name,city_name -o pretty

which outputs like this:

region_name,city_name
"New Jersey","Jersey City"​

The output I want is:

New Jersey, Jersey City​

so I'm piping the output through awk like this:

ip2locationio -f region_name,city_name -o pretty | awk -F'"' '{print $2,",", $4}'

but for some reason I can't glean I'm getting:

 ,
New Jersey , Jersey City

How do I eliminate that first line?

[oshunluvr]

OK, I got rid of the leading space in the first line by changing to this:

|awk -F'"' '{print $2",", $4}'

Honestly I can live with the extra line feed but I'd like to eliminate the extra comma.

[oshunluvr]

The extra line must come from the fact that the ip2locationio output is two lines. So I trimmed it with tail and now this:

ip2locationio -f region_name,city_name -o pretty |tail -n 1 |awk -F'"' '{print $2",", $4}'

gets me this:

New Jersey, Jersey City

Success!

Still not sure this would work if the place names had one or three or more "words" in them.

[oshunluvr]

I tested it on another IP ans it seems to work:

North Carolina, Greenville

[jlittle]

Generally, awk first uses a pattern to select the lines, awk 'pattern {code}'. It's very like grep, except that grep just prints the matches, awk wants regexes delimited by /, and awk allows expressions as well.

A pattern to select line 2 is NR==2.

Often a regex pattern is more robust, say /^"/.