Find the value between two ranges in xml file of one particular tag

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
0
down vote

favorite












I have xml file where having tags <a>0000123</a>, <a>1200000</a>, <a>0001000</a>.



I need to get only the value which this particular tag should be between 100 to 1000.




xml




share|improve this question






















  • tag will be in format of <a>0000123</a>
    – Ugan
    Feb 27 at 13:32










  • So the tags are a tags (all a tags?) and their values is what you want to find? Do you want copies of those tags or do you just need the actual values?
    – Kusalananda
    Feb 27 at 13:33







  • 1




    Please edit your question and add a xml example
    – ChristophS
    Feb 27 at 13:36














up vote
0
down vote

favorite












I have xml file where having tags <a>0000123</a>, <a>1200000</a>, <a>0001000</a>.



I need to get only the value which this particular tag should be between 100 to 1000.




xml




share|improve this question






















  • tag will be in format of <a>0000123</a>
    – Ugan
    Feb 27 at 13:32










  • So the tags are a tags (all a tags?) and their values is what you want to find? Do you want copies of those tags or do you just need the actual values?
    – Kusalananda
    Feb 27 at 13:33







  • 1




    Please edit your question and add a xml example
    – ChristophS
    Feb 27 at 13:36












up vote
0
down vote

favorite









up vote
0
down vote

favorite











I have xml file where having tags <a>0000123</a>, <a>1200000</a>, <a>0001000</a>.



I need to get only the value which this particular tag should be between 100 to 1000.




xml




share|improve this question














I have xml file where having tags <a>0000123</a>, <a>1200000</a>, <a>0001000</a>.



I need to get only the value which this particular tag should be between 100 to 1000.





xml





share|improve this question













share|improve this question




share|improve this question








edited Feb 27 at 13:46









Kusalananda

103k13202318




103k13202318










asked Feb 27 at 13:32









Ugan

1




1











  • tag will be in format of <a>0000123</a>
    – Ugan
    Feb 27 at 13:32










  • So the tags are a tags (all a tags?) and their values is what you want to find? Do you want copies of those tags or do you just need the actual values?
    – Kusalananda
    Feb 27 at 13:33







  • 1




    Please edit your question and add a xml example
    – ChristophS
    Feb 27 at 13:36
















  • tag will be in format of <a>0000123</a>
    – Ugan
    Feb 27 at 13:32










  • So the tags are a tags (all a tags?) and their values is what you want to find? Do you want copies of those tags or do you just need the actual values?
    – Kusalananda
    Feb 27 at 13:33







  • 1




    Please edit your question and add a xml example
    – ChristophS
    Feb 27 at 13:36















tag will be in format of <a>0000123</a>
– Ugan
Feb 27 at 13:32




tag will be in format of <a>0000123</a>
– Ugan
Feb 27 at 13:32












So the tags are a tags (all a tags?) and their values is what you want to find? Do you want copies of those tags or do you just need the actual values?
– Kusalananda
Feb 27 at 13:33





So the tags are a tags (all a tags?) and their values is what you want to find? Do you want copies of those tags or do you just need the actual values?
– Kusalananda
Feb 27 at 13:33





1




1




Please edit your question and add a xml example
– ChristophS
Feb 27 at 13:36




Please edit your question and add a xml example
– ChristophS
Feb 27 at 13:36










2 Answers
2






active

oldest

votes

















up vote
1
down vote













Using XMLStarlet:



xml sel -t -v '//a[. > 100 and . < 1000]' -nl file.xml


This will return a list of values between 100 and 1000. These values will be taken from the values of the a nodes of the XML document in file.xml, regardless of where these appear. Zero-filled numbers seems to be handled properly. The -nl at the end ensures that the output's last line has a newline at the end.



On some systems, XMLStarlet is installed as xmlstarlet instead of just xml.



Example:



$ cat file.xml
<?xml version="1.0"?>
<root>
 <a>0000123</a>
 <a>1200000</a>
 <a>0001000</a>
</root>

$ xml sel -t -v '//a[. > 100 and . < 1000]' -nl file.xml
0000123





share|improve this answer






















  • In my case (kubuntu 17.10, bash) the command of the xmlstarlet package is xmlstarlet instead of xml. Works like a charme and does not look too complicated ;)
    – ChristophS
    Feb 27 at 15:09

















up vote
1
down vote













With xmllint :



