-
1. Re: REGEXP_MATCH help !
Jay Morehart Jul 10, 2017 3:47 PM (in response to Kenneth Nunez)1 of 1 people found this helpfulBest 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!
EDIT:
You can also paste regular expressions in http://regexr.com and hover over the parts and it will explain the expression
-
2. Re: REGEXP_MATCH help !
Kenneth Nunez Jul 11, 2017 6:31 AM (in response to Jay Morehart)Thanks Jay. he link is awesome to test the code!!!!
-
3. Re: REGEXP_MATCH help !
Jay Morehart Jul 11, 2017 6:43 AM (in response to Kenneth Nunez)Glad to help! Please mark the answer as correct if it solved your issue.
Happy Tableauing!