awk script to parse results from TWO files Post: 302521283

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script Needed to Parse Results

Raw Results: results|192.168.2|192.168.2.1|general/udp|10287|Security Note|For your information, here is the traceroute from 192.168.2.24 to 192.168.2.1 : \n192.168.2.24\n192.168.2.1\n\n results|192.168.2|192.168.2.1|ssh (22/tcp)|22964|Security Note|An SSH server is running on this port.\n...

2. Shell Programming and Scripting

Can awk do lookups to other files and process results

I know that 'brute-force' scripting could accomplish this with lots of cat/echo/cut/grep and more. But, because my real file has 800k records, and the matching files have 10-20k records, this is not time-possible or efficient. I have input file: > cat file_in...

3. Shell Programming and Scripting

awk script giving unstable results

Hi all Here I came accross a situation which i am unable to reason out... snippet 1 psg ServTest | grep -v "grep" | grep -v "vi" | awk '{ pgm_name=$8 cmd_name="ServTest" gsub(/]*/,"",pgm_name) if(pgm_name==cmd_name) { print "ServTest Present =" cmd_name} }'...

4. Shell Programming and Scripting

awk - Matching columns between 2 files and reordering results

I am trying to match 4 colums (first_name,last_name,dob,ssn) between 2 files and when there is an exact match I need to write out these matches to a new file with a combination of fields from file1 and file2. I've managed to come up with a way to match these 2 files based on the columns (see below)...

5. Shell Programming and Scripting

AWK failing to parse on certain files

Dear Unix Gurus, need your expertise to help troubleshoot a certain problem i'm having. I crated a shell script which will ftp get 1 crash log from multiple servers (listed in a text file). Each log will then be parsed by calling an awk script. The problem is, for certain log its parsing...

6. Shell Programming and Scripting

awk help: Match data fields from 2 files & output results from both into 1 file

I need to take 2 input files and create 1 output based on matches from each file. I am looking to match field #1 in both files (Userid) and create an output file that will be a combination of fields from both file1 and file2 if there are any differences in the fields 2,3,4,5,or 6. Below is an...

7. Shell Programming and Scripting

awk to parse huge files

Hello All, I have a situation as below: (1) Read a source file (a single file of 1.2 million rows in it ) (2) Read Destination files one by one and replace the content ( few fields in it ) with the corresponding matching field from source file. I tried as below: ( please note I am not...

8. Shell Programming and Scripting

awk parse snmp results

i run the command snmptable -v2c -c public myIP IF-MIB::ifTable the result look like this : SNMP table: IF-MIB::ifTable ifIndex ifDescr ifType ifMtu ifSpeed ifPhysAddress ifAdminStatus ifOperStatus 1 Unit: 1 Slot: 0 Port: 1...

9. Shell Programming and Scripting

Parse input of two files to be the same in awk

I have two files that I am going to use diff to find the differences but need to parse them before I do that. I have include the format of each file1 and file2 with the desired output of each (the first 5 fields in each file). The first file has a "chr" before the # that needs to be removed. I...

10. UNIX for Beginners Questions & Answers

Comparing 2 files using awk , not getting any results - C shell

I am using c shell and trying to compare 2 files using awk . But the below awk statement doesnt give any result. Pls. advise why am not getting the desired o/p with the corrected awk script. Need to acheive this solution in awk using C shell. awk 'FNR==NR{a++;next} {for(i in a) {if ( a=$0...

LEARN ABOUT DEBIAN

go-show-paths-to-root

GO-SHOW-PATHS-TO-ROOT(1p)				User Contributed Perl Documentation				 GO-SHOW-PATHS-TO-ROOT(1p)

NAME

       go-show-paths-to-root.pl - shows all possible paths from a term to the top

SYNOPSIS

	 go-show-paths-to-root.pl -id GO:0008021 ontology/gene_ontology.obo
	 go-show-paths-to-root.pl -names -id GO:0008021 ontology/gene_ontology.obo

DESCRIPTION

       traverses DAG showing all paths (terms and intervening relationships) to the root

       This script is purely file based; it needs to parse the ontology each time

       Subsequent parses can be speeded up using the use_cache option

       If you wish to use the GO MySQL db, see the script go-db-show-paths-to-root.pl in the go-db-perl distribution

ARGUMENTS

       -e ERRFILE

       writes parse errors in XML - defaults to STDERR (there should be no parse errors in well formed files)

       -p FORMAT

       determines which parser to use; if left unspecified, will make a guess based on file suffix. See below for formats

   -use_cache
       If this switch is specified, then caching mode is turned on.

       With caching mode, the first time you parse a file, then an additional file will be exported in a special format that is fast to parse.
       This file will have the same filename as the original file, except it will have the ".cache" suffix.

       The next time you parse the file, this program will automatically check for the existence of the ".cache" file. If it exists, and is more
       recent than the file you specified, this is parsed instead. If it does not exist, it is rebuilt.

   DOCUMENTATION
       <http://www.godatabase.org/dev>

perl v5.14.2							    2010-05-12						 GO-SHOW-PATHS-TO-ROOT(1p)