Hello,
I need some help in how to identify character in a number field:
example
I want to identify and remove it
expected result should be like from 063799541A ---------> 063799541
Thanks
Hi @EvansM,
I'd try the following Regex:
Before:
After:
Why?
In the [] you can specify a character set and we use everything between a-z (all small letters) as well as A-Z (all capital letters). Combine with the Replace Method and the empty Replacement Text makes up removing all letters from the String.
Does that work in your case or are there edge cases that aren't covered?
Best
Alex
Absolutely agreeing with @grossal but showing that there are multiple ways to do things in Alteryx, you can also use a Data Cleanse tool:
@EvansM Another tool we can use is the Regex_Replace 😁
@grossal Thanks a lot. That works. But I still want to know how many records have characters in [REFERENCE_CODE1] column before I removed them.
@T_Willins Thanks a lot. That works. But I still want to know how many records have characters in [REFERENCE_CODE1] column before I removed them.
@Qiu Thanks a lot. I'm total zero when comes to REGEX
