[no subject]

[Phil Roell <phil.roell@NATINST.COM>]

Hello All:

I have a PL/SQL package that I call from within SQR that returns a number of
variables concatenated together by carriage returns (chr(10)      i.e... $items
= VAR1[]VAR2[]VAR3[].....VAR100.. (where [] is a carriage return).

I have to take the string $items, unstring it by [] and print the results on
their own lines.  Easy enough.  The problem is that I do not know the number of
variables that the string contains.  It could be from 1 to 100 and I do not want
to hard code one hundred variables in an unstring command.  ie.... unstring by
'[]' into $var1 $var2.........$var100.

Does anyone have any ideas ?


Thanks,

Phil Roell
National Instruments
Manufacturing IS