Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sed extract from xml
Top Forums Shell Programming and Scripting sed extract from xml Post 302530884 by ctsgnb on Wednesday 15th of June 2011 08:53:31 AM
Old 06-15-2011
Note that the \+ will be turned in + :

Code:
# paste -sd"\0" yourfile.xml | sed 's:"::g;s/<[^>]*>/ /g' | xargs -n1
02788920
+44146322XXXX
40[6-9]XXX
11
9710
755.XXXXX
00
02754115
456XXX
+44551665XXXX
02785XXX
99999

A more generic solution

Code:
# paste -sd"\0" yourfile.xml | sed 's:"::g;s/dnorpattern/#/g;s/<[^#]*>//g;s:</#>[^>]*<#>: :g;s:</*#>::g' | tr ' ' '\n'
02788920
\+44146322XXXX
40[6-9]XXX
11
9710
755.XXXXX
00
02754115
456XXX
\+44551665XXXX
02785XXX
99999

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

· simerian · XML Extract

The script following in this thread allows XML data to be located and extracted in a variety of forms from an XML data stream. Using this utility, it is possible to extract all manner of XML subsets and allow data to be post inserted into the "original" XML at any logical point. The pipe is... (2 Replies)
Discussion started by: Simerian
2 Replies

2. Shell Programming and Scripting

sed or awk to extract data from Xml file

Hi, I want to get data from Xml file by using sed or awk command. I want to get the following result : mon titre 1;Createur1;Dossier1 mon titre 1;Createur1;Dossier1 and save it in cvs file (fichier.cvs). FROM this Xml file (test.xml): <playlist version="1"> <trackList> <track>... (1 Reply)
Discussion started by: yeclota
1 Replies

3. Shell Programming and Scripting

SED extract XML value

I have the following string: <min-pool-size>2</min-pool-size> When I pipe the string into the following code I am expcting for it to return just the value "2", but its just reurning the whole string. Why?? sed -n '/<min-pool-size>/,/<\/min-pool-size>/p' Outputting:... (13 Replies)
Discussion started by: ArterialTool
13 Replies

4. Shell Programming and Scripting

Using SED/AWK to extract xml at end of file

Hello everyone, Firstly i do not require alot of help.. i am right at the end of finishing my scipt but cannot find a solution to the last part. What i need to do is, prompt the user for a file to work with, which i have done. promt the user for an output file - which is done. #!/bin/bash... (14 Replies)
Discussion started by: hugh86
14 Replies

5. Shell Programming and Scripting

Extract value from XML

I have a file like below <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:executeMDXResponse... (9 Replies)
Discussion started by: manas_ranjan
9 Replies

6. Shell Programming and Scripting

Extract Multivalue from XML

I have below attached xml file , how can I have my desired output as below. i/p file <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:executeMDXResponse... (4 Replies)
Discussion started by: manas_ranjan
4 Replies

7. Shell Programming and Scripting

sed - extract text from xml file

hi, please help, i have an xml file, e.g: ... <tag> test text asdas="${abc}" xvxvbs:asdas${222}sdad asasa="${aa_bb_22}" </tag> ... i want to extract all "${...}", e.g: ${abc} ${222} ${aa_bb_22} thank you. (2 Replies)
Discussion started by: gioni
2 Replies

8. Shell Programming and Scripting

Extract a particular xml only from an xml jar file

Hi..need help on how to extract a particular xml file only from an xml jar file... thanks! (2 Replies)
Discussion started by: qwerty000
2 Replies

9. Shell Programming and Scripting

Extract strings from XML files and create a new XML

Hello everybody, I have a double mission with some XML files, which is pretty challenging for my actual beginner UNIX knowledge. I need to extract some strings from multiple XML files and create a new XML file with the searched strings.. The original XML files contain the source code for... (12 Replies)
Discussion started by: milano.churchil
12 Replies

10. Shell Programming and Scripting

Extract a value from an xml file

I have this XML file format and all in one line: Fri Dec 23 00:14:52 2016 Logged Message:689|<?xml version="1.0" encoding="UTF-8"?><PORT_RESPONSE><HEADER><ORIGINATOR>XMG</ORIGINATOR><DESTINAT... (16 Replies)
Discussion started by: mrn6430
16 Replies

LEARN ABOUT MOJAVE

datetime::locale::tig_er5.18

DateTime::Locale::tig_ER(3)				User Contributed Perl Documentation			       DateTime::Locale::tig_ER(3)

NAME

       DateTime::Locale::tig_ER

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'tig_ER' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Tigre Eritrea.

