awk or cut

anypager · #1 (**permalink**) 08-17-2007

select some fields from data file (source.csv)
The data in file(source.csv) is like
"x1,2",,"y",,"z"

How to get the 1st, 2nd and 3rd field from the file. Using awk or cut?

Note: "x1,2" is one field.

thanks,

ranj@chn · #2 (**permalink**) 08-17-2007

Code:

echo "x1,2",,"y",,"z" | awk -F',,' '{print $1,$2,$3}'

rexf · #3 (**permalink**) 08-17-2007

Thus your solution is incorrect.

namishtiwari · #4 (**permalink**) 08-17-2007

Quote:

Originally Posted by ranj@chn

Code:

echo "x1,2",,"y",,"z" | awk -F',,' '{print $1,$2,$3}'

This is only going to print x1,2 not the desired output.
I tried this with cut also but the delimeter ,, its not taking here.

robotronic · #5 (**permalink**) 08-17-2007

ranj's solution is correct, you get an incorrect result maybe because of your awk version. Try using "nawk" on solaris or "gawk":

Code:

echo "\"x1,2\",,\"y\",,\"z\"" | nawk -F',,' '{print $1,$2,$3}'

Output:
"x1,2" "y" "z"

dennis.jacob · #6 (**permalink**) 08-17-2007

If "x1,2",,"y",,"z" is the kind of format of all records in csv file and ",," is considered as delim, the below one should work.

Code:

sed 's/\(.*\),,\(.*\),,\(.*\)/\1 \2 \3/' file

anypager · #7 (**permalink**) 08-19-2007

"x1,2",,"y",,"z" is just an example of the format. what if "x1,2",,"y",,,"z",,,?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: