Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Add extra column if no column are less

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Add extra column if no column are less
# 1  
Old 04-21-2013
Add extra column if no column are less
Code:
1	2	3	4	5	6	7	8	9	10	11	12	13	14	15

File A.txt
														
11	LAL01A_1	1213	12	0	0	7	30	2	-122	1	300	14854	5000	2
221	LAL01A_1	1313	14	0	0	7	30	1	-122	2	300	14854	5000	2
12	LAL01A_1	1234	15	0	0	7	30	0	-122	1	300	14854	5000	2

I have file A.txt now i want to use if condition :

if thr total no. of column is 15 then add one more column with n/A
Code:
1	2	3	4	5	6	New Column	8	9	10	11	12	13	14	15	16
															
11	LAL01A_1	1213	12	0	0	n/a	7	30	2	-122	1	300	14854	5000	2
221	LAL01A_1	1313	14	0	0	n/a	7	30	1	-122	2	300	14854	5000	2
12	LAL01A_1	1234	15	0	0	n/a	7	30	0	-122	1	300	14854	5000	2

# 2  
Old 04-21-2013
Code:
awk 'NF==15{$7=$7 OFS "n/a"}1' OFS='\t' A.txt

This User Gave Thanks to Yoda For This Post:
pareshkp
# 3  
Old 04-21-2013
Code:
$ cat A.txt
11 LAL01A_1 1213 12 0 0 7 30 2 -122 1 300 14854 5000 2
221 LAL01A_1 1313 14 0 0 7 30 1 -122 2 300 14854 5000 2
12 LAL01A_1 1234 15 0 0 7 30 0 -122 1 300 14854 5000 2
12 LAL01A_1 1234 15 0 0 xxx 7 30 0 -122 1 300 14854 5000 2

Code:
$ awk 'NF == 15 { gsub (/.*/, "& n/a", $6) } { print }' A.txt
11 LAL01A_1 1213 12 0 0 n/a 7 30 2 -122 1 300 14854 5000 2
221 LAL01A_1 1313 14 0 0 n/a 7 30 1 -122 2 300 14854 5000 2
12 LAL01A_1 1234 15 0 0 n/a 7 30 0 -122 1 300 14854 5000 2
12 LAL01A_1 1234 15 0 0 xxx 7 30 0 -122 1 300 14854 5000 2

This User Gave Thanks to hanson44 For This Post:
pareshkp
# 4  
Old 04-21-2013
thanks its perfect !!!!!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Add column and multiply its result to all elements of another column

Input file is as follows: 1 | 6 2 | 7 3 | 8 4 | 9 5 | 10 Output reuired (sum of the first column $1*$2) 1 | 6 | 90 2 | 7 | 105 3 | 8 | 120 4 |9 | 135 5 |10 | 150 Please enclose sample input, sample output, and code... (5 Replies)
Discussion started by: Sagar Singh
5 Replies

2. Shell Programming and Scripting

Adding an extra date column in UNIX file

Hi All, I have a file with only one column of data (without delimiter). For Ex: cat temp.txt 22055 21088 93840 30990 50990 50950 I want to insert an additional column with current date as value. So, i have used below command but didn't get the result as excepted. Could onyone over... (5 Replies)
Discussion started by: Suresh
5 Replies

3. Shell Programming and Scripting

Add Column base on other Column Data

HI Guys, I want add one extra Column base on 3rd Column . Input :- M204 MS204_154 :vsDataUeMe M204 MS204_154 es:sMeasure 0 M204 MS204_154 es:90ilterCoe 9 M204 MS204_154 es:searchE9090ortTime 40 M204 MS204_154 es:servOrPrioI90HoTimer 4000 M204 MS204_154 es:ueMeajllls154545 TRUE... (5 Replies)
Discussion started by: pareshkp
5 Replies

4. Shell Programming and Scripting

Adding Extra Column in txt file base on Condition

HI Guys, I have below input. Output Base on Below Condition. 1> if forth column is empty and next coming line have same name with \es then add that column name on all rows 2>rest of all are es:vsDataEUtranCellFDD Input:- CCL01736 CCL01736_7A_1 es:vsDataEUtranCellFDD ... (3 Replies)
Discussion started by: pareshkp
3 Replies

5. Shell Programming and Scripting

Add all 4 column entries for similar column ids

Hi, I want to write a script which will add the entries in all columns for the same column id. I can do it in excel, but I need to do this for 384 columns which will come down to 96 (384/4). How can I do this iteratively A A A A B B B B C C C C 1 0 1 0 2 1 4 5 3 4 5 6 2 0 0 2 3 5 70 100 1... (7 Replies)
Discussion started by: Diya123
7 Replies

6. Shell Programming and Scripting

Add a character C in a column if that column is blank

I have some files that look as follows. I need to add a character 'C' in the fifth column if that column is blank. I prefer in-place editing. 1 1 B M 0 0 203 0, 0.0 0, 0.0 0, 0.0 0, 0.0 0.000 360.0 360.0 360.0 141.9 15.4 28.8 66.1 2 2 B A ... (21 Replies)
Discussion started by: thejitha
21 Replies

7. Shell Programming and Scripting

to add special tag to a column based on column condition

Hi All, I have following html code <TR><TD>9</TD><TD>AR_TVR_TBS </TD><TD>85000</TD><TD>39938</TD><TD>54212</TD><TD>46</TD></TR> <TR><TD>10</TD><TD>ASCV_SMY_TBS </TD><TD>69880</TD><TD>33316</TD><TD>45698</TD><TD>47</TD></TR> <TR><TD>11</TD><TD>ARC_TBS ... (9 Replies)
Discussion started by: ckwan
9 Replies

8. Shell Programming and Scripting

Need to add letters to a column and add in a new column subtracting from another column

So I have this input 1 10327 rs112750067 T C . PASS DP=65;AF=0.208;CB=BC,NCBI 1 10469 rs117577454 C G . PASS DP=2055;AF=0.020;CB=UM,BC,NCBI 1 10492 rs55998931 C T . PASS DP=231;AF=0.167;CB=BC,NCBI 1 10583 rs58108140 G A ... (3 Replies)
Discussion started by: kellywilliams
3 Replies

9. Shell Programming and Scripting

Parse 1 column and add 2nd column

I'm racking my brain on this one! :( I have a list like this: Paul 20 Paul 25 Paul 30 Frank 10 Julie 15 Julie 13 etc, etc... I've been trying to figure out a way to have the output display the name in the first column ONCE and add the numbers in the second column and display that... (2 Replies)
Discussion started by: sdlennon
2 Replies

10. Shell Programming and Scripting

how to flip values of two columns and add an extra column

Hi guys, Couldn't find the solution of this problem. Please Help! I have a file- Input_File TC200232 92 30 TC215306 2 74 TC210135 42 14 I want an output file in which if column2>column3, the values are swapped and an additional column with value Rev_Com is... (4 Replies)
Discussion started by: smriti_shridhar
4 Replies
Login or Register to Ask a Question