Finding a Variable with a Script

[Mushi]

I have a table of names of software, created to keep and inventory on what my company is running along with the licences we have. I recently discovered that i can use a server application to get a list of all applications currently installed, and how many. The problem is that name exported from the server are often more detailed (ie Adobe Acrobat 5.0 (v1.000.600)) and do not match up with already have in my DB.

I have imported the server data to a new table with 'name' and 'number' fields, but i want to share this information with my SoftwareInven table. Since the names don't match up i am having trouble. I tried to create a script that could find server data based on the Full Name of the application from my other table, but preforming a find seems to want only explicit data (ie if i search software::fullName then it litterally tries to find "software::fullName").

is there anyway i can make a find request a variable? i tried global variables, but this didn't work either :.

thanks in advance, this has me quite stumped.

-Mushi

[RalphL]

It seems to me you have 2 choices. Change the names in your old database to match those of the server, or make a calculation field in your new database to reduce the name to match what you have in the old one.

[Mushi]

I havn't worked much with calculation fields, but i will try your suggestion, thank you :