awk one liner

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk one liner
# 1  
Old 10-01-2009
awk one liner

a  100  200  300
b  400  10

a  100  
a  200  
a  300
b  400
b  10

# 2  
Old 10-01-2009
Are you writing any book on awk oneliner or testing forum members skill set...??
Just kidding here you go..
awk '{split($0,A)}{for(i=2;i<=NF;i++){print A[1]" "A[i]}}' filename

# 3  
Old 10-01-2009
Always I would try to go with or write precise answers for any problems I come across.
actually I tried solving the problem above for a while. But quiet didn't get it though managed with some ugly code. Finally I posted with lot of hesitation.

In last post post I solved my problem my self and posted along with the problem. (some one moked at my code coz its bit ugly). Anways he gave the best code.

this forums helps me understanding awk and others but some times finding hard at the attitude of few.(you not on the list haha)
# 4  
Old 10-01-2009
#  awk '{for (i=2;i<=NF;i++){print $1,$i}}' infile
a 100
a 200
a 300
b 400
b 10

# 5  
Old 10-01-2009
awk '{
  for (i=2; i<=NF; i++)
    print $1, $i
    }' infile

Edit: Just saw Tytalus already provided the same answer.
# 6  
Old 10-01-2009
@radoullov ##How could I give you bonus points. yesterday I have seen some one credited with bonus points for answering my post.
You been really helpful every time.
Mr.Vidya is already in Moderator mode. but kudos to him too
# 7  
Old 10-01-2009
perl -ane'
  print map "$F[0] $_\n", @F[1..$#F]
  ' infile

---------- Post updated at 11:36 AM ---------- Previous update was at 11:32 AM ----------

Originally Posted by repinementer
@radoullov ##How could I give you bonus points.[...]
By clicking on this link Smilie
But don't worry, managing to provide a correct answer is enough for me.
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="" rem="1000" type="aaa" srv="server1" usr="user1"/> <app usr="user2" srv="server2" rem="1001" type="aab" addr=""/>What's the most efficient awk... (2 Replies)
Discussion started by: cabrao
2 Replies

2. UNIX for Dummies Questions & Answers

awk or sed one liner

I have a data base of part numbers: AAA Thing1 BBB Thing2 CCC Thing3 File one is a list of part numbers: XXXX AAA234 XXXX BBB678 XXXX CCC2345 Is there a sed one-line that would compare a data base with and replace the part numbers so that the output looks like this? XXXX AAA234... (7 Replies)
Discussion started by: jimmyf
7 Replies

3. 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... (6 Replies)
Discussion started by: shell_boy23
6 Replies

4. Shell Programming and Scripting

figuring out an awk one liner

I have googled around a bit and could not find an answer to how this works: echo $STRING | awk '$0=$NF' FS= I know what each part is doing. The record is being set to equal the last field and the field separator is being set to null so that each character is considered a field. Why can FS= be... (4 Replies)
Discussion started by: benalt
4 Replies

5. 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... (9 Replies)
Discussion started by: verge
9 Replies

6. 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... (4 Replies)
Discussion started by: palex
4 Replies

7. 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 (3 Replies)
Discussion started by: kenneth.mcbride
3 Replies

8. Shell Programming and Scripting

grep-awk one liner help

Hi guys, I'm trying to create a one line command that does the following. I will post my command first so you can get the idea better: ls -larht | awk '{print $4}' | uniq | xargs grep * __________ ls -larht | awk '{print $4}' | uniq This will post the name of the groups of each file... (2 Replies)
Discussion started by: erick_tuk
2 Replies

9. 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" (3 Replies)
Discussion started by: kenneth.mcbride
3 Replies

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... (4 Replies)
Discussion started by: kishal
4 Replies
Login or Register to Ask a Question