[Robelle-l] suprtool-problem, string-related

[per.2.ostberg@kus.se]

greetings!
I have a tab-delimeted text-file with records looking (something) like
this:
data<tab>ID-number<tab>moreData

the ID-number (in ascii) is formatted as xxx-xxxx-x ("dash-separated",
"123-4567-8" as an example), but it is also an item (numeric, an I2 item,
12345678 in this example) in my TI dataset.
I need to split this file in two, depending on whether the ID-number exists
in the dataset or not. I am thinking of building a suprtool table and use
the $lookup-function, but am not able to figure out how to make suprtool
understand my "dash-separated" ID-number.
Is this do-able in suprtool or do I have to resort to MPE-CI-programming
(in combination with suprtool, of course)?
There's not that much data involved: the file will be a few hundred records
and the data-set will probably have 10000 records.

I'm grateful for any ideas.

tia
/per

--------------------------------------------------
Per Ostberg  / per.2.ostberg@kus.se
tel 08-58581213 / fax 08-58587710 / mob 070-4840253
LabMedicin-IT
Karolinska Universityhospital, Huddinge
C1 56 / 141 86  HUDDINGE / SWEDEN
--------------------------------------------------