About the replace function

Question & Answer
,
1

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?

2

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

3

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 “”

4

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

1 Like
5

Perfect. Could you please solve the topic?