Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Cleaning all extra semicolon using regex

NidhiAg
7 - Meteor

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

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@NidhiAg 
what happened with the last letter E?😁

Capture1A.PNG

Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @NidhiAg,

 

There is also a non-regex route:

 

Jonathan-Sherman_0-1617926173466.png

 

 

I've attached my workflow for you to download if needed.

 

Kind regards,

Jonathan

Labels
Top Solution Authors