|Feb 13, 2012, 07:29 PM||#1|
A job for pointers?
Have just started to look at this but always well come help.
I need to match a pair of numbers in columns 3 and 4, so that I can get the numbers in cols 1 and 2.
Last edited by farmerdoug; Feb 13, 2012 at 07:39 PM.
|Feb 13, 2012, 08:30 PM||#2|
|Feb 13, 2012, 09:16 PM||#5|
Combine columns 1 & 2 into a single number. Do the same for columns 3 & 4. Then lookup the number c3:c4 and get the number c1:c2. Then split c1:c2 back into two separate numbers.
For example, if the value in column 2 (call it c2) is in the range [0-9999], then the combined number c1:c2 is simply c1 * 10000 + c2. Assuming both c1 and c2 are non-negative integers.
You get c1 by dividing c1:c2 by 10000 (because integer division truncates). You get c2 from c1:c2 mod 10000.
Same principle applies to numbers in column 3 (c3) and column 4 (c4). Combine, store, lookup, uncombine.
Oh, and make sure you choose a type for the combined numbers that's big enough to hold the full range. Since you haven't specified the range, I'm not going to guess.
A suitable structure for mapping c3:c4 back to c1:c2 depends on how many times you expect to be doing the lookup, how fast it needs to happen, and how many total items there are. A solution could be a simple array, a sparse array, a hashtable, a tree, etc. It could be entirely in RAM, or partly in RAM and partly on disk. It depends entirely on whether you're talking about thousands, millions, or billions of items, and minutes, seconds, or milliseconds of lookup time.
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|Jobs job||Confuzzzed||Community Discussion||0||Oct 6, 2011 10:24 AM|
|Steve Jobs for President [VIDEO]||Consultant||Community Discussion||1||Apr 1, 2011 09:59 PM|
|Beards and job interviews, still a faux pas?||foidulus||Community Discussion||32||Feb 27, 2011 12:20 PM|
|Any Ideas for a job for a 17 year old?||papadopolis1024||Community Discussion||27||Dec 7, 2008 07:38 AM|
All times are GMT -5. The time now is 05:14 PM.