Forum Discussion
Clean address column
Hey all,
Is there a way to clean the customer address field? i have imported a CSV file. There are different ways the customer writes their addresses, here are some examples:
i want the address to be shown as: Streetname 99
Hi Robin96 ,
The first bit would be to try and standardise the incoming address from the customer if possible. You can use a conditional column in powerquery to work through your column and clean it into a new column but I don't know how intensive that might be in terms of the data etc based on your example.
Hope this helps.
Did I help you today? Please accept my solution and hit the Kudos button.
2 Replies
Hi Robin96 ,
The first bit would be to try and standardise the incoming address from the customer if possible. You can use a conditional column in powerquery to work through your column and clean it into a new column but I don't know how intensive that might be in terms of the data etc based on your example.
Hope this helps.
Did I help you today? Please accept my solution and hit the Kudos button.
