[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Re:unstring with variable columns
- Subject: [sqr-users] Re:unstring with variable columns
- From: David Donnelly <Dave@isisbio.com>
- Date: Thu, 25 Aug 2005 10:11:51 -0700
- Delivery-date: Thu, 25 Aug 2005 12:12:37 -0500
- In-reply-to: <E1E8FWe-00085G-01@seldon.sqrug.org>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
You can still use unstring:
read 1 into $in:80
! see note below about these moves
move '' to $a
move '' to $b
move '' to $c
move '' to $d
move '' to $e
unstring $in by ',' into $a $b $c $d $e
show $a ',' $b ',' $c ',' $d ',' $e
This works, leaving the unfilled variables set to null. In 6.1.3, the
initializing move statements are not necessary (and in fact they are
ineffective, because the unstring statement actually sets all the "unused"
variables to null. But you should verify that this behavior still happens
in your version of SQR, or explicitly set them all to null first.
Regards,
Dave
Dave Donnelly <dave@isisbio.com>
ISIS BioComp phone (951) 677-2446 fax (775) 314-7897
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users