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!

Thank you so much.

input sample string

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?