Hello
I have an expression that looks like this:
Anna / / / / / / June
Anna / / / June
Anna / / / / / / / / December
I want to replace multiplied / with just one /.
How can I do that with a formula?
Thanks:)
Solved! Go to Solution.
Fore more words here: @flying008
Anna Julia Ola / / / / Anna
I will have the following output:
Anna / Julia / Ola / Anna
Whereas I would expect to have: Anna Julia Ola / Anna
How this could be amended in formula?
REGEX_Replace([Comments], '[\s/]+/', ' / ')
REGEX_Replace([Data], '[ /]{2,}', '/')