Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

process field 1 depending on field 6

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting process field 1 depending on field 6
# 8  
Old 07-30-2012
Quote:
Originally Posted by itkamaraj
Code:
 
awk '$6~/^IN$/{print $1}' input.txt | while read jobname; do jd $jobname;done

Hi when tried the command

Code:
 
 
 awk '$6~/^IN$/{print $1}' my_temp.txt

It is not giving any jobs that are in IN state.It is only working with Su status .
can u pls chekc and confirm .

Code:
 
awk '$6~/^SU$/{print $1}' my_temp.txt
fiusdcanlt_fmrbgmusd1_run
fiusdcanlt_fmrbgmusd2_run
fiusdcanlt_fmrbgmusd3_run
fiusdcanlt_fmrbgmusd4_run
fiusdcanlt_fmrcmousd1_run
fiusdcanlt_lbecalusd1_run
fiusdcanlt_fmrslusd1_run
fiusdcanlt_fmrcmbsusd1_run
fiusdcanlt_fmrtbausd1_run
fiusdcanlt_fmrcalusd1_run
ficadcanlt_sccalcad1_run
ficadcanlt_fmrcalcad1_run
ficadcanlt_fmrcmbscad1_run
ficadcanlt_bcgcalcad1_run
fiusdcanlt_fmrfmmusd1_run
fiusdcanlt_lbtcalusd1_run
fiusdcanlt_fmrbmmusd1_run
fiusdcanlt_fmrtbausd2_run
fiusdcanlt_fmrmcrusd1_run
fiusdcanlt_fmrfrmusd1_run
fiusdcanlt_lbtcmbsusd1_run
fiusdcanlt_cgfrmusd1_run
fiusdcanlt_cgcalusd1_run
fiusdcanlt_lbtcalusd2_run
fiusdcanlt_lbmcalusd1_run
fiusdcanlt_lbtfrmusd1_run
fiusdcanlt_fmrcmousd2_run
fiusdcglba_cgcalglb_run
fiusdcglba_fmrcalglb1_run
fiusdcanlt_fmrfrmusd2_run
fiusdcanlt_fmrcalusd2_run
fiusdcanlt_fmrfmmusd2_run
ficadcanlt_fmrcalcad2_run
ficadcanlt_fmrfmmcad2_run
fiusdcanlt_fmrpdwusd1_run
fiusdcglba_fmrcalglb2_run
fiusdcglba_fmrcmbsglb2_run
fiusdcglba_fmrfrmglb2_run
fiusdcglba_fmrhecmglb2_run
fiusdcglba_fmrcmoglb2_run
fiusdcacct_swap_prcs_run
fiusdcanlt_fmrmmmusd1_run
fiusdcanlt_fmrmlrusd1_run
ficadcanlt_fmrmlrcad1_run
ficadcanlt_fmrmmmcad1_run
fiusdcglba_fmrcmoglb3_run
fiusdcoutb_saifrmusd1_run
ficadcanlt_scdascad1_run
ficadnanlt_fmrdascad1_run
fiusdnanlt_lbtdasusd1_run
fiusdcvref_bbg_normal_box
[udeitf@fiappl18dev prabhu]$ awk '$6~/^IN$/{print $1}' my_temp.txt
[udeitf@fiappl18dev prabhu]$ awk '$6~/^RU$/{print $1}' my_temp.txt
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Problem with getting awk to multiply a field by a value set based on condition of another field

Hi, So awk is driving me crazy on this one. I have searched everywhere and read man, docs and every related post Google can find and still no luck. The actual files I need to run this on are sensitive in nature, but it is the same thing as if I needed to calculate weighted grades for multiple... (15 Replies)
Discussion started by: cotilloe
15 Replies

2. Shell Programming and Scripting

awk to update field using matching value in file1 and substring in field in file2

In the awk below I am trying to set/update the value of $14 in file2 in bold, using the matching NM_ in $12 or $9 in file2 with the NM_ in $2 of file1. The lengths of $9 and $12 can be variable but what is consistent is the start pattern will always be NM_ and the end pattern is always ;... (2 Replies)
Discussion started by: cmccabe
2 Replies

3. Shell Programming and Scripting

awk to adjust coordinates in field based on sequential numbers in another field

I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines. If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line... (3 Replies)
Discussion started by: cmccabe
3 Replies

4. Shell Programming and Scripting

awk to parse field and include the text of 1 pipe in field 4

I am trying to parse the input in awk to include the |gc= in $4 but am not able to. The below is close: awk so far: awk '{sub(/\|]+]++/, ""); print }' input.txt Input chr1 955543 955763 AGRN-6|pr=2|gc=75 0 + chr1 957571 957852 AGRN-7|pr=3|gc=61.2 0 + chr1 970621 ... (7 Replies)
Discussion started by: cmccabe
7 Replies

5. Shell Programming and Scripting

Display combination of 4 field uniqe record and along with concatenate 5th and 6th field.

Table ACN|NAME|CITY|CTY|NO1|NO2 115|AKKK|ASH|IND|10|15 115|AKKK|ASH|IND|20|20 115|AKKK|ASH|IND|30|35 115|AKKK|ASH|IND|30|35 112|ABC|FL|USA|15|15 112|ABC|FL|USA|25|20 112|ABC|FL|USA|25|45 i have written shell script using cut command and awk programming getting error correct it and add... (5 Replies)
Discussion started by: udhal
5 Replies

6. Shell Programming and Scripting

Command/script to match a field and print the next field of each line in a file.

Hello, I have a text file in the below format: Source Destination State Lag Status CQA02W2K12pl:D:\CAQA ... (10 Replies)
Discussion started by: pocodot
10 Replies

7. Linux

How do I format a Date field of a .CSV file with multiple commas in a string field?

I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below: column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10 "12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Discussion started by: dhruuv369
3 Replies

8. Shell Programming and Scripting

AWK: Pattern match between 2 files, then compare a field in file1 as > or < field in file2

First, thanks for the help in previous posts... couldn't have gotten where I am now without it! So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following: If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies

9. Shell Programming and Scripting

awk, comma as field separator and text inside double quotes as a field.

Hi, all I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes. sample input: for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Discussion started by: kevintse
8 Replies

10. Shell Programming and Scripting

Sort alpha on 1st field, numerical on 2nd field (sci notation)

I want to sort alphabetically on the first field and sort in descending numerical order on the 2nd field. With a normal "sort -r -n" it does this: abc ||| 5e-05 ||| bla abc ||| 3 ||| ble def ||| 1 ||| abc def ||| 0.2 ||| def As you can see it ignores the fact that 5e-05 is actually 0.00005... (1 Reply)
Discussion started by: FrancoisCN
1 Replies
Login or Register to Ask a Question