Forum Discussion
Keep only Dictionary English words
I want to filter out Text Column which contains unique words
i dont have dictonary wordlist
I want to remove non english dictionary words from it and move them to another column
input
gsgdhdfgc
hello
jnjkhhiu
hbjbhk788
name
output
hello
name
gsgdhdfgc
jnjkhhiu
hbjbhk788
You will need to have an English word list. The list of English words can be downloaded from Kaggle @ https://www.kaggle.com/datasets/yk1598/479k-english-words
This list can be loaded in Power BI and then against this word query can be run.
I have created the solution in Excel (including above English words list) and uploaded to https://1drv.ms/x/s!Akd5y6ruJhvhuhUn9nNJwrRdjkP6?e=rZT3UG
The solution will give this output
2 Replies
You will need to have an English word list. The list of English words can be downloaded from Kaggle @ https://www.kaggle.com/datasets/yk1598/479k-english-words
This list can be loaded in Power BI and then against this word query can be run.
I have created the solution in Excel (including above English words list) and uploaded to https://1drv.ms/x/s!Akd5y6ruJhvhuhUn9nNJwrRdjkP6?e=rZT3UG
The solution will give this output
Vijay_A_Verma guruji help needed