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
show some example and what result you want
Here are 3 example fields & expected results:
Q3 2022 P&T SI&O MRT ABZ0001235 Monitoring Run Tooling CH --> ABZ0001235
CBR0002134 for PT Development Services 2022 (Q4) --> CBR0002134
4 PCS MIDDLEWARE 2022-Q3 --> ""
As you can see, the productID always begins with 3 letters & followed by 7 numbers, which can be anywhere within the string. Sometimes the string doesn't contain any productID, then the result should be empty.