regex pro

[steve]

here's the deal...cvs, tick encapsulted data. trying to use regex's to
validate records. here's an example row:

'AD,'BF','13246 5','06/09/2004','','BNSF' ,'A','TYPE','12 78','','BR','29 99',''
,'LX','','01',' 09','1','','',' ','','','','',' ','CUSTOM JOB CODE TEST'

record type is in the 8th column ('1278'). using regex b/c there are a
miriad of types that cause other data w/n the record (or related records) to
be in/valid. i'm having problems getting a match on the generalization of
the first 7 columns:

something like this:

(?=(?:(?<!','). *(?!=',')',')){ 7}(?:'1278(?=', '))

(?=(?:(?<!','). *(?!=',')',')){ 7} represents the first 7 colums.

if someone can help me generalize that patter, i'd appreciate it very much.

tia,

steve

[steve]

good thing i posted the explaination of the problem...lead me right to the
solution. record type is in column 7!!!

(?=(?:(?<!','). *(?!=',')',')){ 8}('((12((7[89])|(8[0-7])|(9[0-468])))|(13((0[
0-3])|(1[16])|(2[0135])))|1612)')

thanks for looking though...if you did.

;^)

"steve" <[e-mail]> wrote in message
news:10******** *****@corp.supe rnews.com...
| here's the deal...cvs, tick encapsulted data. trying to use regex's to
| validate records. here's an example row:
|
|
'AD,'BF','13246 5','06/09/2004','','BNSF' ,'A','TYPE','12 78','','BR','29 99',''
| ,'LX','','01',' 09','1','','',' ','','','','',' ','CUSTOM JOB CODE TEST'
|
| record type is in the 8th column ('1278'). using regex b/c there are a
| miriad of types that cause other data w/n the record (or related records)
to
| be in/valid. i'm having problems getting a match on the generalization of
| the first 7 columns:
|
| something like this:
|
| (?=(?:(?<!','). *(?!=',')',')){ 7}(?:'1278(?=', '))
|
| (?=(?:(?<!','). *(?!=',')',')){ 7} represents the first 7 colums.
|
| if someone can help me generalize that patter, i'd appreciate it very
much.
|
| tia,
|
| steve
|
|

[Ken Tucker [MVP]]

Hi,

Regular expression tester.
http://royo.is-a-geek.com/iserializable/regulator/

Ken
----------------

"steve" <[e-mail]> wrote in message
news:10******** *****@corp.supe rnews.com:

good thing i posted the explaination of the problem...lead me right to the

solution. record type is in column 7!!!
(?=(?:(?<!','). *(?!=',')',')){ 8}('((12((7[89])|(8[0-7])|(9[0-468])))|(13((0[

0-3])|(1[16])|(2[0135])))|1612)')

thanks for looking though...if you did.

;^)

"steve" <HYPERLINK "mailto:[e-mail] "[e-mail]> wrote in message
news:10******** *****@corp.supe rnews.com...
| here's the deal...cvs, tick encapsulted data. trying to use regex's to

| validate records. here's an example row:
|
|

'AD,'BF','13246 5','06/09/2004','','BNSF' ,'A','TYPE','12 78','','BR','29 99',''

| ,'LX','','01',' 09','1','','',' ','','','','',' ','CUSTOM JOB CODE TEST'
|
| record type is in the 8th column ('1278'). using regex b/c there are a

| miriad of types that cause other data w/n the record (or related
records)
to
| be in/valid. i'm having problems getting a match on the generalization
of
| the first 7 columns:
|
| something like this:
|
| (?=(?:(?<!','). *(?!=',')',')){ 7}(?:'1278(?=', '))
|
| (?=(?:(?<!','). *(?!=',')',')){ 7} represents the first 7 colums.
|
| if someone can help me generalize that patter, i'd appreciate it very
much.
|
| tia,
|
| steve
|
|

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.230 / Virus Database: 263.3.0 - Release Date: 6/12/2004

[One Handed Man \( OHM - Terry Burns \)]

Glad u solved it.

I personally hate RegExp, I know often there is little other sensible or
efficient way of doing stuff without it, but I still really really hate it.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
"steve" <[e-mail]> wrote in message
news:10******** *****@corp.supe rnews.com...

good thing i posted the explaination of the problem...lead me right to the
solution. record type is in column 7!!!

(?=(?:(?<!','). *(?!=',')',')){ 8}('((12((7[89])|(8[0-7])|(9[0-468])))|(13((0[ 0-3])|(1[16])|(2[0135])))|1612)')

thanks for looking though...if you did.

;^)

