I am trying to use RegExpression to extract the text
AB1975.Jan XXX
CD2000.Jan XXX
But I end up extracting till
BA2018.May XXXXXX
How do I amend the Reg to stop the extraction before Auto? Thank you
AB1975.Jan XXX
CD2000.Jan XXX
Auto
AZ2018.Jun -XXX
BA2018.May XXXXXX
My RegExpression:
(System.Text.RegularExpressions.Regex.Match(Text1,“(?!Auto.)\n\s{3}[A-Z]{2}\d{4}.([A-Za-z]{3}|\d{1})\s{3,}(.|\n)(?<=\s{3}[A-Z]{2}\d{4}.([A-Za-z]{3}|\d{1})\s{3,}).+((?=\n.*--------------------------------------------------------------------)|(?=\n))”).Value)