in reply to Re: Re: Can I match a range from an array?
in thread Can I match a range from an array?
You have 3 lists then (files). 1 is a list of cell sites in english. Another is a list of cell sites in base10. And finally you have the CDR.
The file your boss gave you comes with the "cryptic" information that looks like a location id (GRN001A) with the NPA-NXX and suffix (310-640-1101) and then the base10 of identifier of the cell site (10011). The hex conversion of 10011 is 271B which will now match up with the call record (where MSTerminating shows the record block). Now, you want to convert the instance of
Cell ID for First Cell: MCC: 310 MNC: 64 LAC: x'44D CI: x'271B
to...
Cell ID for First Cell: MCC: 310 MNC: 64 LAC: x'44D CI: x'GRN001A
And you want to be able to do this in a massive conversion...
Do I have the idea? :)
As for my code, it wasn't going in the right direction. I will still post it if ya want...its nothing big. I would like to check out the script you are talking about that does the sorting on cdr's. That might help me in something I might undertake soon. Let me munch on this one you have brought up....permitted I understand now what you need and time permitting. I am at work right now which of course takes precedence.
----------
- Jim
|
|---|