Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Extract data between two strings
Top Forums Shell Programming and Scripting Extract data between two strings Post 302404462 by durden_tyler on Tuesday 16th of March 2010 02:28:02 PM
Old 03-16-2010
If the input data is in a single line, then -

Code:
$
$
$ cat -n f7
     1  ! TICKET NBR : 78 ! 3100.2.13.1 0.30 ! 3100.2.14.2 51 ! 1.2.1.8 <A>91368599971</A><B>Mobility</B><C>9138599971</C><D>9134284050</D><E></E><F>0220_KANSAS</F><G>NPA_913</G><H>402404</H><I>2002</I><J>12/03/2010 10:08:20</J><Q>A18</Q><R>P_30_LOCAL</R><K>RL 0.30/60/60 QL 60 CL 0.30 </K><L>0.30</L
><M>RL 0.00/1/1 QL 60 CL 0.00 </M><N>0.00</N><O>0</O><P>9.70</P><P1></P1><TA>0</TA><MS>302614168599971</MS><P2></P2><BRQ></BRQ> ! 3100.2.984.45 0 !
$
$ perl -lne 'while(/<(.*?)>(.*?)<\/.*?>/g){print "Field $1 : $2"}' f7
Field A : 91368599971
Field B : Mobility
Field C : 9138599971
Field D : 9134284050
Field E :
Field F : 0220_KANSAS
Field G : NPA_913
Field H : 402404
Field I : 2002
Field J : 12/03/2010 10:08:20
Field Q : A18
Field R : P_30_LOCAL
Field K : RL 0.30/60/60 QL 60 CL 0.30
Field L : 0.30
Field M : RL 0.00/1/1 QL 60 CL 0.00
Field N : 0.00
Field O : 0
Field P : 9.70
Field P1 :
Field TA : 0
Field MS : 302614168599971
Field P2 :
Field BRQ :
$
$

tyler_durden
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies

2. Shell Programming and Scripting

Extract specific data content from a long list of data

My input: Data name: ABC001 Data length: 1000 Detail info Data Direction Start_time End_time Length 1 forward 10 100 90 1 forward 15 200 185 2 reverse 50 500 450 Data name: XFG110 Data length: 100 Detail info Data Direction Start_time End_time Length 1 forward 50 100 50 ... (11 Replies)
Discussion started by: patrick87
11 Replies

3. Shell Programming and Scripting

Extract and parse data between two strings

Hi , I have a billing CDR file which is separated by “!”. I need to extract and format data between the starting (“!”) and the end of the line (“1.2.1.8”). These two variables are permanent tags to show begin and end. ! TICKET NBR : 2 ! GSI : 101 ! 3100.2.112.1 24/03/2010 00:41:14 !... (3 Replies)
Discussion started by: jaygamini
3 Replies

4. Shell Programming and Scripting

Search and Extract data between two strings

hi, In a given directory, i need to search for a string (eg:ABCD). For a given file, i have to extract the text between START and END strings . I need to extract all the text between START and END and there can be multiple START and END in a file. Sample: There is a directort... (3 Replies)
Discussion started by: flamingo_l
3 Replies

5. Shell Programming and Scripting

How to Extract text between two strings?

Hi, I want to extract some text between two strings in a line i am using following command i.e; awk '/-string1/,/-string2/' filename contents of file is--- line1 line2 aaa -bbb -ccc -string1 c,d,e -string2 line4 but it is showing complete line which is having searched strings. aaa... (19 Replies)
Discussion started by: emresearch
19 Replies

6. Shell Programming and Scripting

Extract text between two strings

