Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk conditional output

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk conditional output
# 1  
Old 01-09-2015
awk conditional output
Hello,
How can I use a conditional to produce an output file that varies with respect to the contents of column #4 in the data file:

Data file:
Code:
9780020080954   9.95    0.49    AS       23.3729
9780020130857   9.95    0.49    AS       23.3729
9780023001406   22.20   0.25    AOD       42.4725
9780023008207   72.40   0.25    AOD       104.595
9780023012617   74.80   0.25    AOD       107.565

Desired output:
Code:
9780020080954   9.95    0.49    Text1
9780020130857   9.95    0.49    Text1
9780023001406   22.20   0.25    Text2
9780023008207   72.40   0.25    Text2
9780023012617   74.80   0.25    Text2


Thanks very much!
# 2  
Old 01-09-2015
How about giving us an English description of what is supposed to happen? How about giving us an English description of the contents of the input file?

Is the input sorted in reverse order on field 4?

Is the string Text literal, or is there some table of output text strings to be produced?

Is the number after Text supposed to toggle between 1 and 2 every time the content of field 4 changes? Or, is some other algorithm to be used?
# 3  
Old 01-09-2015
Hi Don,
Sorry for the ambiguity. I simply need two different strings in the output file (Text1 or Text2) depending upon the string that is in column #4 of the data file.
# 4  
Old 01-09-2015
your requirement makes no sense...

hope this helps, delete the last column if you want..

Code:
 
 $ cat tmp
9780020080954   9.95    0.49    AS       23.3729
9780020130857   9.95    0.49    AS       23.3729
9780023001406   22.20   0.25    AOD       42.4725
9780023008207   72.40   0.25    AOD       104.595
9780023012617   74.80   0.25    AOD       107.565

$ awk -v c=0 '{ if ($4!=b){c=c+1;b=$4} $4="Text"c  }1' tmp
9780020080954 9.95 0.49 Text1 23.3729
9780020130857 9.95 0.49 Text1 23.3729
9780023001406 22.20 0.25 Text2 42.4725
9780023008207 72.40 0.25 Text2 104.595
9780023012617 74.80 0.25 Text2 107.565

# 5  
Old 01-09-2015
I agree with senhia83 that your requirements seem nonsensical, but to randomly change all occurrences of any particular value in field #4 into Text1 or Text2 no matter how many different values appear in field #4 and to get the spacing that you specified in your output, you could try something like:
Code:
awk '
{	if(!($4 in t)) t[$4] = tc = 1 - tc
	printf("%-16s%-8.2f%-8.2fText%d\n", $1, $2, $3, 2 - t[$4])
}' data

If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk, /usr/xpg6/bin/awk, or nawk.

With the following contents in the file named data:
Code:
9780020080954   9.95    0.49    AS       23.3729
9780020130857   9.95    0.49    AS       23.3729
9780023001406   22.20   0.25    AOD       42.4725
9780023008207   72.40   0.25    AOD       104.595
9780023012617   74.80   0.25    AOD       107.565
3rdCol4Val	123.45	1.23	Val3	who cares
4thCol4Val	987.65	9.87	Val4
3rdCol4Val	123.45	1.23	Val3	who cares
4thCol4Val	987.65	9.87	Val4

the above awk script produces the output:
Code:
9780020080954   9.95    0.49    Text1
9780020130857   9.95    0.49    Text1
9780023001406   22.20   0.25    Text2
9780023008207   72.40   0.25    Text2
9780023012617   74.80   0.25    Text2
3rdCol4Val      123.45  1.23    Text1
4thCol4Val      987.65  9.87    Text2
3rdCol4Val      123.45  1.23    Text1
4thCol4Val      987.65  9.87    Text2

# 6  
Old 01-10-2015
I am confusing everyone... my sincere apologies.
Basically, the string in column #4 is always AS or AOD.

If it is AS, I basically need to write several fields of that line, with one of the fields being "A string of text".

If it is AOD, I basically need to write several fields of that line, with one of the fields being "A different string of text".

I hope that clarifies... sorry again!
# 7  
Old 01-10-2015
Quote:
Originally Posted by palex
I am confusing everyone... my sincere apologies.
Basically, the string in column #4 is always AS or AOD.

If it is AS, I basically need to write several fields of that line, with one of the fields being "A string of text".

If it is AOD, I basically need to write several fields of that line, with one of the fields being "A different string of text".

