Stripping a record from file. 1

[iangodsell]

Hi,

I am trying to put together a one liner unix script to get the following output.

4,2,774,421
2,7,134

where the original records in a file filename.csv are

4,2,774,421,|3||||Destination|Error Demo|1|12 APR 2002
2,7,134,|1|Lookup Failure|Address_ID|7|Destination|Error Demo|1|12 APR 2002

The best I can get to is
4,2,774,421,
2,7,134,

using

cut -f 1 -d '|' filename.csv

As you can see though, the commas at the end are still there.

Thanks to all in advance.

Regards,

IanG.

 

[vgersh99]

nawk -F "|" '{printf("%s\n", substr($1, 1, length($1)-1))}'

 

[olded]

Hi:

cut -f 1 -d '|' filename.csv|tr -d ,

Regards,

Ed
Schaefer

 

[olded]

Hi:

Sorry, I got rid of all the commas. I should read closer.

Ed

 

[bigoldbulldog]

This should do it...

awk -F ",|" '{print $1}'

Cheers,
ND

 

[Einstein47]

Good job bigoldbulldog. Half the battle with UNIX is recognizing the regular-expression. Too often we can't see the comma for the trees. Einstein47
(Love is like PI - natural, irrational, endless, and very important.)