Forum Discussion
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...
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.
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.