Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Extract postcode from Text

Hi Everyone,   I have a column where date contains streetname, housenumber, postcode code and city. Is it possible to extract the postcode (4 digits & 2 non-digits) in PowerQuery? Id be happy i...
Need Help
  • VijayP's avatar
    VijayP
    6 years ago

     

    Anonymous 

    I hope this is the answer you would like to have

    you need to open powerquery editor 

    select Addcolumn Tab

    in that use Column From Example and follow the instructions given in this short video

    Video Link

    Regards

    Vijay Perepa

    If  you find this as solution please mark it as solution and share your Kudos

    you can watch my Power BI and Excel Videos at www.youtube.com/perepavijay

     

     

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous Are you trying to extract postcode (4 digits & 2 non-digits) from Results column or Full Address column?

 

If you have a proper structure in the base column, you could use the split column function.

 

checkout this blog- https://www.sharepointsky.com/split-columns-in-power-bi/



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi nandukrishnavs 

Thank you for your reply.

i want to extract the code from full adress, the results column is the result i want to see.

Unfortunately, the data is not proper. Sometimes there is no postcode. It is also possible that the streetname and city contains several words.