Extract text from the a String / Remove No.'s from the Text

[Anonymous]

Hello Everyone,

I am trying to get the Street without No. from the column Street with No.

Anyone could please help.

Dataset looks like below:

Street with No.                                                                    Street Without No.

Erlanger Strasee 10	Erlanger Strasee
EylauerStr. 11	EylauerStr.
BadencheStr. 111	BadencheStr.
Noway Street 11-15	Noway Street
ABC Strasse	ABC Strasse

[petrovnikitamai · Accepted solution]

try in query editor add new column 

= Table.AddColumn(#"Changed Type", "Street Without No.", each Text.Select([Street with No.],{"a".."z","A".."Z","."," "}))

or

= Table.AddColumn(#"Changed Type", "Street Without No.", each Text.Remove([Street with No.],{"0".."9","-"}))

[Anonymous]

Hi @petrovnikitamai , Thanks. It worked. I was trying with {"a".."z"},{"A".."Z"} and was getting error. Got it though. Thanks again.