[SOLVED] script to reorder data in a row

rebelbuttmunch · 05-01-2014, 10:24 AM

Quote:

Originally Posted by grail

Well I am curious how your solution has worked? Based on both input sets you provided, none of your awk outputs return accurate data

That was just a pseudo code solution I suppose. I don't want to post the real data as it could be industry sensitive.

grail · 05-01-2014, 10:47 AM

I was not asking for any extra data. What I said was, it does not work with the data as posted or in the current format.

Are you able to alter the data you have presented to show the format it would need to be in to work with your solution?

rebelbuttmunch · 05-01-2014, 11:05 AM

It works because each NVP has is formatted the same i.e name:value, so I can use awk to get the value because each value is preceeded by its name and followed by a comma.

Code:

a=$(echo "Apples :8, Bananas :1, Kiwis: 9, Coconuts: 11" | awk -F'Apples :' '{print $2}' | awk -F',' '{print $1}')
b=$(echo "Apples :8, Bananas :1, Kiwis: 9, Coconuts: 11" | awk -F'Bananas :' '{print $2}' | awk -F',' '{print $1}')

echo "Apples $a, Bananas:$b,"

Apples 8, Bananas:1,

schneidz · 05-01-2014, 11:11 AM

Quote:

Originally Posted by rebelbuttmunch

It works because each NVP has is formatted the same i.e name:value, so I can use awk to get the value because each value is preceeded by its name and followed by a comma.

Code:

a=$(echo "Apples :8, Bananas :1, Kiwis: 9, Coconuts: 11" | awk -F'Apples :' '{print $2}' | awk -F',' '{print $1}')
b=$(echo "Apples :8, Bananas :1, Kiwis: 9, Coconuts: 11" | awk -F'Bananas :' '{print $2}' | awk -F',' '{print $1}')

echo "Apples $a, Bananas:$b,"

Apples 8, Bananas:1,

there must be a typo in your original post which made us think that ':' or ',' could be used as a delimiter for fruit:number groupings.

rebelbuttmunch · 05-01-2014, 11:36 AM

Apologies!