Sponsored Content
Top Forums Shell Programming and Scripting Extract numbers below words with awk Post 302276414 by flyingfish on Tuesday 13th of January 2009 04:31:36 PM
Old 01-13-2009
Hi, I'm newby to scripting. Thanks in advance for your input.. I have a flat file like below:
"Mon Jan 7 11:32:25 EST 2008",
291
"Mon Jan 7 12:01:00 EST 2008",
291
"Mon Jan 7 18:01:00 EST 2008",
318
"Tue Jan 8 00:01:00 EST 2008",
357
"Tue Jan 8 06:01:00 EST 2008",
352
"Tue Jan 8 12:01:00 EST 2008",
388
"Tue Jan 8 18:01:00 EST 2008",
387
"Wed Jan 9 00:01:00 EST 2008",
387
"Wed Jan 9 06:01:00 EST 2008",
406
"Wed Jan 9 12:01:00 EST 2008",
403
"Wed Jan 9 18:01:00 EST 2008",
406
"Thu Jan 10 00:01:00 EST 2008",
414
"Thu Jan 10 06:01:00 EST 2008",

I need to merge line 1 and 2, then 3 and 4, to make it become:
"Mon Jan 7 11:32:25 EST 2008", 291
"Mon Jan 7 12:01:00 EST 2008",291
"Mon Jan 7 18:01:00 EST 2008",318
"Tue Jan 8 00:01:00 EST 2008",357
"Tue Jan 8 06:01:00 EST 2008",352
"Tue Jan 8 12:01:00 EST 2008",388
"Tue Jan 8 18:01:00 EST 2008",387
"Wed Jan 9 00:01:00 EST 2008",387
"Wed Jan 9 06:01:00 EST 2008",406
"Wed Jan 9 12:01:00 EST 2008",403
"Wed Jan 9 18:01:00 EST 2008",406
"Thu Jan 10 00:01:00 EST 2008",414
"Thu Jan 10 06:01:00 EST 2008",.......

Any quick way to do it?? Thanks!
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
clacon.f(3)							      LAPACK							       clacon.f(3)

NAME
clacon.f - SYNOPSIS
Functions/Subroutines subroutine clacon (N, V, X, EST, KASE) CLACON Function/Subroutine Documentation subroutine clacon (integerN, complex, dimension( n )V, complex, dimension( n )X, realEST, integerKASE) CLACON Purpose: CLACON estimates the 1-norm of a square, complex matrix A. Reverse communication is used for evaluating matrix-vector products. Parameters: N N is INTEGER The order of the matrix. N >= 1. V V is COMPLEX array, dimension (N) On the final return, V = A*W, where EST = norm(V)/norm(W) (W is not returned). X X is COMPLEX array, dimension (N) On an intermediate return, X should be overwritten by A * X, if KASE=1, A**H * X, if KASE=2, where A**H is the conjugate transpose of A, and CLACON must be re-called with all the other parameters unchanged. EST EST is REAL On entry with KASE = 1 or 2 and JUMP = 3, EST should be unchanged from the previous call to CLACON. On exit, EST is an estimate (a lower bound) for norm(A). KASE KASE is INTEGER On the initial call to CLACON, KASE should be 0. On an intermediate return, KASE will be 1 or 2, indicating whether X should be overwritten by A * X or A**H * X. On the final return from CLACON, KASE will again be 0. Author: Univ. of Tennessee Univ. of California Berkeley Univ. of Colorado Denver NAG Ltd. Date: November 2011 Further Details: Originally named CONEST, dated March 16, 1988. Last modified: April, 1999 Contributors: Nick Higham, University of Manchester References: N.J. Higham, 'FORTRAN codes for estimating the one-norm of a real or complex matrix, with applications to condition estimation', ACM Trans. Math. Soft., vol. 14, no. 4, pp. 381-396, December 1988. Definition at line 115 of file clacon.f. Author Generated automatically by Doxygen for LAPACK from the source code. Version 3.4.1 Sun May 26 2013 clacon.f(3)
All times are GMT -4. The time now is 05:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy