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", ...
Need Help
Show and Tell
Tutorial Requests
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi zingiwng

     

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

     

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.