tag:blogger.com,1999:blog-4291664034828038593.post4601918781264595785..comments2024-03-10T04:57:49.447+00:00Comments on Strictly Software: SQL Regular Expressions - Extracting Income From PayPal IPN DataRob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4291664034828038593.post-19883868621373198442019-01-23T18:58:35.716+00:002019-01-23T18:58:35.716+00:00Yes, really I should normalise the Payments table ...Yes, really I should normalise the Payments table a bit more and have a column called Amount but in reality there was no need for it until recently when I needed to write a report for totaling up amounts from the table for certain promo codes. If I had needed an amount column when first creating the code and site I would have done so.Rob Reidhttps://www.blogger.com/profile/05430306492065347012noreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-7067107804678344912019-01-23T18:56:31.928+00:002019-01-23T18:56:31.928+00:00Paul, yes I should change it around to be Microsof...Paul, yes I should change it around to be Microsoft compliant really but the params of the UDF have to match those of the DLL Class and I have lost that code unfortunately. I could re-do it obviously but I think at the time I was working a lot on PHP and they have functions with params all over the place back n forth so I think that's why they are in that orderRob Reidhttps://www.blogger.com/profile/05430306492065347012noreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-76733765505567705792019-01-23T17:35:53.792+00:002019-01-23T17:35:53.792+00:00Love it, I have always had issues trying to extrac...Love it, I have always had issues trying to extract parameters out of IPN strings from PayPal and usually use code to split on the = like a querystring and make an array before accessing a param by name to get the second array part which is the value. However this is long winded and if you are not storing the actual payment amount as a seperate column value in the Payments table then I suppose Dave Elliotnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-71323196278444820292019-01-23T17:32:32.364+00:002019-01-23T17:32:32.364+00:00Great article, your regular expression skills are ...Great article, your regular expression skills are spot on. I would change the parameters in the UDF though so that they match those in C#, VB, ASP etc as you usually get the string input parameter first, then the expression then replacement value or grouping e.g "$1$3" etc.Paul Bowersnoreply@blogger.com