xmllint --xpath '//a[text() > 100 and text() < 1000]/text()' file.xml


If you want to separate with newlines :



xmllint --shell file.xml <<< 'xpath //a[text() > 100 and text() < 000]/text()' |
 grep -oP 'content=K.*'


AFAIK, it's a limitation of using xmllint without the switch --shell






share|improve this answer






















  • How do you separate the result? for example by nl or whitespace ...
    – ChristophS
    Feb 27 at 14:55










  • Check my edited post
    – Gilles Quenot
    Feb 27 at 15:01






  • 1




    As far as I could figure out, the output (without visual) separation is a correct xpath expression. A XSLT transformation could be the solution (compgroups.net/comp.text.xml/…). Great answer anyway!
    – ChristophS
    Feb 27 at 15:04










Your Answer







StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);








 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f426939%2ffind-the-value-between-two-ranges-in-xml-file-of-one-particular-tag%23new-answer', 'question_page');

);

Post as a guest

















2 Answers
2






active

oldest

votes








2 Answers
2






active

oldest

votes









active

oldest

votes






active

oldest

votes








up vote
1
down vote













Using XMLStarlet:



xml sel -t -v '//a[. > 100 and . < 1000]' -nl file.xml


This will return a list of values between 100 and 1000. These values will be taken from the values of the a nodes of the XML document in file.xml, regardless of where these appear. Zero-filled numbers seems to be handled properly. The -nl at the end ensures that the output's last line has a newline at the end.



On some systems, XMLStarlet is installed as xmlstarlet instead of just xml.



Example:



$ cat file.xml
<?xml version="1.0"?>
<root>
 <a>0000123</a>
 <a>1200000</a>
 <a>0001000</a>
</root>

$ xml sel -t -v '//a[. > 100 and . < 1000]' -nl file.xml
0000123





share|improve this answer






















  • In my case (kubuntu 17.10, bash) the command of the xmlstarlet package is xmlstarlet instead of xml. Works like a charme and does not look too complicated ;)
    – ChristophS
    Feb 27 at 15:09














up vote
1
down vote













Using XMLStarlet:



xml sel -t -v '//a[. > 100 and . < 1000]' -nl file.xml


This will return a list of values between 100 and 1000. These values will be taken from the values of the a nodes of the XML document in file.xml, regardless of where these appear. Zero-filled numbers seems to be handled properly. The -nl at the end ensures that the output's last line has a newline at the end.



On some systems, XMLStarlet is installed as xmlstarlet instead of just xml.



Example:



$ cat file.xml
<?xml version="1.0"?>
<root>
 <a>0000123</a>
 <a>1200000</a>
 <a>0001000</a>
</root>

$ xml sel -t -v '//a[. > 100 and . < 1000]' -nl file.xml
0000123





share|improve this answer






















  • In my case (kubuntu 17.10, bash) the command of the xmlstarlet package is xmlstarlet instead of xml. Works like a charme and does not look too complicated ;)
    – ChristophS
    Feb 27 at 15:09












up vote
1
down vote










up vote
1
down vote









Using XMLStarlet:



xml sel -t -v '//a[. > 100 and . < 1000]' -nl file.xml


This will return a list of values between 100 and 1000. These values will be taken from the values of the a nodes of the XML document in file.xml, regardless of where these appear. Zero-filled numbers seems to be handled properly. The -nl at the end ensures that the output's last line has a newline at the end.



On some systems, XMLStarlet is installed as xmlstarlet instead of just xml.



Example:



$ cat file.xml
<?xml version="1.0"?>
<root>
 <a>0000123</a>
 <a>1200000</a>
 <a>0001000</a>
</root>

$ xml sel -t -v '//a[. > 100 and . < 1000]' -nl file.xml
0000123





share|improve this answer














Using XMLStarlet:



xml sel -t -v '//a[. > 100 and . < 1000]' -nl file.xml


This will return a list of values between 100 and 1000. These values will be taken from the values of the a nodes of the XML document in file.xml, regardless of where these appear. Zero-filled numbers seems to be handled properly. The -nl at the end ensures that the output's last line has a newline at the end.



On some systems, XMLStarlet is installed as xmlstarlet instead of just xml.



Example:



$ cat file.xml
<?xml version="1.0"?>
<root>
 <a>0000123</a>
 <a>1200000</a>
 <a>0001000</a>
</root>

$ xml sel -t -v '//a[. > 100 and . < 1000]' -nl file.xml
0000123






