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
Solved! Go to 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