Forum Discussion

BalazsNy's avatar
BalazsNy
Helper I
2 years ago
Solved

How to extract text patterns from string value?

Hi all,   I have a database with a various length description column, which contains a product ID somewhere in it (even at the beginning, middle or end of the description). These product IDs follow...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    365.pbix19 KB
Ahmedx's avatar
Ahmedx
Super User
2 years ago

Is this what you are looking for?

364.pbix17 KB
  • BalazsNy's avatar
    BalazsNy
    Helper I
    2 years ago

    Unfortunately, the issue is a bit more complex. You can find my examples replied to your below comment â–¼

    • Ahmedx's avatar
      Ahmedx
      Super User
      2 years ago

      pls try this

      365.pbix19 KB
      • BalazsNy's avatar
        BalazsNy
        Helper I
        2 years ago

        Dear Ahmedx!

        Thank you very much. Your formula brilliantly works 🙂