AnsweredAssumed Answered

Is it possible to perform a Substring-before function in Nintex?

Question asked by shodgson86 on Oct 13, 2014
Latest reply on Feb 28, 2017 by cazza162

Hi all,


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.