Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: regular expression with shell script to extract data out of a text file
Top Forums Shell Programming and Scripting regular expression with shell script to extract data out of a text file Post 302662117 by vemkiran on Tuesday 26th of June 2012 07:33:08 AM
Old 06-26-2012
Quote:
Originally Posted by clx
Ok, Does this seems to work for you?

Code:
$ awk '/^\[/ && ! /Upgrade this free listing/ {print $0} /:$/ && ! /Classification/ {printf $0 ;  getline x ; print x}' file
[58]Walid Chamoun Architects WLL
PO Box:55803, Doha, Qatar
Location:D-Ring Road, New Salata Shamail 40, Villa 340, Doha, Qatar
Tel:(00974) 44568833
Fax:(00974) 44568811
Mob:(00974) 44568822
[65]Al Ali Consulting & Engineering
PO Box:467, Doha, Qatar
Tel:(00974) 44360011
[69]Al Gazeerah Consulting Engineering
PO Box:22414, Doha, Qatar
Tel:(00974) 44352126
[73]Al Murgab Consulting Engineering
PO Box:2856, Doha, Qatar
Tel:(00974) 44448623
$


the data looks good but when i tried using the awk command you posted, it gave me only po box numbers, fax numbers and phone numbers

something like this!
and i need a separator so that i can save it as a csv file
Quote:
PO Box: 1151, Doha, Qatar
Tel: (00974) 44664396
PO Box: 3529, Doha, Qatar
Tel: (00974) 44417477
PO Box: 24863, Doha, Qatar
Tel: (00974) 44954607
PO Box: 22160, Doha, Qatar
Tel: (00974) 44131818
PO Box: 9553, Doha, Qatar
Tel: (00974) 44311758
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

using regular expression an shell script!!

I want to check if the first argument of my shell script starts with a specifiec string? Any Idea?? Thank u (3 Replies)
Discussion started by: andy2000
3 Replies

2. Shell Programming and Scripting

shell-script which extract data from log file

give me a shell-script which extract data from log file on a server by giving date and time as input (for both start time and end time) and it will give the logs generated during the given time as output. (4 Replies)
Discussion started by: abhishek27
4 Replies

3. Shell Programming and Scripting

Help with shell script to extract data from XML file

Hello Scripting Gurus, I need help with extracting data from the XML file using shell script. The data is in a large XML and I need to extract the id values of all completedworkflows. Here is a sample of it. Input and output data is also in the attached text files. <wfregistry>... (5 Replies)
Discussion started by: yajaykumar
5 Replies

4. Shell Programming and Scripting

problem with Regular expression as input in shell script

Hi, I have script which will take a string as input and search in a file. But when I want to search a pattern which has special characters script is ignoring it. For example: I want to search a pattern "\.tumblr\.com". shell script is removing \ (backslah) and trying to search... (7 Replies)
Discussion started by: Anjan1
7 Replies

5. Shell Programming and Scripting

need a shell script to extract data from a log file.

If I have a log like : Mon Jul 19 05:07:34 2010; TCP; eth3; 52 bytes; from abc to def Mon Jul 19 05:07:35 2010; UDP; eth3; 46 bytes; from aaa to bbb Mon Jul 19 05:07:35 2010; TCP; eth3; 52 bytes; from def to ghi I will need an output like this : Time abc to def... (1 Reply)
Discussion started by: hitha87
1 Replies

6. Programming

Perl: How to read from a file, do regular expression and then replace the found regular expression

Hi all, How am I read a file, find the match regular expression and overwrite to the same files. open DESTINATION_FILE, "<tmptravl.dat" or die "tmptravl.dat"; open NEW_DESTINATION_FILE, ">new_tmptravl.dat" or die "new_tmptravl.dat"; while (<DESTINATION_FILE>) { # print... (1 Reply)
Discussion started by: jessy83
1 Replies

7. Shell Programming and Scripting

incorporating a regular expression statement in a shell script (.sh)

I do have a shell file where I call many unix commands . I would like to add a regular expression step in that shell file, where a text file, say Test.txt has to be openned and all the :'s should be replaced. Basically apply the follwoing regular expression: :%s/://g to that particular text... (2 Replies)
Discussion started by: Lucky Ali
2 Replies

8. UNIX for Dummies Questions & Answers

Shell script to extract data from csv file

Hi Guys, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 7 columns having values say column 1,column 2.....column 7 as below along with their values. Name, Address,... (7 Replies)
Discussion started by: Vivekit82
7 Replies

9. UNIX for Beginners Questions & Answers

Shell - Read a text file with two words and extract data

hi I made this simple script to extract data and pretty much is a list and would like to extract data of two words separated by commas and I would like to make a new text file that would list these extracted data into a list and each in a new line. Example that worked for me with text file... (5 Replies)
Discussion started by: dandaryll
5 Replies

10. UNIX for Beginners Questions & Answers

Shell script to extract data in a file

I have this 5GB file, and i want to extract from the file particulars pattern. this is my script: // count=`grep -wc "MSISDN" file_name` k=1 >OUTPUT >OUTPUT_Final while do cat file_name | awk -F":" -v var="$k" '$1=="MSISDN" {m++}m==var{print; exit}' >> OUTPUT cat file_name |awk -F":"... (33 Replies)
Discussion started by: gillesi
33 Replies

LEARN ABOUT OSF1

wildmat

WILDMAT(3)						     Library Functions Manual							WILDMAT(3)

NAME

       wildmat - perform shell-style wildcard matching

SYNOPSIS

       int
       wildmat(text, pattern)
	   char       *text;
	   char       *pattern;

DESCRIPTION

       Wildmat	is  part  of libinn (3).  Wildmat compares the text against the pattern and returns non-zero if the pattern matches the text.  The
       pattern is interpreted according to rules similar to shell filename wildcards, and not as a full regular expression such as  those  handled
       by the grep(1) family of programs or the regex(3) or regexp(3) set of routines.

       The pattern is interpreted as follows:

       x     Turns  off the special meaning of x and matches it directly; this is used mostly before a question mark or asterisk, and is not spe-
	      cial inside square brackets.

       ?      Matches any single character.

       *      Matches any sequence of zero or more characters.

       [x...y]
	      Matches any single character specified by the set x...y.	A minus sign may be used to indicate a	range  of  characters.	 That  is,
	      [0-5abc] is a shorthand for [012345abc].	More than one range may appear inside a character set; [0-9a-zA-Z._] matches almost all of
	      the legal characters for a host name.  The close bracket, ], may be used if it is the first character in the set.  The  minus  sign,
	      -, may be used if it is either the first or last character in the set.

       [^x...y]
	      This  matches any character not in the set x...y, which is interpreted as described above.  For example, [^]-] matches any character
	      other than a close bracket or minus sign.

HISTORY

       Written by Rich $alz <rsalz@uunet.uu.net> in 1986, and posted to Usenet several times since then,  most	notably  in  comp.sources.misc	in
       March, 1991.

       Lars Mathiesen <thorinn@diku.dk> enhanced the multi-asterisk failure mode in early 1991.

       Rich and Lars increased the efficiency of star patterns and reposted it to comp.sources.misc in April, 1991.

       Robert Elz <kre@munnari.oz.au> added minus sign and close bracket handling in June, 1991.

       This is revision 1.10, dated 1992/04/03.

SEE ALSO

       grep(1), regex(3), regexp(3).

																	WILDMAT(3)
All times are GMT -4. The time now is 06:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy