Extract numbers below words with awk


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extract numbers below words with awk
# 15  
Old 01-14-2009
flyingfish,

First, don't hijack another ones thread but start your own thread.
With the solution of cgkmal you get a space between the first and second line, to avoid this you can use this:

Code:
awk '{printf("%s%s",$0,NR%2?"":ORS)}' file

Quote:
Originally Posted by cgkmal
I´m not completely sure how it works, but it works
Code:
awk 'ORS = NR%2 ? " " : "\n"' Source.txt

Here we use a conditional operator, the syntax is: expr ? action1 : action2

ORS = assign the value to the recordseparator ORS

NR%2 ? " " : "\n"

Here we look for the remainder of the division of the linenumber by 2 with the modulo operator %, odd lines give a 1 (true) and even lines give a 0 (false).
If the operator gives true (odd lines) the ORS is a space, otherwise the ORS is a newline.

Hope this helps.

Regards
# 16  
Old 01-14-2009
Thanks from flyingfish

Worked as magic:

Code:
---------
awk 'ORS = NR%2 ? " " : "\n"' Source.txt > Destination.txt
---------Smilie
# 17  
Old 01-14-2009
Nice know it worked for you flyingfish,

Hi Franklin52,

Know that your explanation helps A LOT!!. I undersand much better the logic
used to solve the conditional part.


Many thanks for your valauble assistance.

Best regards Smilie
# 18  
Old 01-15-2009
maybe you need to replace below with your path, and put script in the same folder with your file Sales.txt

Code:
#! /usr/bin/perl

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Adding numbers matching with words

Hi All, I have a file which looks like this: abc 1 abc 2 abc 3 abc 4 abc 5 bcd 1 bcd 3 bcd 3 bcd 5 cde 7 This file is just a miniature version of what I really have. Original file is some 1 million lines long. I have tried to come up with the code for what I wish to accomplish... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

2. Shell Programming and Scripting

Put numbers against the words

Hi All, I tried to solve this but the result gives me all zeros for one file. I failed to do for all 500 files. I have some 500 files with the extension .dat I have another set of files; 500 in number with extension .dic I created these .dic files by using sort -u from the actual .dat files.... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies

3. Shell Programming and Scripting

Extract words from a pipe

Hello, Currently, I have this output from my application : ------------------------------------------------- Log viewer/Tmp1 (Jun 29 2011 09:48) ------------------------------------------------- BlalbalbaBlalbalba..Blalbalba..Blalbalba..Blalbalba..Blalbalba..Blalbalba..Blalbalba....... (3 Replies)
Discussion started by: acidoangel
3 Replies

4. UNIX for Dummies Questions & Answers

Trying to sort words and numbers associated with them.

Hi. I have a file containing words and numbers associated with them as follows - c 2 b 5 c 5 b 6 a 10 b 16 c 18 a 19 b 21 c 27 a 28 b 33 a 76 a 115 c 199 c 251 a 567 a 1909 (4 Replies)
Discussion started by: maq
4 Replies

5. Shell Programming and Scripting

Difference between words and not between numbers

Hi, Sorry in advance for propably a silly question, but I am a bit lost. On some of the linux job flow I have the following check: if ($file != 1500) then echo ERROR It works ok, all times $file is not equal to 1500 I have the error message. I try to do something similar... (7 Replies)
Discussion started by: essemario
7 Replies

6. Shell Programming and Scripting

Printing the column that begins with certain words/numbers

Hi guys, I have got a file which doesn't have the same number of columns in each line. I would like to print the second column and the one that begins with 33= and has some numbers after '33=' Can you please help me asap? Cheers (7 Replies)
Discussion started by: alexandra_ola
7 Replies

7. Shell Programming and Scripting

Query to print numbers in words

Hi, I have to write a shell script that converts numbers in to words below is what i wrote.My script is not running. ----------------------------------- echo -n "Enter number : " read n len= echo $n | wc -c echo " number in words : " for ( i=1; i<len; i++ ) do num=echo $n... (5 Replies)
Discussion started by: bab123
5 Replies

8. Web Development

Query to print numbers in words

Hi, If i give a number say "1234" the output of mysql query should be: one thousand and twenty four How to write mysql query for this? With regards Vanitha (5 Replies)
Discussion started by: vanitham
5 Replies

9. UNIX for Dummies Questions & Answers

how to separate numbers and words from a file using shell scripts

Hi, How to separate numbers and words(with full alphabets) in a particular file and store it in two different files. Please help me out for this.Using shell scripting. :confused::confused: (1 Reply)
Discussion started by: kamakshi s
1 Replies

10. Shell Programming and Scripting

grep or awk problem, unable to extract numbers

Hi, I've trouble getting some numbers from a html-file. The thing is that I have several html-logs that contains lines like this: nerdnerd, how_old_r_u:45782<br>APPLY: <hour_second> Verification succeded This is some of what I've extracted from a html file but all I really want is the number... (7 Replies)
Discussion started by: baghera
7 Replies
Login or Register to Ask a Question