21 reputation
3
bio website
location
age
visits member for 2 years, 2 months
seen Jul 10 '13 at 11:54

Jan
9
awarded  Commentator
Jan
9
comment Finding multiple coded values in a string, then returning a lookup value for each found code
I think this is pretty close to my best option, especially since I've realized I'm able to split the codes into three categories (Body, Base, Detail). Unfortunately, there's still the issue of code overlap in some instances. I'll chew it over tonight, and see what I can work out from this tomorrow.
Jan
9
comment Finding multiple coded values in a string, then returning a lookup value for each found code
For the set I am working with today, the two most frequent codes are S and BK, but there are around a dozen others that pop up occassionally, and a handful that only show up once. Example codes could be 14440BK and 14440SBK, 8BKSN, and 484BK. The base codes can be anywhere from 1 to 5 digits, and on this set the base codes are almost all numeric (to the point where I can just go through and manually take care of ones that are not). The bulk of tomorrow's codes start with a single letter, and then have a 2-3 digit number, followed by a code that is anywhere from 1-7 alphabetical characters.
Jan
9
comment Finding multiple coded values in a string, then returning a lookup value for each found code
For the set I am working with now, there is some character overlap but it's not significant as long as I look for the longest codes first (for example, S and SN). The second set of codes that I will hopefully be working on tomorrow does have some overlap, though. That set has B as a code, but also BB. It gets a little confusing with those items.
Jan
9
comment Finding multiple coded values in a string, then returning a lookup value for each found code
This unfortunately won't work on all of the items, because the codes can be in all different lengths, and are occasionally in different orders. Also, the plain/parent items can be anywhere from 3-5 characters. That said, when it works, the output here is exactly what I wanted to see. If only there was a way to make it more dynamic.
Jan
9
comment Finding multiple coded values in a string, then returning a lookup value for each found code
This is pretty close to functional, but having to do columns C:F manually, along with having to mess around with the B column each time there's a new main item code (not to mention some of the items don't even come in a plain variation) makes it almost as time consuming as just hand typing each code. However, I'm wondering if there's a way to do the same work of those columns with the find command and something like SMALL(). Any ideas?
Jan
9
asked Finding multiple coded values in a string, then returning a lookup value for each found code
Jul
17
awarded  Editor
Jul
17
revised Counting “0” Stock Values Generated by Pivot Table
Added ideas, noted additional progress
Jul
17
comment Counting “0” Stock Values Generated by Pivot Table
I've created a new question based around doing the same thing through DB Querying in either Access or SQL Server over at StackOverflow. Thanks for all your help so far, folks.
Jul
17
comment Counting “0” Stock Values Generated by Pivot Table
I've managed to recreate the running totals using a SQL query. Oddly, I can't figure out how to move that same query over to access to work with a smaller set of static test data. I'm wondering if I should relocate this post elsewhere, and try to tackle things with one of those other methods?
Jul
17
comment Counting “0” Stock Values Generated by Pivot Table
I have only novice experience with SQL systems, and my formal training is with oracle. Even then, it's been years. Are there any resources you can point me toward for this kind of work?
Jul
16
comment Counting “0” Stock Values Generated by Pivot Table
:( I'm not even sure what I'd do with this data in access; I haven't used the program in ages. But getting the missing dates in is not as big of a problem as the other two pieces: Having a dynamic count of the zeroes in the running totals, and generating consecutive days out of stock in the source data. Would those really be any easier in access?
Jul
16
comment Counting “0” Stock Values Generated by Pivot Table
Excel recognizes the values/format as date values, if that helps
Jul
16
awarded  Student
Jul
16
asked Counting “0” Stock Values Generated by Pivot Table