Expand my Community achievements bar.

Getting the base file name with a file with multiple periods

Avatar

Level 1

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.doc

substring-before(/process_data/@strInDocFileName, "."))

returns: "file"

need: "file.name"

Would be great to have or write substring-before-last function

substring-before-last(/process_data/@strInDocFileName, "."))

to get: "file.name"

Is there a way to do it?

Thanks

1 Reply