How to get only numbers from string with XPath

xpath xpath-2.0
Attila Zobolyak picture Attila Zobolyak · Sep 7, 2011 · Viewed 9.9k times · Source

I have a string which contains numbers. Is it feasible only with XPath that I get only numbers from it?

For example: myString="abcd12ef34gh567", result: 1234567

Answer

Dimitre Novatchev picture Dimitre Novatchev · Sep 7, 2011

Use:

translate(., translate(.,'0123456789',''), '')

This is the so called "double-translate" method, first proposed by @Michael Kay and can be used both in XPath 1.0 and in XPath 2.0.

Of course, in XPath 2.0 using RegeX will generally be more efficient:

replace('abc123def590xyz', '[^\d]', '')

Related questions

XPath to retrieve text within span

I am trying to figure out the XPath which will retrieve the 'text Data 3' from the following HTML snippet <span class="inner-span"> Text-data 1 <br> <span>Text Data 2</span> text Data 3 </…

Read More
XSL if test starts-with

Given this piece of XML <dc:date>info:eu-repo/date/embargoEnd/2013-06-12</dc:date> <dc:date>2012-07-04</dc:date> I should need with XSL to output only the year of …

Read More
xpath dates comparison

I'm trying to filter elements based on an attribute that is a date in the format yyyy-MM-dd. My XML looks like this: <?xml version="1.0" encoding="utf-8"?> <root> <article title="wired" pub-date="2010-11-22" /> <…

Read More