Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Selecting awk output depending on grep result
Top Forums Shell Programming and Scripting Selecting awk output depending on grep result Post 302658039 by takada on Monday 18th of June 2012 03:36:30 PM
Old 06-18-2012
Sorry for not being clear. It is not the number of fields that matters in each line. I added the line numbers below so that they can be easily referred. They are not part of the file content.

There are basically two formats. One format contains the user's last/first names and UID, e.g. lines 1, 2, 3 and 6. The second format contains only the UID (that is useful), e.g. lines 4 and 5. The second format appears when the user in the above line has more than one UID's in the system. So in the result of the script, I want that user name repeated with additional UID's rather than being omitted (as in the original file). Does this make sense?

I also did not make it clear that in the lines in the second format, the UID's always appear in the same field, $4, e.g. lines 4 and 5. So I want to repeat $8 and $12 from the directly above line (line 3), and print $4 for lines 4 and 5.

If saying $4 is a number is not ideal, $5 in the second format always contains the exact same string, blah in this case in lines 4 and 5.

1 "pippo","is fat","last","Cruise","first","Tom","UID","1234","is 50 years old"
2 "monky","looks funky","last","Jones","first","Catherine Zeta","UID","2345","is still hot"
3 "lion","rules savannah","last","Baldwin","first","Alec","UID","3456","his brother sued costner and lost"
4 "taco","4567","blah","age of rock"
5 "chili","5678","blah","flopped bit time"
6 "mojito","tastes awesome","last","Brand","first","Russell","UID","6789","didn't deserve katy"
 

10 More Discussions You Might Find Interesting

1. HP-UX

awk to output cmd result

I was wondering if it was possible to tell awk to print the output of a command in the print. .... | awk '{print $0}' I would like it to print the date right before $0, so something like (this doesn't work though) .... | awk '{print date $0}' (4 Replies)
Discussion started by: IMTheNachoMan
4 Replies

2. Shell Programming and Scripting

Selecting patterns from the results of grep

Hi All, I'm struggling with a problem that I'm wondering (and hoping!) that someone can help me with. I have a number of .xml files which I'm using grep to search for the string 'include'. I need to extract the value of the include from the grep result. For example, on any given file, I... (2 Replies)
Discussion started by: Steve_altius
2 Replies

3. UNIX for Dummies Questions & Answers

exit status depending on output

Hi I have a script that does a select from a table. I want the script to return a 0 status if a specific column has 'OK' value or return 1 if this column returns 'NOT OK'. The output now is similar to: COL1 COL2 STATUS ------- --------- ------- I want to be limited to... (1 Reply)
Discussion started by: melanie_pfefer
1 Replies

4. UNIX for Dummies Questions & Answers

Bash - CLI - grep - Passing result to grep through pipe

Hello. I want to get all modules which are loaded and which name are exactly 2 characters long and not more than 2 characters and begin with "nv" lsmod | (e)grep '^nv???????????? I want to get all modules which are loaded and which name begin with "nv" and are 2 to 7 characters long ... (1 Reply)
Discussion started by: jcdole
1 Replies

5. Shell Programming and Scripting

Redirect output to a different text file depending source of data

I have a list of DNS servers I need to look up information on. Each of these servers has a master and a slave database. Essentially what I need to do is create two text files for each server. One with the Master view and one with the Slave view. There's 20 servers, in the end I should have 40 text... (4 Replies)
Discussion started by: spartan22
4 Replies

6. Shell Programming and Scripting

Output block of lines in a file based on grep result

Hi I would appreciate your help with this. I have a output file from a command. It is broken based on initial of the users. Exmaple of iitials MN & SS. Under each section there is information pertaining to the user however each section can have different number of lines. MY challenge is to ... (5 Replies)
Discussion started by: mnassiri
5 Replies

7. Shell Programming and Scripting

Formatting grep and awk output

Hi there. I have a very large file and I am trying to format it so that I can pull out certain pieces of data/info and report it in spreadsheet format/style. The file has ###### which will separate each line that will be listed in the spreadsheet. Whenever I find "No" at the end of a line I want... (7 Replies)
Discussion started by: kieranfoley
7 Replies

8. Shell Programming and Scripting

Use bash command on awk field and output the result

Hello, I want to run a field from an awk command through a command in bash. For example my input file is 1,2,3 20,30,40 60,70,80 I want tot run $2 thought the command date +%d/%m/%y -d"01/01/15 + $2 days -1 day" and get the output 1,02/01/15,3 20,30/01/15,40 60,11/03/15,80 ... (2 Replies)
Discussion started by: garethsays
2 Replies

9. Shell Programming and Scripting

Compare 2 columns from the same file and print a value depending on the result

Hello Unix gurus, I have a file with this format (example values): label1 1 0 label2 1 0 label3 0.4 0.6 label4 0.5 0.5 label5 0.1 0.9 label6 0.9 0.1 in which: column 1 is a row label column 2 and 3 are values I would like to do a simple operation on this table and get the... (8 Replies)
Discussion started by: ksennin
8 Replies

10. Shell Programming and Scripting

Grep output to file result not as expected

Hi Gurus, I run command grep ABC file1 > file2 against below file. I got all ABC_xxx in one line in file2. I expect to get multiple lines in file2. If I print result in screen, the result is expected. thanks in advance My os is SunOS 5.10 Generic_150400-64 sun4v sparc sun4v ABC_123 XXXXX... (2 Replies)
Discussion started by: green_k
2 Replies

LEARN ABOUT DEBIAN

ipescript

IPESCRIPT(1)						      General Commands Manual						      IPESCRIPT(1)

NAME

       ipescript - Run an Ipe script (written in Lua)

SYNOPSIS

       ipescript script { arguments }

DESCRIPTION

       ipescript  runs	an Ipe script written in Lua.  The Ipe bindings are automatically available in the script.  Ipescript looks for the script
       in any of the script directories.

       The script argument should not contain the .lua extension.

ENVIRONMENT VARIABLES

       ipescript respects the following environment variables:

       IPELATEXDIR
	      the directory where ipetoipe runs Pdflatex.

       IPESCRIPTS a list of directories where Ipescript will look for
	      scripts.	When this variable is not set, Ipe searches first the current directory, then ~/.ipe/scripts, and finally the  system-wide
	      Ipe script directory.  When this variable is set, it should contain a list of directories, separated by semicolons.  A single under-
	      score is replaced by the system-wide Ipe script directory.

       IPEDEBUG
	      set this to 1 for debugging output from ipescript.

AUTHOR

       Otfried Cheong

REPORTING BUGS

       Please report bugs using Ipe bugzilla at http://ipe7.sourceforge.net/bugzilla.html

SEE ALSO

       Ipe is documented fully in The Ipe Manual, which is available online at http://ipe7.sourceforge.net/manual/manual.html .

								  August 28, 2011						      IPESCRIPT(1)
All times are GMT -4. The time now is 06:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy