Hi,
My data set contains data that falls broadly into 3 categories:
1) Data with an AAAA number - e.g. ABC21864 - 123 - XYZ - AAAA-5VF4Z0 - ABCDEF - FFF+ZZZ - TTFN + FDA
2) Data with parenthesis - e.g. abcd\ABC123456 - XYZ - 1234-12-1 ABC DEF (abcdef)
3) Data without either of the above - e.g. ABC1904 - 4MGB - BSOD - ABCDEFGHIJKLMNOP - ABCDEFGH Carrara - TTFN + FDA
I am trying to parse these using the RegEx tool as below:
1) Parse up to the end of AAAA number
2) Parse up to and excluding the opening parenthesis
3) Parse the first 42 characters from left
I am using the RegEx expression:
(ABC.*?AAAA-\w+|ABC.+?\(|ABC.{42})
When used, the middle expression parses data up to and including the first parenthesis and doesn't drop the parenthesis.
Please advise how to parse up to (but exclude) the first parenthesis.
Thank you
