You just need another tilde character in there. (Kidding!)
Can you run through your files line by line, figure out what type of line you're currently on, and then feed individual lines to smaller regexes tailored to the type of line you have? That's likely to be more intelligible/maintainable in the long run, and should obviate your current problem. HTH, -Roy -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of G G Sent: Thursday, August 09, 2007 7:39 PM To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject: [ADVANCED-DOTNET] regex: how to avoid capturing leading empty lines How can one avoid capturing leading empty or blank lines? the data I deal with look like this "will be paid on the dates you specified. xyz supplier [123445797891] amount: $100.52 when: September 07, 2007 reference #: 0415 from: operating account [236424735] abc, Jane'S CHOICE [0089456881545] amount: $487.61 when: September 08, 2007 reference #: 0416 from: finess [0236454514] " regexoptions are: multi-line,explict capture, ignorecase, dotall, ignore pattern white space regex expression used for capturing (?<AcctName>^\w*,{0,1}(\s\w*('s){0,1},{0,1})*)\s\[(?<AcctNbr>\d*)\].{4,8 }amo unt:\s\$(?<Amt>\b[0-9][0-9,]*\.\d\d)\s*when:\s*(?<Dt2Pay>[ADFJMNOS][aceo pu][ bcglnprtvy][ya-v]{0,9}\s\d{1,2},\s\d\d\d\d\b)\s*reference\s*\#\:\s*(?<Re fNbr >\d*)\s*.{2,4}\s*from:\s(?<FromAcctName>\w{1,}(\s\w*)*)\s\[(?<FromAcctNb >r>\d *)\] the exrpession used in Result(strGrps) ${AcctName} ${Amt} ${Dt2Pay} ${RefNbr} PCF ${FromAcctName} ${FromAcctNbr} Result is " xyz supplier 100.52 September 07, 2007 0415 PCF operating account 236424735 abc, PRESIDENT'S CHOICE 487.61 September 08, 2007 0416 PCF finess 0236454514" However desired result are lines with columns tab delimited and without extra leading lines: "xyz supplier 100.52 September 07, 2007 0415 PCF operating account 236424735 abc, PRESIDENT'S CHOICE 487.61 September 08, 2007 0416 PCF finess 0236454514" what do I have to adjust in the regex expresiion? thank you for your time and expertise =================================== This list is hosted by DevelopMentor(r) http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
