Match all lines in file where specific text pattern is less than

In the below file I am trying to grep or similar, all lines where only AF= is less than 0.4. . Thank you :).

grep

grep "AF=" ,+ .4 file

file

12    112036782    .    T    C    34.0248    PASS    AF=0.194286;AO=32;DP=170;FAO=34;FDP=175;FR=.;FRO=141;FSAF=20;FSAR=14;FSRF=57;FSRR=84;FWDB=-0.0842492;FXX=0.0056815;HRUN=2;LEN=1;MLLD=83.7705;OALT=C;OID=.;OMAPALT=C;OPOS=112036782;OREF=T;PB=0.5;PBP=1;QD=0.77771;RBI=0.128679;REFB=-0.0310314;REVB=-0.0972646;RO=137;SAF=20;SAR=12;SRF=55;SRR=82;SSEN=0;SSEP=0;SSSB=0.280873;STB=0.645079;STBP=0.067;TYPE=snp;VARB=0.090833;ANN=ATXN2    GT:GQ:DP:FDP:RO:FRO:AO:FAO:AF:SAR:SAF:SRF:SRR:FSAR:FSAF:FSRF:FSRR    0/1:34:170:175:137:141:32:34:0.194286:12:20:55:82:14:20:57:84
12    112036795    .    T    A    34.0248    PASS    AF=0.45121;AO=32;DP=170;FAO=34;FDP=175;FR=.;FRO=141;FSAF=20;FSAR=14;FSRF=57;FSRR=84;FWDB=-0.0842492;FXX=0.0056815;HRUN=2;LEN=1;MLLD=83.7705;OALT=C;OID=.;OMAPALT=C;OPOS=112036782;OREF=T;PB=0.5;PBP=1;QD=0.77771;RBI=0.128679;REFB=-0.0310314;REVB=-0.0972646;RO=137;SAF=20;SAR=12;SRF=55;SRR=82;SSEN=0;SSEP=0;SSSB=0.280873;STB=0.645079;STBP=0.067;TYPE=snp;VARB=0.090833;ANN=ATXN2    GT:GQ:DP:FDP:RO:FRO:AO:FAO:AF:SAR:SAF:SRF:SRR:FSAR:FSAF:FSRF:FSRR    0/1:34:170:175:137:141:32:34:0.194286:12:20:55:82:14:20:57:84

desired output

12    112036782    .    T    C    34.0248    PASS     AF=0.194286;AO=32;DP=170;FAO=34;FDP=175;FR=.;FRO=141;FSAF=20;FSAR=14;FSRF=57;FSRR=84;FWDB=-0.0842492;FXX=0.0056815;HRUN=2;LEN=1;MLLD=83.7705;OALT=C;OID=.;OMAPALT=C;OPOS=112036782;OREF=T;PB=0.5;PBP=1;QD=0.77771;RBI=0.128679;REFB=-0.0310314;REVB=-0.0972646;RO=137;SAF=20;SAR=12;SRF=55;SRR=82;SSEN=0;SSEP=0;SSSB=0.280873;STB=0.645079;STBP=0.067;TYPE=snp;VARB=0.090833;ANN=ATXN2     GT:GQ:DP:FDP:RO:FRO:AO:FAO:AF:SAR:SAF:SRF:SRR:FSAR:FSAF:FSRF:FSRR     0/1:34:170:175:137:141:32:34:0.194286:12:20:55:82:14:20:57:84

making some assumptions - YMMV...

awk -F'(AF=)|(;)' '$2>0.4' myFile
1 Like

awk

awk -FS=" |;|=" '$2 < 0.4' file

grep

grep "AF=0.[0-3]" file
1 Like

Thank you both and happy holidays :).