Search code examples
xpathxpath-2.0

How to get only numbers from string with XPath


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


Solution

  • 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]', '')