Thank you for your help. In your code, you have used $2. Are you referring to field 2 by $2? If yes, I think it should be $6. Because I wish to find the row where $6 is greater after grouping them based on $1 and $4.
However, it did not give the output using your code.
Thanks
Angsuman
Hello angshuman,
Could you please try following and let me know if this helps you.
Output will be as follows.
Thanks,
R. Singh
Last edited by RavinderSingh13; 08-07-2016 at 12:12 PM..
Reason: added 0 to $NF's value.
I have a file with colon separated values.. the sample is attached below.
No of fields in each record/line is dependent on the value of field53.
What I need to do is to design a special filter based on specific requirement of some match of values in particular column or combination of columns.
... (2 Replies)
I want to accomplish this in sh, however if the capability exists only in other shells elsewhere that's acceptable.
% df -kh
Filesystem size used avail capacity Mounted on
...
/dev/dsk/c0t0d0s1 103G 102G 23M 100% /export/DISK15
...
# output... (5 Replies)
Hi,
I am new to unix shell shell scripting. I have a specific requirement where I need to append comma's based on the max number of column in the file.
Eg:
If my source file look something like this,
sengwa,china
tom,america,northamerica
smith,america
walter
My output file... (8 Replies)
I need to get the output in row wise for the repeated column data
Ex:
Input:
que = five
ans = 5
que = six
ans = 6
Required output:
que = five six
ans = 5 6
Any body can guide me?"""""" (2 Replies)
Hi all
This is my output of the some SQL Query
TABLESPACE_NAME FILE_NAME TOTALSPACE FREESPACE USEDSPACE Free
------------------------- ------------------------------------------------------- ---------- --------- ---------... (2 Replies)
Hello Experts,
I am new in scripting. I would like to filter and migrate data from row to column by awk. Thanks in advance.
For example
FileA
abc
1
2
3
Xyz3
4
1
5
bcd1
Output :
Abc 1 2 3
Xyz3 4 1 5
bcd1 3 5 6 (5 Replies)
Hi,
I have a requirement to display/write the 3rd column from a file based on the value in the column 3.
Ex: Data in the File (comma delimited)
ID,Value,Description
1,A,Active
1,I,Inactive
2,S,Started
1,N,None
2,C,Completed
2,F,Failed
I need to first get a list of all Unique IDs in... (7 Replies)
Hello
I have a tab text file with many columns and have to filter rows ONLY if column 22 has the value of '0', '1', '2' or '3' (out of 0-5).
If Column 22 has value '0','1', '2' or '3' (highlighted below), then remove anything less than 10 and greater 100 (based on column 5) AND remove anything... (1 Reply)