how to replace '??' or '?' with " ' " and replace "#NAME?" with space in Regex-field,

Fang2023

Hi, 

I tried to replace '??' or '?' with " ' " and replace "#NAME?" with space in Regex-field, but it doesn't work.

Any suggestions?

Thanks.

Regex_replace(
Regex_replace(
Regex_replace([_CurrentField_],"#NAME?"," "),
" ??", "'"),"?","'")

Wrong
ID	A	B
1	plans	it wasn?t hard
2	#NAME?	We didn??t prepare
3	#NAME?	Questions
4	#NAME?	#NAME?
Correct
ID	A	B
1	plans	it wasn't hard
2	admin	We didn't prepare
3	washing dishes	Questions
4	tracking delivery	yes,it's meaning

danilang

Hi @Fang2023 

? is a reserved character in regex meaning zero or one.  If you want to match on those, you have to escape them with \ 

Regex_replace(
Regex_replace(
Regex_replace([_CurrentField_],"#NAME\?"," "),
" \?\?", "'"),"\?","'")

You also have a space in your " \?\?" string.  You need to take this out.

Dan