Regex expression error in Formula tool

[ZoeyL1GL]

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

[MarqueeCrew]

REGEX_Replace([Column], "(\d{1,})", "F$1")

Quick guess

[ZoeyL1GL]

@Marquee, thank you for your response! hmm, this seems still not working - it returns results like F for all lines. any further suggestions please?

[MarqueeCrew · Accepted solution]

@ZoeyL1GL,

It seems to work for me.  Please help me to understand what I'm doing differently?

Cheers,

Mark

[ZoeyL1GL]

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