Select number and text in to new column

[MJHHBis]

Hi

I have a column that contains a lot of info. I need the zip code from that column and want to place it in a new column. The zip code is not always in the same place. See the example below:

A1 AMBU 18172 Schaduwrijk 3297SC Puttershoek PUTTHK bon 27397

A2 4645RT : Hazeduinen 1e Verdelingsweg Hazeduinen Putte 17286

I tried with Text.Selectbut but i can't figure out how to select a number with text.

Thanks for the help!

[slanka]

If the Zipcode is in the same format, 6 chars including first 4 as Digits and next 2 Characters (example: 1111AB), you can achieve in Query Editor using AddColumns -> "Column From Examples" -> Type your intended text as sample (query will pick the same from next).

Try and check it out.

---

@MJHHBis wrote:

Hi

I have a column that contains a lot of info. I need the zip code from that column and want to place it in a new column. The zip code is not always in the same place. See the example below:

A1 AMBU 18172 Schaduwrijk 3297SC Puttershoek PUTTHK bon 27397

A2 4645RT : Hazeduinen 1e Verdelingsweg Hazeduinen Putte 17286

I tried with Text.Selectbut but i can't figure out how to select a number with text.

Thanks for the help!

---

---

@MJHHBis wrote:

Hi

I have a column that contains a lot of info. I need the zip code from that column and want to place it in a new column. The zip code is not always in the same place. See the example below:

A1 AMBU 18172 Schaduwrijk 3297SC Puttershoek PUTTHK bon 27397

A2 4645RT : Hazeduinen 1e Verdelingsweg Hazeduinen Putte 17286

I tried with Text.Selectbut but i can't figure out how to select a number with text.

Thanks for the help!

---

[Anonymous]

Where is this data coming from? More importantly, does the source data have headers?  If so, then can use power query to transform this raw data into something useful. If there are no headers, I'm not so sure since I cannot really think of anything that sets the zip code apart....