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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

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