Getting the base file name with a file with multiple periods:
file.name.doc -> file.name Is there a function like
"substring-before-last()" or can it be written in Workbench?example:file
name: file.name.docsubstring-before(/process_data/@strInDocFileName,
"."))returns: "file"need: "file.name"Would be great to have or write
substring-before-last
functionsubstring-before-last(/process_data/@strInDocFileName, "."))to
get: "file.name"Is there a way to do it?Thanks