I am having text like below and would like to remove all extra semicolon.
Input: A;;B;;;;C;;;;;D;E;
Output: A;B;C;D
I have tried couple of solutions but non seems to work
Solved! Go to Solution.
@NidhiAg
what happened with the last letter E?😁
Hi @NidhiAg,
There is also a non-regex route:
I've attached my workflow for you to download if needed.
Kind regards,
Jonathan