Forum Discussion
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...
pls try this
Thanks for the tips, but I have already tried to solve with these methods, but couldn't figure out a proper formula, because the position of product ID varies field-by-field & non-digit/digit splitting neither worked because sometimes these description fields also contain quarter-related strings like "Q1".
i understand that you dont have only this pattern ADZ0001234 ? am i right ?
if so,
can you give some examples of how your productid could be ?