| 00:00.23 | Jacob_Kerr | Man i am going to spend all day on trying to figure out how to remove everything in () if there's any nonumerical characters.. |
| 00:01.11 | thebigdog | did you get it figured out? |
| 00:01.46 | Jacob_Kerr | no. |
| 00:02.05 | thebigdog | ok explain again what you are wanting to do |
| 00:02.07 | Jacob_Kerr | and I have a crazy deadline and there's not other way because I have to parse like 300,000 results.. |
| 00:02.44 | Jacob_Kerr | I need to remove everything in () including the () if there's any non numerical characters in the () |
| 00:02.51 | Jacob_Kerr | Add Footrest (adds 10 inches to length of table) |
| 00:03.13 | Jacob_Kerr | so everything in () in the string above should be gone. |
| 00:03.21 | Jacob_Kerr | including the () LOL |
| 00:03.29 | thebigdog | ([\(][\w\d\s]*)(\)) |
| 00:03.47 | mindjuju | dang thebigdog, that was fast |
| 00:04.06 | mindjuju | i was just pulling out my regex cheat sheat to look for the appropriate shortkeys and you had it |
| 00:04.22 | thebigdog | you mgiht have to add some additition ones |
| 00:04.23 | Jacob_Kerr | genius! |
| 00:04.27 | thebigdog | for all non numerical |
| 00:04.35 | Jacob_Kerr | thanx man. |
| 00:05.50 | thebigdog | let me clean it up some though |
| 00:06.16 | Jacob_Kerr | dang according to Kodos there's a match with Add Footrest (09980043) |
| 00:06.27 | Jacob_Kerr | that contains only numbers. |
| 00:06.30 | thebigdog | ([\(][\w\d\s]*[\)]) |
| 00:06.53 | thebigdog | take \d out |
| 00:06.56 | Jacob_Kerr | now can I exclude numbers from that? |
| 00:06.57 | Jacob_Kerr | k |
| 00:07.11 | Jacob_Kerr | still a match :( |
| 00:07.16 | Jacob_Kerr | ([\(][\w\s]*[\)]) |
| 00:07.23 | Jacob_Kerr | shows a match for Add Footrest (09980043) |
| 00:07.30 | thebigdog | k one sec |
| 00:07.46 | mindjuju | yeah cause the \w is alphanumeric |
| 00:07.51 | Jacob_Kerr | dang.. |
| 00:08.00 | mindjuju | you prolly need \D |
| 00:08.06 | thebigdog | tell me the rule again |
| 00:08.12 | mindjuju | all non numeric |
| 00:08.23 | thebigdog | oh ok |
| 00:08.28 | thebigdog | i was thinking numerical |
| 00:08.49 | mindjuju | yeah, if strictly numeric, leave alone, but if not all numeric remove all |
| 00:09.05 | Jacob_Kerr | yeah if it has any non numerical then match |
| 00:09.08 | Jacob_Kerr | otherwise no match |
| 00:09.50 | thebigdog | k |
| 00:10.19 | Jacob_Kerr | thanx a ton :) |
| 00:10.49 | thebigdog | will you ever have 2 sets on a line |
| 00:11.13 | Jacob_Kerr | no I do not think so |
| 00:11.44 | timinator | have a good weekend guys |
| 00:12.17 | thebigdog | you will need to add all the stuff in between |
| 00:13.00 | Jacob_Kerr | hmm.. |
| 00:13.14 | thebigdog | ([\(][a-zA-Z.?]*[\)]) |
| 00:14.03 | Jacob_Kerr | if Add foot (aa) match if Add foot (aa ) there |
| 00:14.06 | Jacob_Kerr | s no match |
| 00:14.14 | Jacob_Kerr | the space alone throws it off hmm. |
| 00:14.33 | thebigdog | ([\(][^0-9]*[\)]) |
| 00:14.40 | thebigdog | ok i see from above now |
| 00:15.19 | Jacob_Kerr | man there's a match for Add foot (ssde) but not Add foot (ssde 89) |
| 00:15.20 | thebigdog | ([\(][^0-9]*[\)]) |
| 00:16.23 | Jacob_Kerr | See this is why I have been going crazy insane with this thing. That matches Add foot (ssde) but if I was to have Add foot (ssde 98) no match |
| 00:17.53 | thebigdog | for that last one ot match you need [a-zA-Z0-9\w] |
| 00:18.14 | Jacob_Kerr | YEAH!!! |
| 00:18.22 | Jacob_Kerr | Perfect man you're a life saver.. |
| 00:18.29 | thebigdog | but that will not work though |
| 00:19.01 | Jacob_Kerr | crap I got all excited for nothing it does not work with the () |
| 00:19.18 | Jacob_Kerr | I will have to build a function that strips everything in the () and does that to it.. |
| 00:19.22 | Jacob_Kerr | hu? |
| 00:19.35 | Jacob_Kerr | then rebuilds the strings etc. etc. |
| 00:20.28 | thebigdog | i would search for things you dont need |
| 00:21.06 | Jacob_Kerr | yeah I just want a string like Add foot (09897) and never anything else in the () |
| 00:21.20 | Jacob_Kerr | yeah. |
| 00:21.22 | thebigdog | then search for that |
| 00:21.29 | thebigdog | if you dont get a hit then remove it |
| 00:22.02 | thebigdog | ([\(][0-9]*[\)]) |
| 00:22.15 | Jacob_Kerr | k. |
| 00:22.17 | thebigdog | if you dont get match, then remove it |
| 00:22.32 | Jacob_Kerr | good idea.. |
| 00:22.33 | thebigdog | have another regex to find the next one |
| 00:22.45 | Jacob_Kerr | Yeah that would work great thanx man.. |
| 00:22.50 | thebigdog | np night |
| 00:22.54 | Jacob_Kerr | good night.. |
| 00:34.56 | Jacob_Kerr | what's the best way to do this query? SELECT group_id, option_id FROM options WHERE part_number = '$item_id' and group_name LIKE '%$option_name%' and option_name LIKE '%$item_option_value%' |
| 01:08.48 | Utah_Dave | laters |
| 01:08.50 | *** part/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net) |
| 01:12.31 | mindjuju | Irony - i spend most of the day exhaust and not feeling like coding only to hit 6p and feel like tearing it up! |
| 01:28.37 | PoeticIntensity | have a great weekend, ya'll? |
| 01:28.38 | PoeticIntensity | !! |
| 01:28.41 | mindjuju | cya |
| 01:36.14 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 01:36.14 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 01:44.27 | mindjuju | sup beandog |
| 01:44.51 | beandog | mindjuju: hola |
| 01:44.58 | beandog | was just watching some good ol Without a Trace on dvd |
| 01:45.06 | beandog | I loves taht show |
| 01:45.51 | mindjuju | i've heard good thing about that series |
| 01:46.04 | beandog | unfrotunately only the first 2 seasons are on dvd |
| 01:46.06 | beandog | Im running out! |
| 01:47.22 | beandog | what are you doing |
| 01:47.41 | mindjuju | listening to GnR - Paradise City and coding |
| 01:47.49 | mindjuju | i had a bad day today, didn't feel like doing much |
| 01:47.50 | beandog | youre still at work? |
| 01:47.52 | beandog | you crazy fool! |
| 01:48.00 | beandog | what happened? |
| 01:48.02 | mindjuju | but hit 6p, and started coding like a maddog |
| 01:48.05 | mindjuju | meh,just tired |
| 01:48.09 | beandog | ah |
| 01:48.12 | beandog | yah |
| 01:48.15 | mindjuju | like you said, just a lazy admin day |
| 01:48.50 | beandog | Im having Samba issues now .... wont let me mount as any user |
| 01:48.54 | beandog | no idea why |
| 01:49.21 | beandog | whatchoo coding |
| 01:50.12 | mindjuju | oh a client portal page, but i've secretly snazzed it up by an order of 10 by putting some hawt web 2.0 stuff in it |
| 01:50.19 | beandog | heh |
| 01:50.20 | beandog | rawk |
| 01:50.24 | mindjuju | if i don't get made present of the company from this project, i don't know what i'll do |
| 01:50.29 | mindjuju | :) |
| 01:52.11 | beandog | :) |
| 01:52.19 | beandog | 2.0 stuff is put-em-over-the-topper |
| 01:52.19 | mindjuju | is it snowing over there? |
| 01:52.22 | beandog | no |
| 01:52.26 | beandog | its been raining all the ding dong day |
| 01:52.36 | mindjuju | where you at? |
| 01:52.54 | beandog | salt lake |
| 01:53.19 | mindjuju | oh curious, i thought it was snowing in the SLC and not south... that's what i get for not looking at weather.com |
| 01:54.01 | beandog | no |
| 01:54.05 | beandog | it hasnt snowed up here in a few days |
| 01:54.13 | beandog | its wet, but thats it. |
| 01:55.59 | *** join/#uphpu jnbek (n=jnbek@72.8.114.148) |
| 02:13.55 | *** join/#uphpu mgeary (n=mgeary@72.8.120.115) |
| 02:13.55 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 02:14.03 | *** part/#uphpu mgeary (n=mgeary@72.8.120.115) |
| 02:14.06 | *** join/#uphpu mgeary (n=mgeary@72.8.120.115) |
| 02:14.06 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 02:14.28 | mgeary | ~ping herlo |
| 02:14.29 | jbot | pong herlo |
| 02:22.28 | *** part/#uphpu mgeary (n=mgeary@72.8.120.115) |
| 02:36.01 | *** join/#uphpu influx^^ (i=influx@67.137.218.51) |
| 02:36.01 | *** mode/#UPHPU [+v influx^^] by ChanServ |
| 03:30.12 | *** join/#uphpu josephscott (n=josephsc@63-226-101-77.slkc.qwest.net) |
| 04:01.41 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 04:01.41 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 04:38.33 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 04:38.33 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 15:19.23 | *** join/#uphpu SunSparc (n=sparky@66.7.114.125) |
| 16:07.29 | *** join/#uphpu undertak1ngyou (n=will@71-219-88-205.slkc.qwest.net) |