Two field seperators in awk??

Astro · 11-08-2003, 03:50 PM

Need to parse a file with two different field seperators. Here's an example line form the file...

FOSS:05-23-00:Paper,9.95:Game,45.99:Hub,39.95:Patch Cable,29.95

format is name:date:item,price...etc

there can be any # of item,price's at the end

in the beginning of the awk script the field seperator needs to be set to ":" for the main seperation of the fields.... but how can I extract the items and prices based on the "," field seperator??

dkloes · 11-08-2003, 06:12 PM

Unless I misunderstand what you want:

Extract the field and treat the items separately:
awk -F: '{print $3}' file1 | awk -F, '{print $1, $2}'
Paper 9.95

Astro · 11-09-2003, 10:12 AM

Good idea, but I think I figured out what needed to be done.... did a little reading and found the split operator...

Code:

for (i=3;i<=NF;i++)
{
     split($i,Arr,",")
     total+=Arr[2]
}

Set i=3 cause thats always the first item,price...
<= to the # of fields so it can get the last value
split $i using "," and add it up to get my total.

Arr[2] being the price and Arr[1] being the item...