SFMC AMPScript RegEx

sfmc-ampscript-regex-tests.amp

%%[
var @s, @o, @p, @m

output(concat("<br>Strip leading zeroes from a string"))
set @s = "0000012345"
set @p = "^0*(\d+)$"
set @o = RegExMatch(@s, @p, 1)
output(concat("<br>input:  ", @s))
output(concat('<br>pattern: "', @p, '"'))
output(concat("<br>output: ", @o))

output(concat("<br><br>Check for all digits, no match"))
set @s = "12345x"
set @p = "^\d*$"
set @o = RegExMatch(@s, @p, 0)
output(concat("<br>input: ", @s))
output(concat('<br>pattern: "', @p, '"'))
output(concat("<br>output: ", @o))

output(concat("<br><br>Check for all digits, match"))
set @s = "12345"
set @p = "^\d*$"
set @o = RegExMatch(@s, @p, 0)
output(concat("<br>input: ", @s))
output(concat('<br>pattern: "', @p, '"'))
output(concat("<br>output: ", @o))

output(concat("<br><br>Replace parenthetical text with space"))
set @s = "whee (whatever it is) whoop"
set @p = "\s\(.+\)\s"
set @m = RegExMatch(@s, @p, 0, "IgnoreCase")
set @o = replace(@s, @m, " ")
output(concat("<br>input:  ", @s))
output(concat('<br>pattern: "', @p, '"'))
output(concat("<br>match: ", @m))
output(concat("<br>replaced: ", @o))

]%%

Actually, I want to replace all even or odd occurrences in a string with *(asterisk).

e.g
input: Testing Text
output: T*s*i*g T*x*

I came up with this regex: (?<!^(?:\S\S|\s\S|\S\s)*).

but the RegExMatch only replaces the first occurrence e.g T*sting Text

Here you can see It's working: https://regex101.com/r/mXKvqn/1
It's not working with RegExMatch: https://mcsnippets.herokuapp.com/s/6LXtg4Y3

Why bend your mind with a regex when you can use a loop and the mod function to detect odd/even?

https://mcsnippets.herokuapp.com/s/n3wtVxJP

Yeah looks great, Thanks Adam.