Hi I have something like this: EXAMPLE 1 CREATE UNIQUE INDEX "STRING_1"."STRING_2" ON "BOSNI_CAB_EVENTO" ("CD_EVENTO" , "CD_EJECUCION" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 5242880 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "DB1000_INDICES_512K"... (4 Replies)
Discussion started by: chrispaz81
4 Replies

7. Shell Programming and Scripting

Extract two strings from a file and create a new file with these strings

I have the following lines in a log file. It would be great if some one can help me to create a new file with the just entries in the below format. 66.150.161.195 HPSAC=Z05 66.150.161.196 HPSAC=A05 That is just extract the IP address and the string DPSAC=its value 66.150.161.195 -... (1 Reply)
Discussion started by: Tuxidow
1 Replies

8. UNIX for Dummies Questions & Answers

Extract code between 2 strings.

Hi, Im having some problems with this. I have loaded a file with html code. All code is placed in the same line. I want to get everything between two given strings (including these strings and get only the first appearance). Example: File contains <html><body><a href='a.html'>abc</a><a... (5 Replies)
Discussion started by: ngb
5 Replies

9. UNIX for Dummies Questions & Answers

Issue when using egrep to extract strings (too many strings)

Dear all, I have a data like below (n of rows=400,000) and I want to extract the rows with certain strings. I use code below. It works if there is not too many strings for example n of strings <5000. while I have 90,000 strings to extract. If I use the egrep code below, I will get error: ... (3 Replies)
Discussion started by: forevertl
3 Replies

10. UNIX for Beginners Questions & Answers

Extract content between strings

Hello i am stuck with this. i have input which is as follows /type/work /works/OL10627594W 3 2019-04-24T16:46:21.351549 {"created": {"type": "/type/datetime", "value": "2009-12-11T03:18:17.488715"}, "title": "Tog the dog", "covers": , "last_modified": {"type":... (3 Replies)
Discussion started by: ahfze
3 Replies

LEARN ABOUT MOJAVE

mail::field::date

Mail::Field::Date(3)					User Contributed Perl Documentation				      Mail::Field::Date(3)

NAME

       Mail::Field::Date - a date header field

INHERITANCE

	Mail::Field::Date
	  is a Mail::Field

SYNOPSIS

	 use HTTP::Date 'time2iso';
	 my $field = Mail::Field->new(Date => time2iso());

DESCRIPTION

       Represents one "Date" header field.

       See documentation in the base class.

METHODS

       See documentation in the base class.

   Constructors
       See documentation in the base class.

       Mail::Field::Date->combine(FIELDS)
	   See "Constructors" in Mail::Field

       Mail::Field::Date->extract(TAG, HEAD [, INDEX ])
	   See "Constructors" in Mail::Field

       Mail::Field::Date->new(TAG [, STRING | OPTIONS])
	   See "Constructors" in Mail::Field

   "Fake" constructors
       See documentation in the base class.

       $obj->create(OPTIONS)
	   See ""Fake" constructors" in Mail::Field

       $obj->parse()
	   See ""Fake" constructors" in Mail::Field

   Accessors
       See documentation in the base class.

       $obj->set(OPTIONS)
	    -Option --Default
	     Time     undef
	     TimeStr  undef

	   Time => SECONDS
	   TimeStr => STRING
	     A string acceptable to Date::Parse.

       $obj->stringify()
	   See "Accessors" in Mail::Field

       $obj->tag()
       Mail::Field::Date->tag()
	   See "Accessors" in Mail::Field

   Smart accessors
       See documentation in the base class.

       $obj->text([STRING])
	   See "Smart accessors" in Mail::Field

       $obj->time([TIME])
	   Query (or change) the TIME (as stored in the field) in seconds.

DETAILS

       See documentation in the base class.

DIAGNOSTICS

       Error: Undefined subroutine <method> called
	   Mail::Field objects use autoloading to compile new functionality.  Apparently, the method called is not implemented for the specific
	   class of the field object.

SEE ALSO

       This module is part of the MailTools distribution, http://perl.overmeer.net/mailtools/.

AUTHORS

       The MailTools bundle was developed by Graham Barr.  Later, Mark Overmeer took over maintenance without commitment to further development.

       Mail::Cap by Gisle Aas <aas@oslonett.no>.  Mail::Field::AddrList by Peter Orbaek <poe@cit.dk>.  Mail::Mailer and Mail::Send by Tim Bunce
       <Tim.Bunce@ig.co.uk>.  For other contributors see ChangeLog.

LICENSE

       Copyrights 1995-2000 Graham Barr <gbarr@pobox.com> and 2001-2007 Mark Overmeer <perl@overmeer.net>.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.  See
       http://www.perl.com/perl/misc/Artistic.html

perl v5.18.2							    2014-01-05						      Mail::Field::Date(3)
All times are GMT -4. The time now is 02:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy