Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

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.                                ...
Need Help
Show and Tell
Tips and Tricks
  • petrovnikitamai's avatar
    petrovnikitamai
    7 years ago

    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","-"}))

     

     

petrovnikitamai's avatar
petrovnikitamai
Resolver V
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

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