Forum Discussion
Extract postcode from Text
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
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
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
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
Hi VijayP ,
Thank you for the solution, it helped me to extract the postcode from "Full Adress".
The result column is what i hope to extract from the column "Full Adress". So its done Manually.
Thanks in advance,
Sam
I think I coundnt understand your question. can you please rephrase this
Hi VijayP,
This is the data i have:
Full Adress Van de Spiegellaan 99 8956 LZ Leeuwarden Wilhelminakade 125 4576 HA Krimpen aan de Ijssel Spanjestraat 4 1648 IU Harderwijk Plein 31B 8643 PU Roosendaal Stationsstraat 3 Amsterdam And this is the result i want:
Results 8956 LZ 4576 HA 1648 IU 8643 PU No Postcode I hope this is more understandable.