I hope that clarifies... sorry again!
We have shown you various ways to process your previous ambiguous requests. Can you use them as a starting point to solve this problem on your own now?

Please show us what you have tried, and if you still can't get it to work, we'll be happy to help you clean up your code so it does what you want it to do.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Multi-conditional IF - awk

I have a 6 column array with 2 million rows that looks like this: 1 1089699 rs6686003 G A g 1 1090557 rs7553429 A C c 1 1094738 rs4970362 A G a 1 1099342 rs9660710 A C c 1 1106473 rs4970420 G A a 1 1108637 rs4970421 G A g 1 1119858 rs1320565 C T c 1... (5 Replies)
Discussion started by: Geneanalyst
5 Replies

2. Shell Programming and Scripting

Sending sql output to email body with conditional subject line

hi , i have written below piece of code to meet the requirement but i am stuck in the logic here. the requirement are: 1) to send the sql out put to email body with proper formatting. 2) if count_matching = Yes then mail should triggered with the subject line ... (10 Replies)
Discussion started by: itzkashi
10 Replies

3. Shell Programming and Scripting

Conditional output redirection

Hi there, I'm in a coding mood! I've come through many ways of conditionally redirect the output of a script like: ] || exec &> /dev/nullBut my goal is slightly different. I would like to conditionally redirect the output of a command depending on the status of the command itself: if !... (6 Replies)
Discussion started by: chebarbudo
6 Replies

4. Shell Programming and Scripting

awk - read from a file and write conditional output

I have a file, which has '|' as separator; I need to read each line from that file and produce output to another file. While reading, I have certain condition on few specific columns (like column3 ='good'); only those lines will be processed. (3 Replies)
Discussion started by: mady135
3 Replies

5. Shell Programming and Scripting

Help with conditional clauses for script output

Hello. I am new this site as well as new to shell scripting and this is my first form... Please help me with the following shell script. I am executing a shell script to run every 15 min (scheduled in cronjob) and it gives an output in an output file which is e-mailed. CONCCOUNT=`cat... (1 Reply)
Discussion started by: Jamessteevens
1 Replies

6. Shell Programming and Scripting

Conditional awk

Hello All, I have a file like this: bash-3.00$ cat 1.txt 201112091147|0|1359331220|1025 201112091147|0|1359331088|1024 201112091144|0|1359331172|1025 201112091147|0|1359331220|1021 201112091149|0|1359331088|1027 201112091144|0|1359331172|1029 and a list of MSISDNs in another file... (9 Replies)
Discussion started by: EAGL€
9 Replies

7. Shell Programming and Scripting

awk conditional find

Hi, I have a file in the following format: aabbba 25.31806899 baaabb 38.21808852 cccccu 1.31819523 552258121.31818253 ffddybb 5.41815555 almcamc87561812689 223aqas5.661828345 adacaaaaaaa1821285 adacaaaaaaa1821286 smckaa 3.81828756 ada2512510c1821287 ada2522511c1821328... (4 Replies)
Discussion started by: alex2005
4 Replies

8. Shell Programming and Scripting

AWK conditional addition

I have a column of numbers $2, I would like to add 360 to all numbers that are negative. This method seems a bit convoluted, and does not work (outputs 0): BEGIN { A=sprintf("%d", $2); if(A<0) A=A+360; BIN++; } END { for(A in BIN) print... (5 Replies)
Discussion started by: chrisjorg
5 Replies

9. Shell Programming and Scripting

Awk Conditional

Hi Guys, i have this files: xyz20080716.log opqrs20080716.log abcdef20080716.log xyz20080717.log oprs20080717.log abcde20080717.log currentdate: 20080717.log I want to make script to zip the file for past day. Can anyone help for this? i've just learn awk scripting & still confused with... (3 Replies)
Discussion started by: icy_blu_blu
3 Replies

10. Shell Programming and Scripting

AWK - conditional cause

Hello guys, I want to make a conditional cause in the following file using awk: awk '{ if ($2 != 0) print $1, $2, $3}' test.csv > test2.csv FILE EXAMPLE = test.csv string,number,date abc,0,20050101 def,1,20060101 ghi,2,20040101 jkl,12,20090101 mno,123,20020101 ... (2 Replies)
Discussion started by: Rafael.Buria
2 Replies
Login or Register to Ask a Question