We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Delimit Seperator

Myusrename001
8 - Asteroid

Hi Team,

 

I have multiple lines with multiple "-" values, I need to seperate only the right values containing "-".

Any help would really be appreciated.

 

Example - Raw

 

3136 -ABU H2O ASSET MGMT LLP RVC144827-694102
3P BLUESTAR MASTER FUND RVC160201-833121
3P BREVAN HOWARD ALPHA STRAT RIC208936-1067205

 

Afrer applying the result on workflows should reflect as per below

 

3136 -ABU H2O ASSET MGMT LLP RVC144827
3P BLUESTAR MASTER FUND RVC160201
3P BREVAN HOWARD ALPHA STRAT RIC208936
2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@Myusrename001 
We can use Regex for this case.

I usually use this site to test my Regex.

https://regex101.com/

1005-Myusrename001.PNG

Myusrename001
8 - Asteroid

Thanks so much for your help ! 

Labels
Top Solution Authors