Getting the base file name with a file with multiple periods

Avatar

Avatar

shche123

Avatar

shche123

shche123

23-05-2016

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

Accepted Solutions (0)

Answers (1)

Answers (1)