Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Bash Shell Script to parse file
Top Forums Shell Programming and Scripting Bash Shell Script to parse file Post 302466114 by jim mcnamara on Monday 25th of October 2010 01:37:15 PM
Old 10-25-2010
Code:
[g]awk -F '|'  'BEGIN{OFS="\t"}
                    /^results/ {print $3, $4, $5, substr($6,1,20), $3} 0' filename | sort -t'    ' -k5 >newfile

the -t ' ' part: ' ' is a tab character typed in from the keyboard, since it is whitespace you need ' ' around it.
The trailing 0}' suppresses default printing, some awks do that.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to parse config variables from external file to shell script

How do i use a config.txt to recursively pass a set of variables to a shell script eg my config.txt looks like this : path=c://dataset/set1 v1= a.bin v2= b.bin path=c://dataset/set2 v1= xy.bin v2= abc.bin .................. and so on . and my testscript : (2 Replies)
Discussion started by: pradsh
2 Replies

2. Shell Programming and Scripting

Parse a string in XML file using shell script

Hi! I'm just new here and don't know much about shell scripting. I just want to ask for help in creating a shell script that will parse a string or value of the status in the xml file. Please sample xml file below. Can you please help me create a simple script to get the value of status? Also it... (46 Replies)
Discussion started by: ayhanne
46 Replies

3. Shell Programming and Scripting

Unix shell script to parse the contents of comma-separated file

Dear All, I have a comma-separated file. 1. The first line of the file(header) should have 4 commas(5 fields). 2. The last line of the file should have 1 comma(2 fields). Pls help me in checking this condition in a shell script. And the number of lines between the first line and last... (11 Replies)
Discussion started by: KrishnaSaran
11 Replies

4. Shell Programming and Scripting

Help!!! Shell script to parse data file.

I am faced with a :confused: tricky problem to parse a data file ( May not be a tricky problem to the scripting guru's ). Here is what I am faced with. I have a file with multiple rows of data and the rows are not of fixed length. "|" is used as a delimiters for individual columns and each row... (3 Replies)
Discussion started by: yajaykumar
3 Replies

5. UNIX for Advanced & Expert Users

shell script to parse html file

hi all, i have a html file something similar to this. <tr class="evenrow"> <td class="data">added</td><td class="data">xyz@abc.com</td> <td class="data">filename.sql</td><td class="modifications-data">08/25/2009 07:58:40</td><td class="data">Added TK prof script</td> </tr> <tr... (1 Reply)
Discussion started by: sais
1 Replies

6. Shell Programming and Scripting

Bash Script to read a file and parse each record

Hi Guys, I am new to unix scripting and I am tasked to parse through a CSV file delimited by #. Sample: sample.csv H#A#B#C D#A#B#C T#A#B#C H = Header D = Detail Record T = Tail What I need is to read the file and parse through it to get the columns. I have no idea on how... (8 Replies)
Discussion started by: 3vilwyatt
8 Replies

7. Shell Programming and Scripting

Parse XML file in shell script

Hi Everybody, I have an XML file containing some data and i want to extract it, but the specific issue in my file is that the data is repeated some times like the following example : <section1> <subsection1> X=... Y=... Z=... <\subsection1> <subsection2> X=... Y=... Z=...... (2 Replies)
Discussion started by: yassine
2 Replies

8. Shell Programming and Scripting

Parse file from 2nd line in shell script

Hi, I need to parse input file from 2nd line. Input file contents are, ABC123;20100913115432;2000000;NO; 04;AAA;09;DDD;601020304;AAAA;1;OPTA1;OPTA2;;; 04;BBB;09;BBB;601020304;BBBB;0;OPTB1;OPTB2;OPTB3;OPTB4;OPTB5; 04;CCC;09;DDD;601020304;CCCC;1;;;;; For each line, 1] I need to check... (17 Replies)
Discussion started by: Poonamol
17 Replies

9. UNIX for Dummies Questions & Answers

Help to parse csv file with shell script

Hello ! I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so... As said in the title, I want to read a csv file with a bash script. Here is a sample of the file: ... (4 Replies)
Discussion started by: Grhyll
4 Replies

10. Shell Programming and Scripting

Shell Script | Parse log file after a given date and time stamp

I am developing one script which will take log file name, output file name, date, hour and minute as an argument and based on these inputs, the script will scan and capture all the error(s) that have been triggered from a given time. Example: script should capture all the error after 13:50 on Jan... (2 Replies)
Discussion started by: ROMA3
2 Replies

LEARN ABOUT DEBIAN

oidentd_masq.conf

oidentd_masq.conf(5)						File Formats Manual					      oidentd_masq.conf(5)

NAME

       oidentd_masq.conf - oidentd IP masquerading/NAT configuration file.

DESCRIPTION

       If you are using IP masquerading or NAT, oidentd can optionally return a username for connections from other machines.  Support for this is
       specified by calling oidentd with the -m (or --masq) flag and by creating an /etc/oidentd_masq.conf file.

       oidentd can also forward requests for an IP masqueraded connection to the machine from which connection originates by way of the -f option.
       This  will  only  work if the host to which the connection is forwarded is running oidentd with the -P (proxy) flag, or if the host's ident
       daemon will return a valid reply regardless of the input supplied by and the address of the host requesting the info  (some  ident  daemons
       for windows do this, maybe others).

FORMAT

       <IP Address|Hostname>[/<Mask>] <Ident Response> <System Type>

       The  first  field  contains the IP address or the hostname of a machine that IP masquerades through the machine on which oidentd runs.  The
       mask parameter can be either a network mask or a mask in CIDR notation.	A mask of 24 is equivalent to  255.255.255.0,  a  mask	of  16	is
       equivalent to 255.255.0.0, etc.

       The second field specifies the reply that oidentd will return for lookups to the host matching the IP address specified in the first param-
       eter.

       The third field specifies the operating system the machine matching the first parameter is running.

EXAMPLES

       <Host>[/<Mask>]		<Ident Response>    <System Type>
       192.168.1.1		     someone		 UNIX
       192.168.1.2		     noone		 WINDOWS
       192.168.1.1/32		     user1		 UNIX
       192.168.1.0/24		     user3		 UNIX
       192.168.0.0/16		     user4		 UNIX
       somehost 		     user5		 UNIX
       192.168.1.0/255.255.255.0     user6		 UNIX

AUTHOR

       Ryan McCabe <ryan@numb.org>
       http://dev.ojnk.net

SEE ALSO

       oidentd(8) oidentd.conf(5)

version 2.0.8							    13 Jul 2003 					      oidentd_masq.conf(5)
All times are GMT -4. The time now is 01:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy