Select number combined with 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.Select but i can't figure out how to select a number with text.

Thanks for the help!

[v-shex-msft]

HI @MJHHBis ,

According to your description, these character has random string and not have static positions, I also not found any regular between them.(for search and extract particular string, you need to know its regular first)

I don't think it is possible to use dax formula to extract random string from text.

Regards,

Xiaoxin Sheng