Extracting particular string in a file and storing matched string in output file Post: 302402268

Sponsored Content

Top Forums Shell Programming and Scripting Extracting particular string in a file and storing matched string in output file Post 302402268 by durden_tyler on Tuesday 9th of March 2010 09:32:32 AM

03-09-2010

Registered User

Yet another Perl solution:

Code:

$
$
$ cat -n data.txt
     1  getBalances_PSM.c(37):     D><msisdn xmlns="">0492001956</msisdn><counterListFlag xmlns="">0</counterListFlag></getBa
     2  getBalances_PSM.c(37):     lances></soap:Body></soap:Envelope>
     3
     4  getBalances_PSM.c(37): t=169119ms: 342-byte response body for "https://10.144.0.53/apc/webservices/customeraccount" (RelFrameId=1, Internal ID=2)
     5  getBalances_PSM.c(37):     <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/enve...Body><ns2:getB
     6  getBalances_PSM.c(37):     alancesResponse xmlns:ns2="http://www.al.com/apc/generated/serv...account"><bund
     7  getBalances_PSM.c(37):     leList/><accountLocation></accountLocation><resCode>3000</resCode><resMessage>Request time
     8  getBalances_PSM.c(37):     d out</resMessage></ns2:getBalancesResponse></soap:Body></soap:Envelope>
$
$ perl -lne 'BEGIN{undef $/} s/^.*:\s+|\n//mg; s/^.*<msisdn xmlns="">(\d+)<.*resCode>(\d+)<.*resMessage>([^<]+)<.*$/$1\|$2\|$3/; print' data.txt
0492001956|3000|Request timed out
$
$

tyler_durden

durden_tyler

View Public Profile for durden_tyler

Find all posts by durden_tyler

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed, grep, awk, regex -- extracting a matched substring from a file/string

Ok, I'm stumped and can't seem to find relevant info. (I'm not even sure, I might have asked something similar before.): I'm trying to use shell scripting/UNIX commands to extract URLs from a fairly large web page, with a view to ultimately wrapping this in PHP with exec() and including the...

2. Shell Programming and Scripting

Extracting a string from one file and searching the same string in other files

Hi, Need to extract a string from one file and search the same in other files. Ex: I have file1 of hundred lines with no delimiters not even space. I have 3 more files. I should get 1 to 10 characters say substring from each line of file1 and search that string in rest of the files and get...

3. Shell Programming and Scripting

save every line in log file with matched string

i have been doing this script to match every line in a current log file (access_log) with strings that i list from a path (consist of 100 of user's name ex: meggae ).. and then make a directory of every string from the text file (/path/meggae/) --->if it matched.. then print every line from the...

4. UNIX for Dummies Questions & Answers

Output text from 1st paragraph in file w/ a specific string through last paragraph of file w/ string

Hi, I'm trying to output all text from the first paragraph in a file that contains a specific string through the last paragraph in that file that contains that string. Previously, I was outputting just each paragraph with that search string with: cat in_file | nawk '{RS=""; FS="\n";...

5. UNIX for Dummies Questions & Answers

Commenting a line matched with a specific string in a file

Hi, I would like to comment a line that matched a string "sreenivas" in a file without opening it. Thanks in advance. Regards, Sreenivas

6. Shell Programming and Scripting

Search for Pattern as output between the matched String

Hello, I have a file which has the below contents : VG_name LV_name LV_size in MB LV_option LV_mountpoint owner group y testdg rahul2lv 10 "-A y -L" /home/abc2 ...

7. UNIX for Beginners Questions & Answers

Search a string inside a pattern matched block of a file

How to grep for searching a string within a begin and end pattern of a file. Sent from my Redmi 3S using Tapatalk

8. Shell Programming and Scripting

Insert a user input string after matched string in file

i am having file like this #!/bin/bash read -p 'Username: ' uservar match='<color="red" />' text='this is only a test so please be patient <color="red" />' echo "$text" | sed "s/$match/&$uservar\g" so desireble output what i want is if user type MARIA this is only a test so please...

9. UNIX for Beginners Questions & Answers

Finding specific string in file and storing in another file

Text in input file is like this <title> <band height="21" isSplitAllowed="true" > <staticText> <reportElement x="1" y="1" width="313" height="20" key="staticText-1"/> <box></box> <textElement> <font fontName="Arial" pdfFontName="Helvetica-Bold"...

LEARN ABOUT DEBIAN

www::shorten::tinylink

WWW::Shorten::Tinylink(3pm)				User Contributed Perl Documentation			       WWW::Shorten::Tinylink(3pm)

NAME

       WWW::Shorten::Tinylink - Perl interface to Tinylink.com

SYNOPSIS

	 # No appropriate solution

DESCRIPTION

       A Perl interface to the web site Tinylink.com. Tinylink.com simply maintains a database of long URLs, each of which has a unique
       identifier.

       Unfortunately, at some point in the middle of 2008, Tinylink.com stopped returning useable URLs and therefore this module is now
       deprecated.

Functions
   makeashorterlink
       The function "makeashorterlink" will call the Tinylink.com web site passing it your long URL and will return the shorter (tinylink)
       version.

       Multiple submissions of the same URL will result in different codes being returned.

   makealongerlink
       The function "makealongerlink" does the reverse. "makealongerlink" will accept as an argument either the full Tinylink URL or just the
       Tinylink identifier/nickname.

       If anything goes wrong, then either function will return "undef".

   EXPORT
       makeashorterlink, makealongerlink

SUPPORT, LICENCE, THANKS and SUCH
       See the main WWW::Shorten docs.

AUTHOR

       Iain Truskett <spoon@cpan.org>

SEE ALSO

       WWW::Shorten, perl, <http://tinylink.com/>

perl v5.14.2							    2012-04-16					       WWW::Shorten::Tinylink(3pm)