share|improve this answer














share|improve this answer



share|improve this answer








edited Feb 27 at 13:51

























answered Feb 27 at 13:40









Kusalananda

103k13202318




103k13202318











  • In my case (kubuntu 17.10, bash) the command of the xmlstarlet package is xmlstarlet instead of xml. Works like a charme and does not look too complicated ;)
    – ChristophS
    Feb 27 at 15:09
















  • In my case (kubuntu 17.10, bash) the command of the xmlstarlet package is xmlstarlet instead of xml. Works like a charme and does not look too complicated ;)
    – ChristophS
    Feb 27 at 15:09















In my case (kubuntu 17.10, bash) the command of the xmlstarlet package is xmlstarlet instead of xml. Works like a charme and does not look too complicated ;)
– ChristophS
Feb 27 at 15:09




In my case (kubuntu 17.10, bash) the command of the xmlstarlet package is xmlstarlet instead of xml. Works like a charme and does not look too complicated ;)
– ChristophS
Feb 27 at 15:09












up vote
1
down vote













With xmllint :



xmllint --xpath '//a[text() > 100 and text() < 1000]/text()' file.xml


If you want to separate with newlines :



xmllint --shell file.xml <<< 'xpath //a[text() > 100 and text() < 000]/text()' |
 grep -oP 'content=K.*'


AFAIK, it's a limitation of using xmllint without the switch --shell






share|improve this answer






















  • How do you separate the result? for example by nl or whitespace ...
    – ChristophS
    Feb 27 at 14:55










  • Check my edited post
    – Gilles Quenot
    Feb 27 at 15:01






  • 1




    As far as I could figure out, the output (without visual) separation is a correct xpath expression. A XSLT transformation could be the solution (compgroups.net/comp.text.xml/…). Great answer anyway!
    – ChristophS
    Feb 27 at 15:04














up vote
1
down vote













With xmllint :



xmllint --xpath '//a[text() > 100 and text() < 1000]/text()' file.xml


If you want to separate with newlines :



xmllint --shell file.xml <<< 'xpath //a[text() > 100 and text() < 000]/text()' |
 grep -oP 'content=K.*'


AFAIK, it's a limitation of using xmllint without the switch --shell






share|improve this answer






















  • How do you separate the result? for example by nl or whitespace ...
    – ChristophS
    Feb 27 at 14:55










  • Check my edited post
    – Gilles Quenot
    Feb 27 at 15:01






  • 1




    As far as I could figure out, the output (without visual) separation is a correct xpath expression. A XSLT transformation could be the solution (compgroups.net/comp.text.xml/…). Great answer anyway!
    – ChristophS
    Feb 27 at 15:04












up vote
1
down vote










up vote
1
down vote









With xmllint :



xmllint --xpath '//a[text() > 100 and text() < 1000]/text()' file.xml


If you want to separate with newlines :



xmllint --shell file.xml <<< 'xpath //a[text() > 100 and text() < 000]/text()' |
 grep -oP 'content=K.*'


AFAIK, it's a limitation of using xmllint without the switch --shell






share|improve this answer














With xmllint :



xmllint --xpath '//a[text() > 100 and text() < 1000]/text()' file.xml


If you want to separate with newlines :



xmllint --shell file.xml <<< 'xpath //a[text() > 100 and text() < 000]/text()' |
 grep -oP 'content=K.*'


AFAIK, it's a limitation of using xmllint without the switch --shell







share|improve this answer














share|improve this answer



share|improve this answer








edited Feb 27 at 15:01

























answered Feb 27 at 14:36









Gilles Quenot

15.3k13448




15.3k13448











  • How do you separate the result? for example by nl or whitespace ...
    – ChristophS
    Feb 27 at 14:55










  • Check my edited post
    – Gilles Quenot
    Feb 27 at 15:01






  • 1




    As far as I could figure out, the output (without visual) separation is a correct xpath expression. A XSLT transformation could be the solution (compgroups.net/comp.text.xml/…). Great answer anyway!
    – ChristophS
    Feb 27 at 15:04
















  • How do you separate the result? for example by nl or whitespace ...
    – ChristophS
    Feb 27 at 14:55










  • Check my edited post
    – Gilles Quenot
    Feb 27 at 15:01






  • 1




    As far as I could figure out, the output (without visual) separation is a correct xpath expression. A XSLT transformation could be the solution (compgroups.net/comp.text.xml/…). Great answer anyway!
    – ChristophS
    Feb 27 at 15:04















