RE: [sqr-users] Does input prompt take values separated bynewline character

["Kumar, Rahul" <Rahul_Kumar@adp.com>]

Hi Mahesh,

As peter told you have to run loop if you are using only one prompt. And
for getting separator use :

encode '<13>' into $cr
unstring $in_str by $cr into $value1 $value2 $value3

Hope this helps.

Cheers,
Rahul


-----Original Message-----
From: sqr-users-bounces+rahul_kumar=adp.com@sqrug.org
[mailto:sqr-users-bounces+rahul_kumar=adp.com@sqrug.org] On Behalf Of
Peter Burton
Sent: Friday, August 03, 2007 2:48 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Does input prompt take values separated by
newline character

Mahesh,

You need to either have three Input prompts or execute the same Input
prompt multiple times in a loop. 

Peter

-----Original Message-----
From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org
[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf
Of mahesh kadam
Sent: Friday, August 03, 2007 1:03 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Does input prompt take values separated by new line
character

Hi All,
 
  My requirement is user should be able to enter the values separated by
new line character.
 
  suppose the data is like:
  11111111
  22222222
  33333333
 
  then after copy pasting all these three values at once input prompt
should take all three. but currently prompt is taking only first value.
 
  The present code is:
 
  Input $no 'Enter No'  MaxLen = 32767 Type = char
 
  If this is possible, then what is the 'separator' between values? like
if the values are comma separated we can identify individual values by
getting the position of comma,so which separator should be used to
identify individual values in this case?
 
 
  Please help me out.
 
  Regards,
  Mahesh

 
---------------------------------
 Once upon a time there was 1 GB storage in your inbox. Click here for
happy ending.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

-----------------------------------------
This message and any attachments are intended only for the use of
the addressee and may contain information that is privileged and
confidential. If the reader of the message is not the intended
recipient or an authorized representative of the intended
recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this
communication in error, notify the sender immediately by return
email and delete the message and any attachments from your system.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users