cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
zingiwng Frequent Visitor
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How do I substitute distinct text from a text field.

Hi @zingiwng

 

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

replace.png

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3

Re: How do I substitute distinct text from a text field.

Hi @zingiwng

 

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

replace.png

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

zingiwng Frequent Visitor
Frequent Visitor

Re: How do I substitute distinct text from a text field.

@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?

Pfister Established Member
Established Member

Re: How do I substitute distinct text from a text field.

@zingiwng

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

Greetings Hp Pfister
Power Query Buch online auf http://www.powerbi-pro.com

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)