How do I substitute distinct text from a text field.

[zingiwng]

I'm trying to substitiue multiple values from a text column to use in a word cloud. Following this question I am able to filter out most the words I need. However, when I try to with "a", "i", "or", it will remove every every instances of that.

I.E. Have => hve

     Alligator => llgt

What can I do to substitue every distinct instance of "a", "i", and "or" from a text column?

Thanks

zingwing

[Phil_Seamark · Accepted solution]

Hi @zingiwng

You could try the REPLACE function in the Query Editor and create several rules

[zingiwng]

@Phil_Seamark If I use Replace Values in the query editor will it only run the replacement on existing data or will it also run on all future data?

[Anonymous]

@zingiwng

The Query will re-run every time the data is refreshed. So the answer is yes, it will work on all future data.