1 of 1 people found this helpful
Best resource in the world for regex: RegExr: Learn, Build, & Test RegEx you can paste in your search text and tweak your expression until it does what you want. I also like to throw fringe cases in there to make sure my expressions don't break.
That being said I think I came up with working expressions for your case:
Output 1 (your sample output appears to be incorrect): REGEXP_MATCH([CA],'(CA_2A\-2A\-4A[^\)]*(?=BCS0)BCS0(?!\())')
Output 2: REGEXP_MATCH([CA],'(CA_2A\-4A[^\)]*(?=BCS1)BCS1(?!\())')
Hope this helps!
You can also paste regular expressions in http://regexr.com and hover over the parts and it will explain the expression
Thanks Jay. he link is awesome to test the code!!!!
Glad to help! Please mark the answer as correct if it solved your issue.