RE: Help on uv syntax, please
The problem (or not problem) with RAISE, is that it will also change all other marks at the same time. If you have a|b|c}d|e|f, and want a}b}c}d}e}f, you have to use CONVERT. RAISE will give you a}b}c^d}e}f *note ^ = fm, } = vm, | = svm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon Glorfield Sent: Tuesday, April 27, 2004 12:18 PM To: 'U2 Users Discussion List' Subject: RE: Help on uv syntax, please To do what you are saying I would use the RAISE function. NEWARRAY = RAISE(OLDARRAY) This would change all @SVM to @VM. Of course you would have to be kind of careful with it as it would also change all @VM to @AM. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, April 27, 2004 12:48 PM To: [EMAIL PROTECTED] Subject: Help on uv syntax, please Hi. Anybody got the syntax for universe for changing one string to another in an array? Mostly I use it for changing a subvalued field into a multivalued one. In Unidata, for example, its NEWARRAY = CHANGE(OLDARRAY,SVM,VM) I'm looking for a similar function in universe. (p.s. if you could e.mail me directly -- I am on digest mode and won't get the answer all day - thanks!) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Help on uv syntax, please
By array I assume you mean dynamic array and, as such, would use: NEWARRAY = CHANGE(OLDARRAY,@SVM, @VM) At 12:47 PM 4/27/2004, you wrote: Hi. Anybody got the syntax for universe for changing one string to another in an array? Mostly I use it for changing a subvalued field into a multivalued one. In Unidata, for example, its NEWARRAY = CHANGE(OLDARRAY,SVM,VM) I'm looking for a similar function in universe. (p.s. if you could e.mail me directly -- I am on digest mode and won't get the answer all day - thanks!) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please[Scanned]
So I could use the exact same 'CHANGE' syntax on Universe, then? That would be ideal -- even though I'm only converting the one character -- so could use CONVERT -- but if the same syntax will work as on UD then that's even better! Does this work with the exact same syntax? Where NEWARRAY = CHANGE(OLDARRAY,SVM,VM) Would change the char(252) to char(253) in the string 'OLDARRAY' Thanks a mil, Susan -Original Message- From: Georgia L. Pritchett [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 12:59 PM To: U2 Users Discussion List Cc: [EMAIL PROTECTED] Subject: RE: Help on uv syntax, please[Scanned] Actually CONVERT will only work to replace 1 character with 1 other character (well, it's more complicated than that because you provide a list of character to replace and another list of character to use for replacement but it's positionally dependant). It's what I use for converting 1 single character to another single character myself. But the CHANGE function, which is available in Universe, is more powerful since it can take a substring and convert it to a different length substring. So you convert all the OUT's in your string to IN's. Georgia Pritchett -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kishor Parmar I use CONVERT expression1 TO expression2 IN variable -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: 27 April 2004 17:48 To: [EMAIL PROTECTED] Subject: Help on uv syntax, please Hi. Anybody got the syntax for universe for changing one string to another in an array? Mostly I use it for changing a subvalued field into a multivalued one. In Unidata, for example, its NEWARRAY = CHANGE(OLDARRAY,SVM,VM) I'm looking for a similar function in universe. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please
UniVerse format: NEWARRAY = CONVERT(VM,SVM,OLDARRAY) Assuming VM = @VM or char(253) and SVM = @SM or char(252), This will use the data in OLDARRAY, convert all Value Marks to Sub-Value Marks, and assign the new data to NEWARRAY. Thanks, --Glenn. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, April 27, 2004 11:48 AM To: [EMAIL PROTECTED] Subject: Help on uv syntax, please Hi. Anybody got the syntax for universe for changing one string to another in an array? Mostly I use it for changing a subvalued field into a multivalued one. In Unidata, for example, its NEWARRAY = CHANGE(OLDARRAY,SVM,VM) I'm looking for a similar function in universe. (p.s. if you could e.mail me directly -- I am on digest mode and won't get the answer all day - thanks!) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please
To do what you are saying I would use the RAISE function. NEWARRAY = RAISE(OLDARRAY) This would change all @SVM to @VM. Of course you would have to be kind of careful with it as it would also change all @VM to @AM. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, April 27, 2004 12:48 PM To: [EMAIL PROTECTED] Subject: Help on uv syntax, please Hi. Anybody got the syntax for universe for changing one string to another in an array? Mostly I use it for changing a subvalued field into a multivalued one. In Unidata, for example, its NEWARRAY = CHANGE(OLDARRAY,SVM,VM) I'm looking for a similar function in universe. (p.s. if you could e.mail me directly -- I am on digest mode and won't get the answer all day - thanks!) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please
http://publibfi.boulder.ibm.com/epubs/pdf/25119090.pdf 10.1 Basic Ref, pg 162 CHANGE (expression, substring, replacement [ ,occurrence [ ,begin] ] ) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please
I use CONVERT expression1 TO expression2 IN variable Don't use CONVERT! Example: CRT CONVERT( 'Muffet', 'Piggy', 'Little Miss Muffet sat on a tuffet eating her curds and whey.' ) yields the string: Lily Piss Piggy sa on a iggy yaing hyr cirds and whyy. which is offensive enough even for those of us who don't speak Welsh. cds P.S. Last week I said REPLACE() instead of CHANGE() in the following post. I've corrected it ( i.e., CHANGE( 'REPLACE()', 'CHANGE()', MSGBODY ) ) here: -Original Message- From: Stevenson, Charles Sent: Thursday, April 22, 2004 2:41 PM To: 'U2 Users Discussion List' Subject: RE: How do we convert lowercase letters to uppercase in Pick basic and just cuz no one mentioned it ( not cuz it's better than UPCASE() DOWNCASE() ), CONVERT does character for character swapping: CONVERT 'abcdefghijklmnopqrstuvwxyz' TO 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' in ANYSTR and CONVERT 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' TO 'abcdefghijklmnopqrstuvwxyz' in ANYSTR or UPSTR = CONVERT( 'abcdefghijklmnopqrstuvwxyz', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', ANYSTR ) and DNSTR = CONVERT( 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz', ANYSTR ) depending on your mood. Note the difference between CHANGE() CONVERT(). Use CHANGE() to replace an entire substring with another substring. CONVERT does char by char. A common misconception. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please
-Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] [snip] Don't use CONVERT! Example: [snip] But it's great for things like: LINE = PRINT.ARRAYLINE.CTR CONVERT @VM:0.- TO IN LINE IF LINE # THEN GOSUB PRINT.LINE END I stand corrected. I don't mean there are no legitimate uses for CONVERT. In the spirit of Abraham Lincoln who once said, For people who like this sort of thing, this is exactly the sort of thing they'd like, I'll say, Do not use CONVERT except for exactly the sort of thing CONVERT should be used for. Ok, Abe's was better. I use convert a lot. Examples: 1. When I'm trying to debug a complicated multivalue-handling i-descriptor that isn't acting like I expect, I tack a convert on the end LIST to see what I've got: 01 I 02 [complicated buggy mv expression] ; CONVERT( @IM:@AM:@VM:@SM:@TM, 'iavst', @ ) 05 80L--- wide enough to see string 06 S --- it's not M anymore. 2. To yield a dyn array of question marks or blanks depending on whether corresponding values are equal: 01 I 02 CONVERT( '01', '?', EQS( MV.THING1, MV.THING2 ) ) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
