Ang. RE: [Robelle-l] suprtool-problem, string-related

[per.2.ostberg@kus.se]

"Kurt Sager" <sager@sws.ch> skrev 2004-04-29 17:38:09:

>
> Hi Per,
>
> I hope you allow a PC to be used as well ...
>
> 1. import the file to Excel (tab delimited!), remove the dashes in the id
> column, copy the id column to notepad, then to HP3000

Hi Kurt,
no, sorry, this has to be automated, it's just a "small" part of a larger
job-stream...

> 2. remainder is standard ST task

hmmm, yes, but not something I do on a daily basis,  so I'd be happy for
examples.

thanks anyway!
/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
--------------------------------------------------

...
>
> 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
>