Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply

Extract non-English words from string

Hi team, I'm hoping someon might be able to help

I have a column of data that is a mixture of English words and non-English text, and I need to clean out the non-English text with a calculated column, leaving just the English words separated by spaces. Here's an example of my data:

 

Example data:

div dir classmsrtestatefielddivdiv dataspcanvascontrol dataspcanvasdataversion1.0 dataspcontroldata123quotpositionquot58123quotzoneIndexqu

 

Here's an example of the output I'd like:

div dir class estate field div div data canvas control data canvas data version data control data position zone index


I am proposing to use this data source for my English words:

https://www.kaggle.com/datasets/yk1598/479k-english-words?resource=download

I'd be loading this data as a text file into my report and into a table called 'English Words'.

Any help would be greatly appreciated 🙂

0 REPLIES 0

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Users online (540)