So I've got a requirement to break up a semi-standardised filename into parts which will then be inserted into columns as metadata.
Oddly, Nintex doesn't seem to have any way to perform Substring-before or Substring-after.
I've the below with no luck...
1) Encode 'filename' as XML (saved as 'XML-Filename')
2) Use the QUERY XML action to perform a substring-before on that String.
XML - 'XML-Filename'
Output 1 - fn-substring-before('XML-Filename',delimiter)
It will always just output Filename no matter.
Can anyone offer any advice on how to get this to work? Banging my head on my desk at this point.