DATA

       This locale inherits from the DateTime::Locale::tig locale.

       It contains the following data.

   Days
       Wide (format)

	 XX
	 XXXX
	 XXXXX
	 XXX
	 XXXX
	 XXXX XXX
	 XXXX XXX

       Abbreviated (format)

	 XX
	 XXX
	 XXX
	 XXX
	 XXX
	 X/X
	 X/X

       Narrow (format)

	 X
	 X
	 X
	 X
	 X
	 X
	 X

       Wide (stand-alone)

	 XX
	 XXXX
	 XXXXX
	 XXX
	 XXXX
	 XXXX XXX
	 XXXX XXX

       Abbreviated (stand-alone)

	 XX
	 XXX
	 XXX
	 XXX
	 XXX
	 X/X
	 X/X

       Narrow (stand-alone)

	 X
	 X
	 X
	 X
	 X
	 X
	 X

   Months
       Wide (format)

	 XXXXX
	 XXXXX
	 XXX
	 XXXX
	 XX
	 XX
	 XXX
	 XXXX
	 XXXXXX
	 XXXXXX
	 XXXXX
	 XXXXX

       Abbreviated (format)

	 XXX
	 XXX
	 XXX
	 XXX
	 XX
	 XX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Narrow (format)

	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X

       Wide (stand-alone)

	 XXXXX
	 XXXXX
	 XXX
	 XXXX
	 XX
	 XX
	 XXX
	 XXXX
	 XXXXXX
	 XXXXXX
	 XXXXX
	 XXXXX

       Abbreviated (stand-alone)

	 XXX
	 XXX
	 XXX
	 XXX
	 XX
	 XX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Narrow (stand-alone)

	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X

   Quarters
       Wide (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 BCE
	 CE

       Abbreviated

	 X/X
	 X/X

       Narrow

	 X/X
	 X/X

   Date Formats
       Full

	  2008-02-05T18:30:30 = XXXXX 05 XXXXX XX 2008 X/X
	  1995-12-22T09:05:02 = XXXXX 22 XXXXX XX 1995 X/X
	 -0010-09-15T04:44:23 = XXXX XXXX 15 XXXXXX XX -10 X/X

       Long

	  2008-02-05T18:30:30 = 05 XXXXX 2008
	  1995-12-22T09:05:02 = 22 XXXXX 1995
	 -0010-09-15T04:44:23 = 15 XXXXXX -10

       Medium

	  2008-02-05T18:30:30 = 05-XXX-2008
	  1995-12-22T09:05:02 = 22-XXX-1995
	 -0010-09-15T04:44:23 = 15-XXX--10

       Short

	  2008-02-05T18:30:30 = 05/02/08
	  1995-12-22T09:05:02 = 22/12/95
	 -0010-09-15T04:44:23 = 15/09/-10

       Default

	  2008-02-05T18:30:30 = 05-XXX-2008
	  1995-12-22T09:05:02 = 22-XXX-1995
	 -0010-09-15T04:44:23 = 15-XXX--10

   Time Formats
       Full

	  2008-02-05T18:30:30 = 6:30:30 XX XXXXX UTC
	  1995-12-22T09:05:02 = 9:05:02 XXX XXXXX UTC
	 -0010-09-15T04:44:23 = 4:44:23 XXX XXXXX UTC

       Long

	  2008-02-05T18:30:30 = 6:30:30 XX XXXXX UTC
	  1995-12-22T09:05:02 = 9:05:02 XXX XXXXX UTC
	 -0010-09-15T04:44:23 = 4:44:23 XXX XXXXX UTC

       Medium

	  2008-02-05T18:30:30 = 6:30:30 XX XXXXX
	  1995-12-22T09:05:02 = 9:05:02 XXX XXXXX
	 -0010-09-15T04:44:23 = 4:44:23 XXX XXXXX

       Short

	  2008-02-05T18:30:30 = 6:30 XX XXXXX
	  1995-12-22T09:05:02 = 9:05 XXX XXXXX
	 -0010-09-15T04:44:23 = 4:44 XXX XXXXX

       Default

	  2008-02-05T18:30:30 = 6:30:30 XX XXXXX
	  1995-12-22T09:05:02 = 9:05:02 XXX XXXXX
	 -0010-09-15T04:44:23 = 4:44:23 XXX XXXXX

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = XXXXX 05 XXXXX XX 2008 X/X 6:30:30 XX XXXXX UTC
	  1995-12-22T09:05:02 = XXXXX 22 XXXXX XX 1995 X/X 9:05:02 XXX XXXXX UTC
	 -0010-09-15T04:44:23 = XXXX XXXX 15 XXXXXX XX -10 X/X 4:44:23 XXX XXXXX UTC

       Long

	  2008-02-05T18:30:30 = 05 XXXXX 2008 6:30:30 XX XXXXX UTC
	  1995-12-22T09:05:02 = 22 XXXXX 1995 9:05:02 XXX XXXXX UTC
	 -0010-09-15T04:44:23 = 15 XXXXXX -10 4:44:23 XXX XXXXX UTC

       Medium

	  2008-02-05T18:30:30 = 05-XXX-2008 6:30:30 XX XXXXX
	  1995-12-22T09:05:02 = 22-XXX-1995 9:05:02 XXX XXXXX
	 -0010-09-15T04:44:23 = 15-XXX--10 4:44:23 XXX XXXXX

       Short

	  2008-02-05T18:30:30 = 05/02/08 6:30 XX XXXXX
	  1995-12-22T09:05:02 = 22/12/95 9:05 XXX XXXXX
	 -0010-09-15T04:44:23 = 15/09/-10 4:44 XXX XXXXX

       Default

	  2008-02-05T18:30:30 = 05-XXX-2008 6:30:30 XX XXXXX
	  1995-12-22T09:05:02 = 22-XXX-1995 9:05:02 XXX XXXXX
	 -0010-09-15T04:44:23 = 15-XXX--10 4:44:23 XXX XXXXX

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 XXX
	  1995-12-22T09:05:02 = 22 XXX
	 -0010-09-15T04:44:23 = 15 X/X

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 XX XXXXX
	  1995-12-22T09:05:02 = 9:05 XXX XXXXX
	 -0010-09-15T04:44:23 = 4:44 XXX XXXXX

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 XX XXXXX
	  1995-12-22T09:05:02 = 9:05:02 XXX XXXXX
	 -0010-09-15T04:44:23 = 4:44:23 XXX XXXXX

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = XXX, 2-5
	  1995-12-22T09:05:02 = XXX, 12-22
	 -0010-09-15T04:44:23 = X/X, 9-15

       MMdd (dd/MM)

	  2008-02-05T18:30:30 = 05/02
	  1995-12-22T09:05:02 = 22/12
	 -0010-09-15T04:44:23 = 15/09

       MMM (LLL)

	  2008-02-05T18:30:30 = XXX
	  1995-12-22T09:05:02 = XXX
	 -0010-09-15T04:44:23 = XXX

       MMMd (MMM d)

	  2008-02-05T18:30:30 = XXX 5
	  1995-12-22T09:05:02 = XXX 22
	 -0010-09-15T04:44:23 = XXX 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = XXX XXX 5
	  1995-12-22T09:05:02 = XXX XXX 22
	 -0010-09-15T04:44:23 = X/X XXX 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = XXXXX 5
	  1995-12-22T09:05:02 = XXXXX 22
	 -0010-09-15T04:44:23 = XXXXXX 15

       MMMMdd (dd MMMM)

	  2008-02-05T18:30:30 = 05 XXXXX
	  1995-12-22T09:05:02 = 22 XXXXX
	 -0010-09-15T04:44:23 = 15 XXXXXX

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = XXX XXXXX 5
	  1995-12-22T09:05:02 = XXX XXXXX 22
	 -0010-09-15T04:44:23 = X/X XXXXXX 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = XXX, 2008-2-5
	  1995-12-22T09:05:02 = XXX, 1995-12-22
	 -0010-09-15T04:44:23 = X/X, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 XXX
	  1995-12-22T09:05:02 = 1995 XXX
	 -0010-09-15T04:44:23 = -10 XXX

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = XXX, 2008 XXX 5
	  1995-12-22T09:05:02 = XXX, 1995 XXX 22
	 -0010-09-15T04:44:23 = X/X, -10 XXX 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 XXXXX
	  1995-12-22T09:05:02 = 1995 XXXXX
	 -0010-09-15T04:44:23 = -10 XXXXXX

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 Q1
	  1995-12-22T09:05:02 = 1995 Q4
	 -0010-09-15T04:44:23 = -10 Q3

       yyMM (MM/yy)

	  2008-02-05T18:30:30 = 02/08
	  1995-12-22T09:05:02 = 12/95
	 -0010-09-15T04:44:23 = 09/-10

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

       yyyyMMMM (MMMM y)

	  2008-02-05T18:30:30 = XXXXX 2008
	  1995-12-22T09:05:02 = XXXXX 1995
	 -0010-09-15T04:44:23 = XXXXXX -10

   Miscellaneous
       Prefers 24 hour time?

       No

       Local first day of the week

       XXXX XXX

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.18.2							    2017-10-06					       DateTime::Locale::tig_ER(3)
All times are GMT -4. The time now is 09:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy