Forum Discussion

JohnHarker's avatar
JohnHarker
New Member
2 years ago

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...
Need Help
  • AlienSx's avatar
    AlienSx
    Icon for Super User rankSuper User
    2 years ago

    thanks,  ! To be honest, I've made a mistake - there must be 12 (not 11) in Text.Range(txt, find_position + 1, 11)

     

    PwerQueryKees

    • PwerQueryKees's avatar
      PwerQueryKees
      Icon for Super User rankSuper User
      2 years ago

      Hilarious! Still a very creative and generic way to tackle OP's problem....