I am working on an Associative array (Hash) UDF. See Pseudo Hash UDFs (Hash & MHash) - RFC for more details. It will let you manage two arrays pretty easily.
You could load all mappings for all groups into the Hash using the group name as the key. The data could be exactly what you currently have.
Even if you do not like the above idea, all you have to do is split the value:
$map = split($CCentre_Drive[1]," ")
use $Map[0] $Map[1]
this is assuming that you do not use any spaces in the names of your servers or shares.
Or if you like the above idea:
$map = split(MHash("Mappings","CCOpsX"), " ")
use $Map[0] $Map[1]
If you use spaces in server or share names, then add a special character to the data as in "X:~\\server\share" and split on the "~".
{edit}
Or maybe this is more accurate.
for each $drive in HashKeys("CCOpsX")
USE $drive MHash("CCOpsX",$drive) ;where the value returned is "\\servername\share"
next
HashKeys UDF still needs to be written.
[ 25 June 2002, 14:38: Message edited by: Howard Bullock ]
