how to replace all the information by replace?

[WuCong]

I have one fields which the value is NA;NA;NA;aa;NA

I want to replace NA; with empty,

while I found it can only replace the first NA; so the result is NA;NA;aa;NA, what I expected is aa;NA

[APrasad_Tri]

Hi @wu cong? , thank you for your question!

Hover and drag the "NA;" to get the suggestions. Select Replace as shown in the screenshot

Here, it selects all the occurrences of "NA;" Add the step.

In case this selection is not occurring, then please Edit the step and make sure that the "Match all occurrences" check is selected as shown in the screenshot

I hope this helps. Please do reach out to us in case you are having any issues.

Best,

Apeksha