"steve" <[e-mail]> wrote in message
news:10******** *****@corp.supe rnews.com...
| here's the deal...cvs, tick encapsulted data. trying to use regex's to
| validate records. here's an example row:
|
|
'AD,'BF','13246 5','06/09/2004','','BNSF' ,'A','TYPE','12 78','','BR','29 99','' | ,'LX','','01',' 09','1','','',' ','','','','',' ','CUSTOM JOB CODE TEST'
|
| record type is in the 8th column ('1278'). using regex b/c there are a
| miriad of types that cause other data w/n the record (or related records) to
| be in/valid. i'm having problems getting a match on the generalization of | the first 7 columns:
|
| something like this:
|
| (?=(?:(?<!','). *(?!=',')',')){ 7}(?:'1278(?=', '))
|
| (?=(?:(?<!','). *(?!=',')',')){ 7} represents the first 7 colums.
|
| if someone can help me generalize that patter, i'd appreciate it very
much.
|
| tia,
|
| steve
|
|

[steve]

depends on what you need to use it for. in this instance, it saves my remote
app from having to program for the business rules applied formally on
another, remote server. a generic way for the remote server to tell my
application what a valid set of results should "look like". otherwise, i'd
have fun rebuilding and deploying my app each time new or changed rules
appeared. each "rule" gets a description, whether or not the pattern should
match (exist)...etc. works great...and, all i have to do is collect the
rules.

hate's a strong word...regex is, or s/b, you're best friend when dealing w/
text. there's no tool in my toolbox that i wouldn't give up first b4 a good
regex program.

but, to each their own.
"One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
| Glad u solved it.
|
| I personally hate RegExp, I know often there is little other sensible or
| efficient way of doing stuff without it, but I still really really hate
it.
|
| --
|
| OHM ( Terry Burns )
| . . . One-Handed-Man . . .
|
|
| "steve" <[e-mail]> wrote in message
| news:10******** *****@corp.supe rnews.com...
| > good thing i posted the explaination of the problem...lead me right to
the
| > solution. record type is in column 7!!!
| >
| >
|
(?=(?:(?<!','). *(?!=',')',')){ 8}('((12((7[89])|(8[0-7])|(9[0-468])))|(13((0[
| > 0-3])|(1[16])|(2[0135])))|1612)')
| >
| > thanks for looking though...if you did.
| >
| > ;^)
| >
| > "steve" <[e-mail]> wrote in message
| > news:10******** *****@corp.supe rnews.com...
| > | here's the deal...cvs, tick encapsulted data. trying to use regex's to
| > | validate records. here's an example row:
| > |
| > |
| >
|
'AD,'BF','13246 5','06/09/2004','','BNSF' ,'A','TYPE','12 78','','BR','29 99',''
| > | ,'LX','','01',' 09','1','','',' ','','','','',' ','CUSTOM JOB CODE TEST'
| > |
| > | record type is in the 8th column ('1278'). using regex b/c there are a
| > | miriad of types that cause other data w/n the record (or related
| records)
| > to
| > | be in/valid. i'm having problems getting a match on the generalization
| of
| > | the first 7 columns:
| > |
| > | something like this:
| > |
| > | (?=(?:(?<!','). *(?!=',')',')){ 7}(?:'1278(?=', '))
| > |
| > | (?=(?:(?<!','). *(?!=',')',')){ 7} represents the first 7 colums.
| > |
| > | if someone can help me generalize that patter, i'd appreciate it very
| > much.
| > |
| > | tia,
| > |
| > | steve
| > |
| > |
| >
| >
|
|

[steve]

thanks ken...read about it in the msdn mag too. i have it and only have a
couple of issues w/ it. i also have a couple of other .net based regex
validators i've found on the net as well. they're all helpful. as is your
response.

thanks again,

steve
"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:u3******** *****@TK2MSFTNG P12.phx.gbl...
| Hi,
|
| Regular expression tester.
| http://royo.is-a-geek.com/iserializable/regulator/
|
| Ken
| ----------------
|
| "steve" <[e-mail]> wrote in message
| news:10******** *****@corp.supe rnews.com:
| > good thing i posted the explaination of the problem...lead me right to
the
| >
| > solution. record type is in column 7!!!
| >
| >
| >
(?=(?:(?<!','). *(?!=',')',')){ 8}('((12((7[89])|(8[0-7])|(9[0-468])))|(13((0[
| >
| > 0-3])|(1[16])|(2[0135])))|1612)')
| >
| > thanks for looking though...if you did.
| >
| > ;^)
| >
| > "steve" <HYPERLINK "mailto:[e-mail] "[e-mail]> wrote in message
| > news:10******** *****@corp.supe rnews.com...
| > | here's the deal...cvs, tick encapsulted data. trying to use regex's to
| >
| > | validate records. here's an example row:
| > |
| > |
| >
| >
'AD,'BF','13246 5','06/09/2004','','BNSF' ,'A','TYPE','12 78','','BR','29 99',''
| >
| > | ,'LX','','01',' 09','1','','',' ','','','','',' ','CUSTOM JOB CODE TEST'
| > |
| > | record type is in the 8th column ('1278'). using regex b/c there are a
| >
| > | miriad of types that cause other data w/n the record (or related
| > records)
| > to
| > | be in/valid. i'm having problems getting a match on the generalization
| > of
| > | the first 7 columns:
| > |
| > | something like this:
| > |
| > | (?=(?:(?<!','). *(?!=',')',')){ 7}(?:'1278(?=', '))
| > |
| > | (?=(?:(?<!','). *(?!=',')',')){ 7} represents the first 7 colums.
| > |
| > | if someone can help me generalize that patter, i'd appreciate it very
| > much.
| > |
| > | tia,
| > |
| > | steve
| > |
| > |
| >
|
| --
| Outgoing mail is certified Virus Free.
| Checked by AVG Anti-Virus (http://www.grisoft.com).
| Version: 7.0.230 / Virus Database: 263.3.0 - Release Date: 6/12/2004
|
|

[One Handed Man \( OHM - Terry Burns \)]

Well, I know its versitile, I accept that, its just that is seems so, so
'Unixy' like

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
"steve" <[e-mail]> wrote in message
news:10******** *****@corp.supe rnews.com...

depends on what you need to use it for. in this instance, it saves my remote app from having to program for the business rules applied formally on
another, remote server. a generic way for the remote server to tell my
application what a valid set of results should "look like". otherwise, i'd
have fun rebuilding and deploying my app each time new or changed rules
appeared. each "rule" gets a description, whether or not the pattern should match (exist)...etc. works great...and, all i have to do is collect the
rules.

hate's a strong word...regex is, or s/b, you're best friend when dealing w/ text. there's no tool in my toolbox that i wouldn't give up first b4 a good regex program.

but, to each their own.
"One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> wrote in message news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
| Glad u solved it.
|
| I personally hate RegExp, I know often there is little other sensible or
| efficient way of doing stuff without it, but I still really really hate
it.
|
| --
|
| OHM ( Terry Burns )
| . . . One-Handed-Man . . .
|
|
| "steve" <[e-mail]> wrote in message
| news:10******** *****@corp.supe rnews.com...
| > good thing i posted the explaination of the problem...lead me right to
the
| > solution. record type is in column 7!!!
| >
| >
|
(?=(?:(?<!','). *(?!=',')',')){ 8}('((12((7[89])|(8[0-7])|(9[0-468])))|(13((0[ | > 0-3])|(1[16])|(2[0135])))|1612)')
| >
| > thanks for looking though...if you did.
| >
| > ;^)
| >
| > "steve" <[e-mail]> wrote in message
| > news:10******** *****@corp.supe rnews.com...
| > | here's the deal...cvs, tick encapsulted data. trying to use regex's to | > | validate records. here's an example row:
| > |
| > |
| >
|
'AD,'BF','13246 5','06/09/2004','','BNSF' ,'A','TYPE','12 78','','BR','29 99','' | > | ,'LX','','01',' 09','1','','',' ','','','','',' ','CUSTOM JOB CODE TEST' | > |
| > | record type is in the 8th column ('1278'). using regex b/c there are a | > | miriad of types that cause other data w/n the record (or related
| records)
| > to
| > | be in/valid. i'm having problems getting a match on the generalization | of
| > | the first 7 columns:
| > |
| > | something like this:
| > |
| > | (?=(?:(?<!','). *(?!=',')',')){ 7}(?:'1278(?=', '))
| > |
| > | (?=(?:(?<!','). *(?!=',')',')){ 7} represents the first 7 colums.
| > |
| > | if someone can help me generalize that patter, i'd appreciate it very | > much.
| > |
| > | tia,
| > |
| > | steve
| > |
| > |
| >
| >
|
|

[Cor Ligthert]

Hi Terry,

I have again exactly the same idea about it as you, I call it scripting
like.

Cor

[steve]

it has nothing to do w/ unix. even vb.not.net and vb.net have a "like"
statement. consider a regex to be like "like" on acid. it also has nothing
to do with scripting. it is simply the best way to recognize/find patterns
w/n text w/o having to know exactly what the pattern is or what the text to
be search is before hand.

whether or not it is "unixy" or "scriptish" , why start discarding
options/tools based on something other than performance, flexibility, or
cost? that's dangerous programming in a project manager's mind.
"Cor Ligthert" <no**********@p lanet.nl> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
| Hi Terry,
|
| I have again exactly the same idea about it as you, I call it scripting
| like.
|
| Cor
|
|

[One Handed Man \( OHM - Terry Burns \)]

I dont discard it. I simply dont like it, everytime I look at a complex
regExp, it reminds me of the old days where people used to cram code in so
tight because of memory constraints that it was unreadable, or of die hard C
programmers who like to write code which is impossible to undersrtand.

Thats my point. If you dont agree with me, then thats fine.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
"steve" <[e-mail]> wrote in message
news:10******** *****@corp.supe rnews.com...

it has nothing to do w/ unix. even vb.not.net and vb.net have a "like"
statement. consider a regex to be like "like" on acid. it also has nothing
to do with scripting. it is simply the best way to recognize/find patterns
w/n text w/o having to know exactly what the pattern is or what the text to be search is before hand.

whether or not it is "unixy" or "scriptish" , why start discarding
options/tools based on something other than performance, flexibility, or
cost? that's dangerous programming in a project manager's mind.
"Cor Ligthert" <no**********@p lanet.nl> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
| Hi Terry,
|
| I have again exactly the same idea about it as you, I call it scripting
| like.
|
| Cor
|
|