CODEWITHSUNDEEP
powerbi
Philip Jensen
Philip Jensen

Reputation: 17

Search in Column Power BI

I have a column in Powerbi with postal code and City in the same cell. I would like to have Zipcode in a column alone.

My problem is that the length of postal code varies from country to country.

Some have 5 characters others have 4 ex. 7400 Herning, 12307 Berlin

The postal code and city are separated with a "space".

Is it possible to have a code that return all characters that returns everything until the first "space"?

Thanks.

Upvotes: 0

Views: 57

Answers (2)

Sia
Sia

Reputation: 536

  1. Split Column by Delimiter

enter image description here

enter image description here

  1. Split Column by Digit to Non-Digit

enter image description here

Upvotes: 0

Ashok Anumula
Ashok Anumula

Reputation: 1515

You can achieve this using Column From Examples in Power Query

enter image description here

enter image description here

Upvotes: 0

Related Questions