Forum Discussion
Extracting a sequence in Power Query
I have a long column of data where I need to extract a specific sequence. I am looking for the format ####-##A####. The problem is there is no pattern as to where this sequence apprears in the cell a...
Awesome AlienSx ...
thanks, ! To be honest, I've made a mistake - there must be 12 (not 11) in
Text.Range(txt, find_position + 1, 11)Hilarious! Still a very creative and generic way to tackle OP's problem....
