[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[no subject]



Phil,

Did you consider using the Wrap feature of the print statement in
conjunction with the ON option?  For example:

Print $Item (+1,1)  Wrap 50 100
                    On=<10>

This will strip out the ASCII character 10 and cause each new value to be
printed on a separate line.

Ed


>From: Phil Roell <phil.roell@NATINST.COM>
>Reply-To: SQR-USERS@list.iex.net
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Date: Mon, 14 Jun 1999 13:12:45 -0500
>
>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


_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com