How do you separate the result? for example by nl or whitespace ...
– ChristophS
Feb 27 at 14:55




How do you separate the result? for example by nl or whitespace ...
– ChristophS
Feb 27 at 14:55












Check my edited post
– Gilles Quenot
Feb 27 at 15:01




Check my edited post
– Gilles Quenot
Feb 27 at 15:01




1




1




As far as I could figure out, the output (without visual) separation is a correct xpath expression. A XSLT transformation could be the solution (compgroups.net/comp.text.xml/…). Great answer anyway!
– ChristophS
Feb 27 at 15:04




As far as I could figure out, the output (without visual) separation is a correct xpath expression. A XSLT transformation could be the solution (compgroups.net/comp.text.xml/…). Great answer anyway!
– ChristophS
Feb 27 at 15:04












 

draft saved


draft discarded


























 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f426939%2ffind-the-value-between-two-ranges-in-xml-file-of-one-particular-tag%23new-answer', 'question_page');

);

Post as a guest
































































-

Popular posts from this blog

Peggy Mitchell

Image
EastEnders character This article is about the soap opera character. For the British tennis player, see Peggy Michell. For the author, see Margaret Mitchell. Peggy Mitchell Barbara Windsor as Peggy Mitchell (2008) EastEnders character Portrayed by Jo Warne (1991) Barbara Windsor (1994–2016) Duration 1991, 1994–2010, 2013–2016 First appearance Episode 650 30 April 1991  ( 1991-04-30 ) Last appearance Episode 5286 17 May 2016  ( 2016-05-17 ) (appearance) Episode 5287 19 May 2016 (voiceover) Introduced by Michael Ferguson (1991) Barbara Emile (1994) Louise Berridge (2004) Kate Harwood (2005) Lorraine Newman (2013) Dominic Treadwell-Collins (2014) Spin-off appearances The Mitchells - Naked Truths (1998) Classification Former; regular Profile Other names Peggy Butcher Occupation Barmaid Businesswoman Pub landlady Jo Warne as Peggy Mitchell (1991) Family Family Mitchell Father Jack Martin Mother Lily Martin Sisters Aunt ...
Read more

Palaiologos

Image
Palaiologos Παλαιολόγος Palaeologus, Palaeologue Imperial Family Double-headed eagle with the family cypher Country Byzantine Empire, Duchy of Montferrat (remaining lineage after Empire annexed by Ottomans) Founded 11th century  ( 11th century ) Founder Nikephoros Palaiologos (first known) Final ruler Constantine XI Palaiologos (Byzantine Empire) Margaret Paleologa (Montferrat) Titles Byzantine Emperor Marquess of Montferrat Style(s) "Augustus" "Basileus" "Autokrator" Traditions Greek Orthodoxy (predominantly) Roman Catholicism (remaining lineage in Montferrat) Dissolution 1533  ( 1533 ) Cadet branches Claimants: House of Kastrioti (defunct) House of Rurik (defunct) Palaiologan dynasty Chronology Michael VIII 1259–1282 with Andronikos II as co-emperor, 1261–1282 Andronikos II 1282–1328 with Michael IX (1294–1320) and Andronikos III (1321–1328) as co-emperors Andronikos III 1328–1341 John...
Read more

The Forum (Inglewood, California)

Image
The Forum "LA Forum" Prairie Ave. façade of The Forum in 2014 Full name The Forum, presented by Chase Former names The Forum (1967–1988) Great Western Forum (1988–2003) Address 3900 W. Manchester Blvd Location Inglewood, California Coordinates Coordinates: 33°57′29″N 118°20′31″W  /  33.95806°N 118.34194°W  / 33.95806; -118.34194 Public transit     Downtown Inglewood station Owner The Madison Square Garden Company Operator MSG Entertainment Seating type Reserved Capacity 17,500 Half-bowl: 8,000 Construction Broke ground July 1, 1966  ( 1966-07-01 ) Opened December 30, 1967  ( 1967-12-30 ) Renovated 1988, 2012–2014 Construction cost $16 million Renovation: 2014: $76.5 million Architect Charles Luckman Associates (original) Brisbin Brook Beynon (renovation) Structural engineer Johnson & Nielsen Associates (original) Severud Associates (renovation) Genera...
Read more