Forum Discussion

ZZZZZZZ37's avatar
ZZZZZZZ37
Frequent Visitor
3 years ago
Solved

Return data from Google search

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,

Need Help
Tips and Tricks
Tutorial Requests
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    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.

     

1 Reply

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    3 years ago

    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.