Anyone Know Regular Expressions?

[Amazinz]

That's true it would. But if the regex is not working as expected .* is most likely the culprit. He's a greedy little bastard.

[StlSluggers]

That's true it would. But if the regex is not working as expected .* is most likely the culprit. He's a greedy little bastard.

Greedy little bastard?

Have you been reading the same book I have?

[Amazinz]

Math humor.

[StlSluggers]

Math humor.

I guess that it's bad that got it.

I wasn't worried about the "greediness," but I'll try it with the preceeding \b just to see what I get.

I'm worried I'm double-counting because I can't verify my totals manually. In fact, my manual calculations pale in comparison to the totals I'm getting in these queries. That would be very bad, but that's a separate issue right now. First, I need to get this to a point where I'm 100% sure that I'm pulling the right crap.

Thanks for the help, A!

[Coppermine]

I know some irregular expression, but I can only say them in an Australian accent

[SaintsOfTheDiamond]

Is there any sort of regulation on what can proceed the CARDID portion? Instead of .* use \w* or build up a set yourself with [a-zA-Z0-9] etc. I'm pretty sure \b isn't what you want though because that would mean only strings beginning with CARDID and having the appropriate number would be matched.

[StlSluggers]

Is there any sort of regulation on what can proceed the CARDID portion? Instead of .* use \w* or build up a set yourself with [a-zA-Z0-9] etc. I'm pretty sure \b isn't what you want though because that would mean only strings beginning with CARDID and having the appropriate number would be matched.

The preceeding stuff is based on questionnaire answers, so it's quite varied.

I did run it with /b at the beginning, and it did not pull any matches.

[SaintsOfTheDiamond]

Is there any sort of regulation on what can proceed the CARDID portion? Instead of .* use \w* or build up a set yourself with [a-zA-Z0-9] etc. I'm pretty sure \b isn't what you want though because that would mean only strings beginning with CARDID and having the appropriate number would be matched.

The preceeding stuff is based on questionnaire answers, so it's quite varied.

That's what I figured. You could still narrow it down to alphanumeric, digits and a handful of special characters (properly escaped of course) couldn't you? Maybe not.

EDIT: That is, of course, if you think .* is causing the problems.

I did run it with /b at the beginning, and it did not pull any matches.

That's because it's \.

[Amazinz]

How is the data you are parsing formatted? For instance, if there are line breaks in the string .* won't match correctly depending on the regex implementation. Could it be something like that?

[StlSluggers]

I did run it with /b at the beginning, and it did not pull any matches.

That's because it's \.

Yeah, yeah... I need to stop thinking of BBCode when I type here.

How is the data you are parsing formatted? For instance, if there are line breaks in the string .* won't match correctly depending on the regex implementation. Could it be something like that?

Here are quite a few examples:

CitiBusiness PremierPassSM Card,BANK--Citibank__CARDID--4
QuickBooks Platinum Plus for Business MasterCard,BANK--MBNA America Bank__CARDID--7
Advanta Platinum BusinessCard,BANK--Advanta__CARDID--14
Harris MasterCard®* BusinessCard®*,BANK--Harris Trust and Savings Bank__CARDID--1
Advanta Platinum BusinessCard,BANK--Advanta__CARDID--9
*CitiBusiness® Card with ThankYouSM Network,BANK--Citibank__CARDID--6
CitiBusiness® Card,BANK--Citibank__CARDID--18
Chase Business Rebate Card,BANK--JP Morgan Chase and Co.__CARDID--11
Standard Federal MasterCard BusinessCard Card,BANK--Standard Federal Bank__CARDID--26
GM,BANK--JP Morgan Chase and Co.__CARDID--15
LaSalle MasterCard BusinessCard Card,BANK--LaSalle Bank__CARDID--25
Continental Business MasterCard from Chase,BANK--JP Morgan Chase and Co.__CARDID--8
Platinum Plus^sm Business Rewards MasterCard,BANK--MBNA America Bank__CARDID--10
<i>Platinum Plus</i>®<i>for Business</i> MasterCard,BANK--MBNA America Bank__CARDID--16
QuickBooks Platinum Plus for Business MasterCard,BANK--MBNA America Bank__CARDID--13
*Citi Professional(SM) Cash Card,BANK--Citibank__CARDID--24

What's giving me fits is that the manual sum of the data is falling short of the sum given by the regex query. I'm much more confident in the manual tally because I can pull the whole string and then parse it myself. Of course, the data stream seems to be corrupted today, so it's not like I'm going to make much progress in the verification realm today.