Hi,
Having a problem here - would be so much appreciated if anyone can provide the solution.
to identify any digit character(s) in a field and to replace with a string letter(such as F) to a string letter and any digit character(s):
to
I used Formula tool with an expression: REGEX_Replace([Column], "\d{0,}", "F\d{0,}")
tested the regex terms in Regexer.com, and it works well there. However, when applying the same expression on Alteryx, it gives me weird answers:
Or an any other function/tool would achieve the same result rather than using RegEx?
Any help would be appreciated!
Thanks in advance!
Zoey
Solved! Go to Solution.
@Marquee, thank you for your response! hmm, this seems still not working - it returns results like F for all lines. any further suggestions please?
Thank you @Marquee!
Sorry that was my mistake - I have missed the "()" in the line "(\d{1,})". I thought () didn`t do anything in RegEx.
Many thanks, and it perfectly works now!
Zoey