Combine these two into one liner awk?

Login or Register to Ask a Question and Join Our Community

Combine these two into one liner awk?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting Combine these two into one liner awk?

11-07-2012

Registered User

30, 1

Join Date: Nov 2010

Last Activity: 24 June 2014, 9:53 AM EDT

Posts: 30

Thanks Given: 15

Thanked 1 Time in 1 Post

Combine these two into one liner awk?

ignore the simplicity of the foo file, my actual file is much more hardcore but this should give you the jist of it. need to combine the two awks into one liner. essentially, need to return the value of one particular field in a file that has multiple comma separated fields. thanks guys

Code:

cat foo
make,model,engine,trim,value
bmw,530,3.0,sport,20000
merk,E180,1.8,amg,16000

head -n1 foo|awk -F, '{for(i=1;i<=NF;i++)if($i==v)print i}' v=engine
3
cat foo |awk -F, '{print $1 " "$3}' 
bmw 3.0
merk 1.8

jack.bauer

View Public Profile for jack.bauer

Find all posts by jack.bauer

11-07-2012

Registered User

334, 87

Join Date: May 2011

Last Activity: 30 May 2018, 2:26 AM EDT

Posts: 334

Thanks Given: 39

Thanked 87 Times in 86 Posts

Is this what you're trying to do?

Code:

 
awk -F, 'NR==1{for(i=1;i<=NF;i++)if($i==v)c=i};NR>1{print $1" "$c}' v=engine foo

This User Gave Thanks to Subbeh For This Post:

Subbeh

View Public Profile for Subbeh

Find all posts by Subbeh

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk one liner

The below code is a simple modified sample from a file with millions of lines containing hundreds of extra columns xxx="yyy" ... <app addr="1.2.3.4" rem="1000" type="aaa" srv="server1" usr="user1"/> <app usr="user2" srv="server2" rem="1001" type="aab" addr="1.2.3.5"/>What's the most efficient awk...

2. Shell Programming and Scripting

HELP with AWK one-liner. Need to employ an If condition inside AWK to check for array variable ?

Hello experts, I'm stuck with this script for three days now. Here's what i need. I need to split a large delimited (,) file into 2 files based on the value present in the last field. Samp: Something.csv bca,adc,asdf,123,12C bca,adc,asdf,123,13C def,adc,asdf,123,12A I need this split...

3. Shell Programming and Scripting

Search & Replace regex Perl one liner to AWK one liner

Thanks for giving your time and effort to answer questions and helping newbies like me understand awk. I have a huge file, millions of lines, so perl takes quite a bit of time, I'd like to convert these perl one liners to awk. Basically I'd like all lines with ISA sandwiched between...

4. Shell Programming and Scripting

Awk one-liner?

Hello, I have two files... File #1 1 3 2 5 File #2 3 5 3 1 3 7 9 1 5 2 5 8 3 3 1 I need to extract all lines from File #2 where the first two columns match each line of File #1. So in the example, the output would be: 1 3 7 2 5 8 Is there a quick one-liner that would...

5. UNIX for Dummies Questions & Answers

need an awk one liner

example input file: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

6. Shell Programming and Scripting

combine multiple finds into 1-liner

How to combine 3 find statements into 1-liner? find statements: cd ${dir1} ; find . ! -name . -prune -type f | xargs file | grep -i ascii | cut -f1 -d: | xargs grep -l "${searchtxt}" cd ${dir2} ; find . ! -name . -prune -type f | xargs file | grep -i ascii | cut -f1 -d: | xargs grep -l...

7. Shell Programming and Scripting

combine 2 awks statement into 1 liner

Using these 2 comands to concatenate both outputs into single file: cat testdata | awk 'BEGIN { FS="\n"; RS=""; } /<pattern1>/ {print}' > testdata1 cat testdata| awk '/<pattern2>/,EOF' >> testdata1 is it possible to combine both "awk" into 1-liner? pls advise and thanks in advance.

8. UNIX for Dummies Questions & Answers

awk one liner

I need a one liner to" find /pattern/ print from x lines before "pattern" to y lines after "pattern"

9. Shell Programming and Scripting

awk one liner

input a 100 200 300 b 400 10 output a 100 a 200 a 300 b 400 b 10 Thanx

10. Shell Programming and Scripting

3 files in one awk one liner

I have three files and I have to do something like this:- File A 1232|||1111 0001||| 1232|||2222 0001||| 1232|||4444 0001||| 1232|||4444 0001||| File B 1232|1111 0001|||002222|| 1232|2222 0001|||003333|| 1232|3333 0001|||004444|| File C 1232|002222||| 1232|005555||| Files are...

Login or Register to Ask a Question