Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Getting the base file name with a file with multiple periods

shche123
Level 1
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