Forum Discussion

zingiwng's avatar
zingiwng
Frequent Visitor
9 years ago
Solved

How do I substitute distinct text from a text field.

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

Need Help
Show and Tell
Tutorial Requests

3 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi zingiwng

     

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

     

    • zingiwng's avatar
      zingiwng
      Frequent Visitor
      9 years ago

      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's avatar
        Anonymous
        Not applicable
        9 years ago

        zingiwng

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