Search code examples
regexxpathsonarqube

how to use '*' in XPATH starts-with()?

we received banking statements from the SAP System. We sometimes observe the naming convention of the file name will be not as per the standards and the files will be rejected. We wanted to validate the file name, as per the below example, we get the file name in the name attribute.

Can the country ISO code escape in the validation? We wanted an Xpath that captures GLO_***_UPLOAD_STATEMENT like this so that ISO code is not validated.

Example XML:

<?xml version="1.0" encoding="UTF-8"?>
<Details name="GLO_ZFA_UPLOAD_STATEMENT" type="banking" version="3.0">
    <description/>
    <object>
        <encrypted data="b528f05b96102f5d99743ff6122bb0984aa16a02893984a9e427a44fcedae1612104a7df1173d9c61a99ebe0c34ea67a46aecc86f41f5924f74dd525"/>
    </object>
</Details>

Xpath tried: Details[@type="banking"]/@name[not(starts-with(., "GLO_***_UPLOAD_STATEMENT"))]

which is not working :(

Can anyone help here, please :) Thanks in advance!

Solution

  • Try using the matches() function for a regex like this:

    Details[@type="banking"]/@name[not(matches(., "^GLO_(.){3}_UPLOAD_STATEMENT"))]