Searching text for starts with QC ends with # and nothing else

crichter14 — Sat, 16 Nov 2024 18:01:24 GMT

I'm having a really hard time putting this together. I have a comment 'text' field. Which means the substring could be anywhere in the field (beginning, middle, end) or it could be a single 'word' or textbetween isn't working. Essentially what I'd like to pull is ANY portion of the substring, that starts with the letters 'QC' and ends with a number. I don't want QC by itself, or QC- or QC/ or QC with a space.

Example: include/exclude result

'QC' - exclude no number -

'QCYE2020' -include has QC and # at end QCYE2020

'QCSEP2020' -include has QC and # at end QCSEP2020

'The data had QC and others' -exclude no number -

The data has QC/Example -exclude no number -

'The data ends in QC' -exclude no number -

'The data has QCOCT2020 in the middle' -include has QC and # at end QCOCT2020

'or the end QC5' -include has QC and # at end QC5

'QC4 at the beginning' -include has QC and # at end QC4

Ideas, suggestions, possible topic post links I've not found yet?

Thank you so much!

topic Searching text for starts with QC ends with # and nothing else in App Development

Searching text for starts with QC ends with # and nothing else