Forum Discussion

sv11's avatar
sv11
Helper I
7 years ago
Solved

Data Wrangling

Hi,

 

I have a column with phone number data with multiple formats as shown below:

 

 

I would like to clean and transform this data into a single format.

 

Any suggestions on how can I achieve it in power query?

 

Appreceate the help.

Thanks

Need Help
  • tarunsingla's avatar
    tarunsingla
    7 years ago

    Hi sv11, Did my response help? Could you please accept the response as a solution if it did.

3 Replies

  • tarunsingla's avatar
    tarunsingla
    Solution Sage
    7 years ago

    Try this:

     

    Add a custom column to select only the digits from the string column, like this:

    Text.Select([Column1], {"0".."9"})

     

    Then assuming phone numbers will be all 10 digit long, transform the newly added custom column to extract the first 10 characters.

     

     

    Regards,

    Tarun

    Did I answer your question? Mark my post as a solution!

    • tarunsingla's avatar
      tarunsingla
      Solution Sage
      7 years ago

      Hi sv11, Did my response help? Could you please accept the response as a solution if it did.