I guess I do not understand hoe NF works. My actual data file is attached and is much larger (file.txt).
awk to get NF
Code:
awk 'NR==1{for(i=1;i<=NF;i++){print "Number of field in terms of NF is--> NF-" NF-i", value is-->" $i}}' file.txt
Number of field in terms of NF is--> NF-55, value is-->Chr
Number of field in terms of NF is--> NF-54, value is-->Start
Number of field in terms of NF is--> NF-53, value is-->End
Number of field in terms of NF is--> NF-52, value is-->Ref
Number of field in terms of NF is--> NF-51, value is-->Alt
Number of field in terms of NF is--> NF-50, value is-->Func.refGene
Number of field in terms of NF is--> NF-49, value is-->Gene.refGene
Number of field in terms of NF is--> NF-48, value is-->GeneDetail.refGene
Number of field in terms of NF is--> NF-47, value is-->ExonicFunc.refGene
Number of field in terms of NF is--> NF-46, value is-->AAChange.refGene
Number of field in terms of NF is--> NF-45, value is-->avsnp147
Number of field in terms of NF is--> NF-44, value is-->PopFreqMax
Number of field in terms of NF is--> NF-43, value is-->1000G_ALL
Number of field in terms of NF is--> NF-42, value is-->1000G_AFR
Number of field in terms of NF is--> NF-41, value is-->1000G_AMR
Number of field in terms of NF is--> NF-40, value is-->1000G_EAS
Number of field in terms of NF is--> NF-39, value is-->1000G_EUR
Number of field in terms of NF is--> NF-38, value is-->1000G_SAS
Number of field in terms of NF is--> NF-37, value is-->ExAC_ALL
Number of field in terms of NF is--> NF-36, value is-->ExAC_AFR
Number of field in terms of NF is--> NF-35, value is-->ExAC_AMR
Number of field in terms of NF is--> NF-34, value is-->ExAC_EAS
Number of field in terms of NF is--> NF-33, value is-->ExAC_FIN
Number of field in terms of NF is--> NF-32, value is-->ExAC_NFE
Number of field in terms of NF is--> NF-31, value is-->ExAC_OTH
Number of field in terms of NF is--> NF-30, value is-->ExAC_SAS
Number of field in terms of NF is--> NF-29, value is-->ESP6500siv2_ALL
Number of field in terms of NF is--> NF-28, value is-->ESP6500siv2_AA
Number of field in terms of NF is--> NF-27, value is-->ESP6500siv2_EA
Number of field in terms of NF is--> NF-26, value is-->CG46
Number of field in terms of NF is--> NF-25, value is-->dpsi_max_tissue
Number of field in terms of NF is--> NF-24, value is-->dpsi_zscore
Number of field in terms of NF is--> NF-23, value is-->SIFT_score
Number of field in terms of NF is--> NF-22, value is-->SIFT_pred
Number of field in terms of NF is--> NF-21, value is-->Polyphen2_HDIV_score
Number of field in terms of NF is--> NF-20, value is-->Polyphen2_HDIV_pred
Number of field in terms of NF is--> NF-19, value is-->Polyphen2_HVAR_score
Number of field in terms of NF is--> NF-18, value is-->Polyphen2_HVAR_pred
Number of field in terms of NF is--> NF-17, value is-->LRT_score
Number of field in terms of NF is--> NF-16, value is-->LRT_pred
Number of field in terms of NF is--> NF-15, value is-->MutationTaster_score
Number of field in terms of NF is--> NF-14, value is-->MutationTaster_pred
Number of field in terms of NF is--> NF-13, value is-->MutationAssessor_score
Number of field in terms of NF is--> NF-12, value is-->MutationAssessor_pred
Number of field in terms of NF is--> NF-11, value is-->CLINSIG
Number of field in terms of NF is--> NF-10, value is-->CLNDBN
Number of field in terms of NF is--> NF-9, value is-->CLNACC
Number of field in terms of NF is--> NF-8, value is-->CLNDSDB
Number of field in terms of NF is--> NF-7, value is-->CLNDSDBID
Number of field in terms of NF is--> NF-6, value is-->Quality
Number of field in terms of NF is--> NF-5, value is-->Reads
Number of field in terms of NF is--> NF-4, value is-->Zygosity
Number of field in terms of NF is--> NF-3, value is-->Phred
Number of field in terms of NF is--> NF-2, value is-->Classification
Number of field in terms of NF is--> NF-1, value is-->HGMD
Number of field in terms of NF is--> NF-0, value is-->Sanger
I tried the below awk to produced the attached desired output, which is just "VUS" in the Classification or NF-2 field. Currently I get a result with the data all out of order (attached current.txt. Thank you .
I have a line like this:
I want to move HTTP/1.1 200 OK to the next line and put a blank line between the two lines i.e.
How can i get it using awk?
Thanks in advance (2 Replies)
Hi All,
I was wondering if anyone knew how to dynamically change the FS in awk to accept vairiable containing a field separator. the current code is as below and does not work when i introduce the dynamic FS change :-(
validate_source_file()
{
source_file=$1
... (2 Replies)
how can i specify more than 1 consition in the following AWK statament??
i.e. if $2 is ABCD and $3 is MNOP and $4 is KLPM
similarly for OR
#!/bin/ksh
awk -F '' ' $2 == "ABCD" { print $2, $3;}' file.xml (2 Replies)
Hi Experts,
i need to change delimiter from tab to ","
sample test file
cat test
A0000368 A29938511 072569352 5 Any 2 for £1.00 BUTCHERS|CAT FOOD|400G Sep 12 2012 12:00AM Jan 5 2014 11:59PM Sep 7 2012 12:00AM M 2.000 group 5
... (2 Replies)
Hi
I wanted to search for 2 patterns. These patterns are matched only if the if condition is matched for example:
This is the kind of command that I have in mind which is obviously not correct:
awk '/abc/ if ($1>10) {print);/xyz/ if ($2>5) {print)' myfile
myfile:
12 14 3 20 45 abc
21 ... (7 Replies)
There are 4 ways the user can input data and unfortunately the parse rules for each are slightly different. The first condition works great and the input file is attached for the second condition. Conditions 3 and 4 will follow I'm sure I will have trouble with them and need help as well. The... (9 Replies)
I am trying to look for $2 of file1 (skipping the header) in $2 of file2 (skipping the header) and if they match and the value in $10 is > 30 and $11 is > 49, then print the line from file1 to a output file. If no match is foung the line is not printed. Both the input and output are tab-delimited.... (3 Replies)
I have been reading old posts and trying to come up with a solution for the below: Use a tab-delimited input file to assign
point to variables that are used to update a specific field, Rank. I really couldn't find too much in the way of assigning points
to variable, but made an attempt at an awk... (4 Replies)
I am trying to use awk to check if each $2 in file1 falls between $2 and $3 of the matching $4 line of file2. If it does then in $5 of file2, exon if it does not intron. I think the awk below will do that, but I am struggling trying to is add a calculation that if the difference is less than 10,... (27 Replies)
08-03-2016
.