10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Experts,
Need your support for this awk script.
we have only one input file, all these column 1 and column 2 are in same file and have to do lookup for values in one file(column1 and column2) but output we need in another file
Need to grep row whose string contains 9K from column 1. When found... (6 Replies)
Discussion started by: as7951
6 Replies
2. Shell Programming and Scripting
Need your support for below. Please help to get required output
If column 5 is INV then only consider column1 and take out duplicates/identical rows/values from column1 and then put minimum value of column6 in column7 and put maximum value in column 8 and then need to do subtract values of... (7 Replies)
Discussion started by: as7951
7 Replies
3. Shell Programming and Scripting
i want to search columns in a variable and any column contains a particular string, i want to print the value of that column
$ echo "${USEDMEMORY}"
memTotalReal=3925908 memAvailReal=1109812 memBuffer=242676 memCached=641628
$
$ echo "${USEDMEMORY}" | awk '/memAvailReal/'
so what im trying... (6 Replies)
Discussion started by: SkySmart
6 Replies
4. Shell Programming and Scripting
Hi,
Could you help me with script in perl
;A1;AAA;%/A/B;70;75;-;
;A1;AAA;%/A/C;70;75;-;
;A1;BBB;%/A/G;70;75;-;
;A1;BBB;%/A;70;75;-;I would like to find line with '%/A' and put in that line in column 5 and 6 some other value ex: 90 and 99
example output:
;A1;AAA;%/A/B;70;75;-;... (5 Replies)
Discussion started by: vikus
5 Replies
5. Shell Programming and Scripting
Hi Masters,
Kindly need your help to format this data...
IMPORT_HORIZON_HEADER
0
0 35
SURFACE_DATA_FORMAT
XYZ-
COLOR_FORMAT
RGB
SURFACE
EB_S1_S2_Fault1
700 3
475370.187500 3672355.250000 1513.770386
475544.281250 3672530.250000 2255.540039 (4 Replies)
Discussion started by: ipatah
4 Replies
6. Shell Programming and Scripting
I have a file like:
I would like to find lines lines with duplicate values in column 1, and retain only one based on two conditions: 1) keep line with highest value in column 3, 2) if column 3 values are equal, retain the line with the highest value in column 4.
Desired output:
I was able to... (3 Replies)
Discussion started by: pathunkathunk
3 Replies
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
Hi. How do I find an expression with awk in only one column, and if it fits, then print that whole column.
1 apple oranges
2 bannanas pears
3 cats dogs
4 hesaid shesaid
echo "which number:"
read NUMBER (user inputs number 2 for this example)
awk " /$NUMBER/ {field to search is field... (2 Replies)
Discussion started by: glev2005
2 Replies
9. UNIX for Dummies Questions & Answers
hi people,
i need a help!!!!
i'm trying use a awk command, but i dont have success!..
i need find the string 'FL' in 55th column in a length file of 2.4Gb!!!
Attempts:
awk -F"\t" ' { if ($55 ~ /^F/) print $0} ' FILE
awk -F"\t" ' { if ($55 ~ /FL/) print $0} ' FILE
awk -F"\t" ' { if... (7 Replies)
Discussion started by: gandarez
7 Replies
10. Solaris
hi people,
i need a help!!!!
i'm trying use a awk command, but i dont have success!..
i need find the string 'FL' in 55th column in a length file of 2.4Gb!!!
Attempts:
awk -F"\t" ' { if ($55 ~ /^F/) print $0} ' FILE
awk -F"\t" ' { if ($55 ~ /FL/) print $0} ' FILE
awk -F"\t" ' { if... (5 Replies)
Discussion started by: gandarez
5 Replies