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!
Cheers,
Jason
@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
Hi @MarqueeCrew
Thanks a lot!
