I have two questions which I would massively appreciate help with.
1.
I am trying to insert a field into a file similar to the vlookup function in excel. In column 2 is a gene id for which i would like to insert the full name in the adjacent column. I have a map file (map.file) which has two columns - in column 1 is the gene ID and column 2 is the full gene name
The second query I have is that i want to be able to filter the file so that the output only contains those fields where for example column 7 <0.5 and column 8 <0.3 and column 9 <0.2 (sometimes there is just a blank in the field which effectively equals 0)
Is there a way to do this so that the filtering is done based on the column header rather than the column number as I have different files which have a different arrangement of columns but with the same headers.
Write a quick shell snippet to find all of the IPV4 IP addresses
in any and all of the files under /var/lib/output/*, ignoring
whatever else may be in those files. Perform a reverse lookup on
each, and format the output neatly, like "IP=192.168.0.1,
... (0 Replies)
Hello Guys,
I want to write a script which will search for all the *.c,*.h,*.txt in the file.
The result will be again search in a .csv file.
If that .c file or .h or .txt is existing in the .csv,then put a * mark corresponding to the row in .csv file.
---------- Post updated at 05:19 AM... (2 Replies)
Hi all
I had a mail issue earlier today where I was not receiving any emails from the servers of one of our clients.
The mail queue just showed this:
-----Q-ID----- --Size-- -----Q-Time----- ------------Sender/Recipient-----------
o8S7eSpp020274* 5858 Tue Sep 28 10:42... (0 Replies)
Hi,
I've internally searched through forums for about 2+ hours. Unfortunately, with no luck. Although I've found some cases close to mine below, but didn't help so much.
Actually, I'm in short with time. So I had to post my case. Hoping that you can help.
I have 2 files,
FILE1
... (0 Replies)
Hi,
I've internally searched through forums for about 2+ hours. Unfortunately, with no luck. Although I've found some cases close to mine below, but didn't help so much.
Actually, I'm in short with time. So I had to post my case. Hoping that you can help.
I have 2 files,
FILE1
... (1 Reply)
Hi, all:
My writed network device driver works fine when the transmitted file is under several MegaBytes, but above this size, especially dozens of or hundreds of MegaBytes, the kernel panic ocurres! I check the kern.log and find this error :
522 Nov 14 19:35:32 liklstar-server kerneNov 14... (2 Replies)
I have the below 2 files:
1) Third field from file1.txt should be compared to the first field of lookup.txt.
2) If match found then third field, file1.txt should be substituted with the second field from lookup.txt.
3)Else just print the line from file1.txt.
File1.txt:... (4 Replies)
Hi All,
I don't know how to fast do this field replace that need lookup from another file to form the update result:confused:
I want to do it by general shell script
Can anyone help to solve it ? Thanks for your kindly reply in advance.
CK (0 Replies)
I have 2 fixed length files input#1 & input#2. I want to match the rows based on the value in position 37-50 in both files (pos 37-50 will have same value in both files).
If any matching record is found then cut the value against company code & Invoice number from input file #1 (position 99 until... (3 Replies)
The below awk uses $3 and $4 in search as the min and max, then takes each $2 value in lookup and compares it. If the value in lookupfalls within the range in searchthen it prints the entire line in lookup/ICODE]. What I can't seem to figure out is how to print the matching $5 from search on that... (4 Replies)