About the replace function

I want to use the replace function to change both fixed strings and variables to NULL at the same time.

probably can’t use regular expressions.

Is there a good solution?

Hi @techtech1919
do you have a sample for both cases? Input and expected outcome!
BR

Thank you so much.

input sample string
“OK:xxx.20231231.map1.com,NG:xxx.20240101.map2.com,OK:xxx.20240102.map3.com,NG:xxx.20240103.map4.com”

expected outcome
field map1 “OK”
field map2 “”
field map3 “OK”
field map4 “”

I was able to solve it using locate and substring functions.

1 Like

Perfect. Could you please solve the topic?