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,}', '/')
User | Count |
---|---|
16 | |
14 | |
11 | |
6 | |
6 |