Forum Discussion
adamlang
Helper III
Helper IIICleaning UK Postcode data
Hi there, Does anyone have any experience cleaning UK postcodes is Power BI, Power Query, DAX? Maybe there's some standard code that could be used? I have a list of client postcodes that need...
to remove the double space in the middle - Using Power Query. Right-click, Replace Values. Enter 2 spaces, replace with 1 space.
--
Maybe you can solve all problems by splitting column by 3 characters on right. Clean and trim all data. Then combine columns with a space in between. These are all done with the interface
HotChilli
Community Champion
Community Championto remove the double space in the middle - Using Power Query. Right-click, Replace Values. Enter 2 spaces, replace with 1 space.
--
Maybe you can solve all problems by splitting column by 3 characters on right. Clean and trim all data. Then combine columns with a space in between. These are all done with the interface
