Extracting particular string in a file and storing matched string in output file
Hi ,
I have input file and i want to extract below strings
<msisdn xmlns="">0492001956</ msisdn> => numaber inside brackets
<resCode>3000</resCode> => 3000 needs to be extracted
<resMessage>Request time
getBalances_PSM.c(37): d out</resMessage></ns2:getBalancesResponse> => the word Request timed out needs to be extarcted
Input file
Code:
getBalances_PSM.c(37): D><msisdn xmlns="">0492001956</msisdn><counterListFlag xmlns="">0</counterListFlag></getBa
getBalances_PSM.c(37): lances></soap:Body></soap:Envelope>
getBalances_PSM.c(37): t=169119ms: 342-byte response body for "https://10.144.0.53/apc/webservices/customeraccount" (RelFrameId=1, Internal ID=2)
getBalances_PSM.c(37): <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getB
getBalances_PSM.c(37): alancesResponse xmlns:ns2="http://www.al.com/apc/generated/services/customeraccount"><bund
getBalances_PSM.c(37): leList/><accountLocation></accountLocation><resCode>3000</resCode><resMessage>Request time
getBalances_PSM.c(37): d out</resMessage></ns2:getBalancesResponse></soap:Body></soap:Envelope>
The file content is <msisdn xmlns="">0492001956</ msisdn> => numaber inside brackets
<resCode>3000</resCode> => 3000 needs to be extracted
<resMessage>Request timed out</resMessage>
</ns2:getBalancesResponse> => the word Request timed out needs to be extarcted
Code:
use strict;
use warnings;
my($var);
open(FH,"<file1") or die "Can't open";
while($var=<FH>)
{
if($var=~/<msisdn xmlns="">([0-9]{1,})<\/ msisdn>/)
{
print "$1|";
}
if($var=~/<resCode>([0-9]{1,})<\/resCode>/)
{
print "$1|";
}
if($var=~/<resMessage>([a-zA-Z ].*)<\/resMessage>/)
{
print "$1\n";
}
}
Hi,
Thanks for your reply. But I am getting syntax error for first 3 lines in bash shell. I think If we do search line by line it is taking too much of time since input file is big. Is there any way to do using awk or sed command?
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... (13 Replies)
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 ... (6 Replies)
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";... (2 Replies)
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... (3 Replies)
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... (1 Reply)
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 Replies)
