processing with awk


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting processing with awk
# 8  
Old 08-23-2012
oh, I'm not familiar with perl, if there is shell thats better.
let me try it first, thanks

Quote:
Originally Posted by msabhi
Let me know if this neared anywhere to your requirement

Code:
perl -lne 'if(/Host.*Ports.*/){@a=split(/\t/);for($i=0;$i<=$#a;$i++){$a[$i]=~/\t*([\w\s]+):\s*(.*)/;open($1,">>$1.log");print $1 $2;close($1); }}' input_file

---------- Post updated at 07:31 AM ---------- Previous update was at 07:18 AM ----------

thanks it works fine except the Ports.log

Code:
22/open/tcp//tcpwrapped///, 53/open/tcp//domain//PowerDNS 3.3/, 179/open/tcp//tcpwrapped///
22/open/tcp//tcpwrapped///, 53/open/tcp//domain//PowerDNS 3.3/, 179/open/tcp//tcpwrapped///
22/open/tcp//tcpwrapped///, 53/open/tcp//domain//PowerDNS 3.3/, 179/open/tcp//tcpwrapped///, 1723/open/tcp//pptp//linux (Firmware: 1)/
...
...

coz there are sub-fields separated by ','

my target is like
Code:
22/open/tcp//tcpwrapped///
53/open/tcp//domain//PowerDNS 3.3/
179/open/tcp//tcpwrapped///
...
...

Quote:
Originally Posted by msabhi
Let me know if this neared anywhere to your requirement

Code:
perl -lne 'if(/Host.*Ports.*/){@a=split(/\t/);for($i=0;$i<=$#a;$i++){$a[$i]=~/\t*([\w\s]+):\s*(.*)/;open($1,">>$1.log");print $1 $2;close($1); }}' input_file

# 9  
Old 08-23-2012
Code:
perl -lne 'if(/Host.*Ports.*/){@a=split(/\t/);for($i=0;$i<=$#a;$i++){$a[$i]=~/\t*([\w\s]+):\s*(.*)/;open($1,">>$1.log");print $1 $2;close($1); }}' input_file && sed -i 's/,/\n/g' Ports.log

Check this...
But i tried solving within perl but somehow got stuck somewhere...out of time too...
# 10  
Old 08-23-2012
it works, thanks

Quote:
Originally Posted by msabhi
Code:
perl -lne 'if(/Host.*Ports.*/){@a=split(/\t/);for($i=0;$i<=$#a;$i++){$a[$i]=~/\t*([\w\s]+):\s*(.*)/;open($1,">>$1.log");print $1 $2;close($1); }}' input_file && sed -i 's/,/\n/g' Ports.log

Check this...
But i tried solving within perl but somehow got stuck somewhere...out of time too...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk for text processing

Hi,my file is in this format ", \"symbol\": \"Rbm38\" } ]" I want to convert it to a more user readable format _id pubmed text symbol 67196 18667844 Overexpression of UBE2T in NIH3T3 cells significantly promoted colony formation in mouse cell cultures Ube2t 56190 21764855 ... (3 Replies)
Discussion started by: biofreek
3 Replies

2. Shell Programming and Scripting

Help with file processing using awk

hello All, I'm new to AWK programming and learned myself few things to process a file and deal with duplicate lines, but I got into a scenario which makes me clueless to handle. Here is the scenario.. Input file: user role ----- ---- AAA add AAA delete BBB delete CCC delete DDD ... (10 Replies)
Discussion started by: julearn
10 Replies

3. Shell Programming and Scripting

Text processing using awk

I dispose of two tab-delimited files (the first column is the primary key): File 1 (there are multiple rows sharing the same key, I cannot merge them) A 28,29,30,31 A 17,18,19 B 11,13,14,15 B 8,9File 2 (there is one only row beginning with a given key) A 2,8,18,30,31 B ... (3 Replies)
Discussion started by: dovah
3 Replies

4. Programming

awk processing / Shell Script Processing to remove columns text file

Hello, I extracted a list of files in a directory with the command ls . However this is not my computer, so the ls functionality has been revamped so that it gives the filesizes in front like this : This is the output of ls command : I stored the output in a file filelist 1.1M... (5 Replies)
Discussion started by: ajayram
5 Replies

5. Shell Programming and Scripting

Help with File Processing (AWK)

Input File: 1234, 2345,abc 1,24141,gw 222,rff,sds 2232145,sdsd,121 Output file to be generated: 000001234,2345,abc 000000001,24141,gw 000000222,rff,sds 002232145,sdsd,121 i.e; the first column is padded to get 9 digits. I tried with following: (1 Reply)
Discussion started by: karumudi7
1 Replies

6. Shell Programming and Scripting

Help with data processing, maybe awk

I have a file, first 5 columns are very normal, like "1107",106027,71400,"Y","BIOLOGY",, however, the 6th columns, the user can put comments, anything, just any characters, like new line, double quote, single quote, whatever from the keyboard, like"Please load my previous SOM597G course content in... (3 Replies)
Discussion started by: freelong
3 Replies

7. Shell Programming and Scripting

awk help in processing file.

I am trying to process file which has following data #23456789012345 ACNASPSA13N0N0 ACNAPCPA05N0N0 ACNAFATS11N0N0 I want to take out each line from the file and what to put in the file by name which if part of the line starting from offset 10 to 15. It means I want to create three file... (3 Replies)
Discussion started by: ekb
3 Replies

8. Shell Programming and Scripting

Processing with awk

I currently have a file whose contents are: RangingDates 1 20090224 20090225 17 0 Export Complete 2009-02-23 19:58:00 FutureModuleList 1 20090225 20090226 6 0 Export Complete 2009-02-24 06:00:00 StoreDescription ... (2 Replies)
Discussion started by: zainravi
2 Replies

9. Shell Programming and Scripting

awk processing

Hi all Is there a way in awk to know that you are processing your final line of input if you do no know how many lines were in the input to begin with? Thanks (7 Replies)
Discussion started by: pxy2d1
7 Replies

10. Shell Programming and Scripting

Processing with AWK and Arrays

Done, thanks for the help - worked. (1 Reply)
Discussion started by: fusionX
1 Replies
Login or Register to Ask a Question