ok, many thanks! It is perfect! One more question...
Input
Output
Of course I have to use the same code, just to add for the val1= (ARC) the simbo %.1f ... somewhere ... and for the val2= (IDE) the tags [0-9]\/[0-9] ???
Could you help me again please!
Starting code:
Are you just searching on-line for solutions to your problems? Or, have you read the awk man page on your system and tried using it to construct code that meets your requirements?
Why would we use the above Starting code which is looking for strings that contain GT= and AF= followed by one or more decimal digits and has mismatched double-quotes in the print statement instead of starting with the code Ravinder suggested in post #2 that will give you output close to what you want instead of reporting a syntax error and printing nothing?
Working from Ravinder's code, extending the match() extended regular expressions to accept periods or slashes in addition to decimal digits and using sprintf() to round the numbers after ARC= to 1 decimal place, one might want to try something more like:
Last edited by Don Cragun; 01-14-2018 at 09:53 PM..
Reason: Fix typo: s/zero/one/
The line is simple, use " '{ print $1"]"$2"\"$3THE " NEEDS TO GO HERE$4 }'
I've tried \", "\, ^" and '"" but none of it works. What am I missing? Putting in the [ between $1 and $2 works fine, I just need to do the same with a ".
Thanks. (2 Replies)
Hi,
I need to find a string, if it finds then I need to print it , otherwise it has to goto next line....
input is====>
uid = shashi, india uid ,uid= asia
uid= none, uid=india. none
==========
output shold be
uid = shashi, india
uid ,
uid= asia
uid= none,
uid=india. none
... (1 Reply)
Actually I got a list of file end with *.txt
I want to use the same command apply to all the *.txt
Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics.
For example:
I got the file below:
file1.txt
file2.txt
file3.txt... (4 Replies)
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)
I am parsing a nagios config, searching for a string, and then printing the line 2 lines later (the "members" string). Here's the data:
define hostgroup{
hostgroup_name chat-dev
alias chat-dev
members thisisahostname
}
define hostgroup{
... (1 Reply)
I have a file1.txt
file1.txt
F-120009210","Felix","U-M-F-F-F-","white","yes","no","U-M-F-F-F-","Bristol","RI","true"
F-120009213","Fluffy","U-F-","white","yes","no","M-F-","Warwick","RI","true"
U-120009217","Lity","U-M-","grey","yes","yes","","Fall River","MA","true"... (4 Replies)
hi all
I would like to help me find the problem with this script to find and print to the screen a specific date of a log file that I have on my server, the date it is received as the first argument in the script $ 1
Here I show you a few lines that made the idea of my log file:
****... (4 Replies)
Can I do this in one awk session. Solution I have is poor.
I want to return the number after PID.
echo "Start: 12345 is used by PID:11111 username" | awk -F: '{print $3}' | awk '{print $1}' (6 Replies)
In the attached file I am using awk to skip the header row, search for specific text, and print particular values that are next to it all from the same field.
awk FNR > 1 '$79 == "Bases in target regions"":" "Number of amplicons"': "Target bases with no strand bias"':" {print $79}' >... (1 Reply)
Hi
I want to use awk to match where field 3 contains a number within string - then print the line and just the number as a new field.
The source file is pipe delimited and looks something like
1|net|ABC Letr1|1530|||
1|net|EXP_1040 ABC|1121|||
1|net|EXP_TG1224|1122|||
1|net|R_North|1123|||... (5 Replies)