Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
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...
Need Help
  • HotChilli's avatar
    HotChilli
    3 years ago

    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's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
3 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HotChilli 

    Thanks! The Replace values worked a treat. Just like find and replace in excel.

     

    I'll see if I can get other other solution to work over the next day or so.

     

    Thanks.