Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I'm trying to clean my data. I was given a list of companies but they are with special characters. Is there a way to clean it or search it on google to return the correct data? Please see below.
Thank you all in advance.
Regards,
Solved! Go to Solution.
Hi @ZZZZZZZ37 ,
This is my test table:
Please try:
Text.Select([Column1],{"A".."z"})
Cleaned data:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ZZZZZZZ37 ,
This is my test table:
Please try:
Text.Select([Column1],{"A".."z"})
Cleaned data:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
94 | |
90 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
106 | |
88 | |
64 | |
63 |