Forum Discussion
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 ...
Hi sv11, Did my response help? Could you please accept the response as a solution if it did.
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!
Hi sv11, Did my response help? Could you please accept the response as a solution if it did.