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

Question

Hello Everyone,&nbsp;I am trying to get the Street without No. from the column Street with No.Anyone could please help.Dataset looks like below:&nbsp;Street with No.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Street Without No.Erlanger Strasee 10Erlanger StraseeEylauerStr. 11EylauerStr.BadencheStr. 111BadencheStr.Noway Street 11-15Noway StreetABC StrasseABC Strasse

petrovnikitamai · Accepted Answer

try in query editor add new column&nbsp;= Table.AddColumn(#"Changed Type", "Street Without No.", each Text.Select([Street with No.],{"a".."z","A".."Z","."," "}))or&nbsp;= Table.AddColumn(#"Changed Type", "Street Without No.", each Text.Remove([Street with No.],{"0".."9","-"}))&nbsp;&nbsp;

Forum Discussion

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

2 Replies

Related content

Extract part of text string

Remove string and parenthesis

Extract Date from String

DAX: extracting string using delimiter

Extract part of string before specific character

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