Alteryx Designer Desktop Discussions

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

Simple regex question

Hamder83
11 - Bolide

Hi 

I wanna phrase these filenames:

FileName
EKP Customer Details_Backing_Masai Clothing (2400034242).csv

Collections MAY 2020_Backing_ECCO_June 2020 (2400033957+240033958).csv

 

And remove anything beside whats in ()

So 
EKP Customer Details_Backing_Masai Clothing (2400034242).csv
Results in:

2400034242

And 

Collections MAY 2020_Backing_ECCO_June 2020 (2400033957+240033958).csv

Results in:
2400033957+240033958

Ive sat here for two hours using https://regex101.com/ but im clearly too dumb 😕 

 

2 REPLIES 2
wwatson
12 - Quasar

wwatson_0-1596017907606.png

 

Hamder83
11 - Bolide

Hi 

Thanks for the reply, works like a charm! 

Kind regards

 

Labels