Forum Discussion

banksbc's avatar
banksbc
New Member
2 years ago

Capture Number after finding varying prefix

I am very new to Power Query so forgive my ignorance.  I am trying to capture building numbers in its own column out of trouble ticket descriptions.  The issue is that customers put building number i...
Need Help
dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi banksbc ,

try this:

 

Result

let
    Source = #table(null, {{"B.1550"},{"BLDG 1550"}, {"B1550"}}),
    Ad_ExtractNumbers = Table.AddColumn(Source, "Extract Numbers", each Text.Select([Column1], {"0".."9"}), type text)
in
    Ad_ExtractNumbers
banksbc's avatar
banksbc
New Member
2 years ago

Thank you Dufoq3,
The issue is the building number varies as shown in the sample descriptions.  Those were listed to show what types of data I am having to parse through.

  • dufoq3's avatar
    dufoq3
    Community Champion
    2 years ago

    Hi, my will extract all numbers from that description. If you want to extrat something different, provide expected result based on sample data please. Think in advance which all possible situations you could face and update sample data if needed.