Forum Discussion
Solved
Cleaning 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
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
