Alteryx Delimiter -

[Jwwwson]

Hi, 

May I ask is there a simply way to separate a column, so that I can get column with only number in "ID" column? There are few types of data, as shown below. Thanks!

ID	Name
USA-12345	John
HKG-23456	Peter
HK12345	Mary
USA34567	Henry

Cheers, 

Jason

[MarqueeCrew · Accepted solution]

@Jwwwson ,

using the data cleanse tool, you can remove letters and punctuation.  

I like regular expressions.  

Regex_Replace([ID],"\D","")

 that will erase any non-digits. 

cheers,

 mark

[Jwwwson]

Hi @MarqueeCrew 

Thanks a lot!

Cheers, 

Jason