deharvy
asked on
Parse Data to Get Value
Here is my data:
type=bike,color=red,price=
type=car,style=sport,color
type=plane,color=silver,pr
Need a simple script that grabs value of color. Output should be:
red
blue
silver
Thanks for your assistance.
type=bike,color=red,price=
type=car,style=sport,color
type=plane,color=silver,pr
Need a simple script that grabs value of color. Output should be:
red
blue
silver
Thanks for your assistance.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Correction:
cat file | sed -n -e '/color=/s/.*color=\([^,]*
cat file | sed -n -e '/color=/s/.*color=\([^,]*
If there's no fixed order:
awk -F"color=" '{print $2}' inputfile | sed 's/,.*//'
wmp
awk -F"color=" '{print $2}' inputfile | sed 's/,.*//'
wmp
With gawk only (no piping):
gawk '{ if (match($1, /color=(\w+)/, matches) != 0) print matches[1]; }' INPUTFILE
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Well i might be wrong but if you have line with color= missing in it you will print the whole line in your solution and you will print nothing in mine.
Hi a1j,
Good point. I'll try again.
Is there any reason why your solution:
cat file | sed -n -e '/color=/s/.*color=\([^,]*
shouldn't be simplified to this:
sed -n 's/.*color=\([^,]*\).*/\1/
?
It works with the data supplied, and also if there is no color= in the line.
Good point. I'll try again.
Is there any reason why your solution:
cat file | sed -n -e '/color=/s/.*color=\([^,]*
shouldn't be simplified to this:
sed -n 's/.*color=\([^,]*\).*/\1/
?
It works with the data supplied, and also if there is no color= in the line.
This should work fine. It is all matter of style/habits now.
ASKER
Final solution:
sed -n 's/.*color=\([^,]*\).*/\1/
------------------
awk -F appears to only support one character delimiter.
------------------
Thanks everyone for your responses and your assistance.
sed -n 's/.*color=\([^,]*\).*/\1/
------------------
awk -F appears to only support one character delimiter.
------------------
Thanks everyone for your responses and your assistance.
OK, thanks a1j.
My habit is to be as lazy/simple/concise as possible (except where that causes significant problems).
My habit is to be as lazy/simple/concise as possible (except where that causes significant problems).
No problem, deharvy.
We'll send you the bill.
We'll send you the bill.
>> awk -F appears to only support one character delimiter. <<
Either you have a very (very!) strange implementation of awk or you didn't even test my solution.
Either you have a very (very!) strange implementation of awk or you didn't even test my solution.
Linux
Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.
71K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Open in new window