Forum Discussion
How to extract text patterns from string value?
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".
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.