From sqr-users-bounces@sqrug.org Sun Jan 01 00:02:07 2006 Date: Sun, 1 Jan 2006 00:00:02 -0500 From: Nathan Stratton Treadway Subject: [sqr-users] Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathanst@ontko.com) $Revision: 1.22 $ $Date: 2005/08/19 05:12:40 $ This document gathers in one location information about the sqr-users mail list. It includes instructions for changing your subscription settings (including unsubscribing), as well are guidelines for using the list. ______________________________________________________________________ Table of Contents 1. Changes Since Previous Version 2. Introduction 2.1 sqr-users Mailing List 2.2 sqr-users Hints and Guidelines Document 2.3 Related Mailing Lists 3. Interacting with the list server 3.1 Subscribing to the list 3.2 Unsubscribing from the list 3.3 When your email address changes 3.4 Digests 3.5 Obtaining your password 3.6 Problems 4. Posting to the sqr-users List 4.1 General Guidelines 4.2 Posting a Message 4.3 Replying to a Message 5. Job Announcements ______________________________________________________________________ 1. Changes Since Previous Version Changes since the version dated 2004/03/04: o New name and URL for "HyperionSQR" mailing list. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Hyperion (and to other products in the SQR product suite). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. Brio Technology changed its name to Brio Software in October 2001. On October 16, 2003, Hyperion acquired Brio Software. SQR and related applications have also been called "Brio.Report" and "Brio Reports". The mailing list is provided as a service of Ray Ontko & Co. A searchable archive of past postings to the mailing list is available from the SQR Users Group web site . 2.2. sqr-users Hints and Guidelines Document This document gives various hints and guidelines about the sqr-users mailing list. It will be posted approximately monthly to the mailing list so that new users can see it (and existing users can find it easily). An HTML version of the document is always available at http://www.sqrug.org/sqr-users/sqr-users-hints.html. If you have comments or suggestions about this document, please contact me directly at the address listed in the title section. This document is Copyright (C) 1999-2004 by Ray Ontko & Co. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2.3. Related Mailing Lists Here are some mailing lists that cover topics relating to SQR in some way. sqr-jobs : SQR Jobs This list may be used for posting SQR-related resumes, recruitments, job announcements, project announcments, help- wanted, work-wanted ads, etc. To join, follow the link above, or send any message to "sqr-jobs-subscribe@yahoogroups.com". peoplesoft-fans : PeopleSoft Fans Moderated list covering technical and functional aspects of PeopleSoft. To join, follow the link above, or send any message to "peoplesoft-fans-subscribe@yahoogroups.com". psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). This list has merged with the Peoplesoft Fans mailing list and is no longer active, but the message achive can still be found at the link above. HyperionSQR : Hyperion- SQR List for discussion of SQR, SQR Developer (formerly called Brio.Report and Report Builder), and SQR iServer. To join, follow the link above, or send any message to "HyperionSQR- subscribe@yahoogroups.com". rm-users : Report- Mart Users List for discussion of Brio Portal (previously called ReportMart). To join, follow the link above, or send a message containing the word "subscribe" in the body to "rm-users- request@sqrug.org". brioportalusersgroup : Brio Portal Users Group list List for discussion of Brio Portal. To join, follow the link above, or send any message to "brioportalusersgroup- subscribe@yahoogroups.com". brio-l : OpenITx Brio List List for technical and functional discussion of all Brio products (but most messages are currently about Brio Intelligence). To join, follow the link above. briousers : Brio.Enter- prise Users List for discussion of the Brio.Enterprise (now called Intelligence) product. To join, follow the link above, or send any message to "briousers-subscribe@yahoogroups.com". briolist : Brio List List for discussion of Brio Intelligence. To join, follow the link above, or send any message to "briolist- subscribe@yahoogroups.com". 3. Interacting with the list server The sqr-users mailing list is hosted using the Mailman list server package. All of the Mailman functions described below are accessed from the sqr-users List Info page, "http://www.sqrug.org/mailman/listinfo/sqr-users". 3.1. Subscribing to the list To subscribe to the mailing list, enter your e-mail address in the box at the top of the "Subscribing to sqr-users" section on the sqr-users List Info page, then choose a password to assign to your subscription and enter it in both "Password" boxes. This password is used to allow you to securely make changes to your subscription over the web. This password will be e-mailed back to you at varous times, so you should not use the same password as you are using elsewhere. Once you have filled in the password, click the "Subscribe" button. You should soon receive an e-mail message from the list server requesting confirmation of your subscription request. Once you have replied to this message and your subscription has been processed, you will receive a "welcome" message giving you more information on the list server, and as well as a reminder of the subscription password you chose. 3.2. Unsubscribing from the list To unsubscribe from the list, go to the sqr-users List Info page, enter your e-mail address in the "sqr-users Subscribers" section near the bottom of the page, and click the "Unsubscribe or edit options" button. You will then see the "member options" page; fill in your password at the top of the page and click "Log in". (If you have forgotton your password, see the ``Obtaining your Password'' section, below). This will take you to the "membership configuration" page. In the middle of that page, there will be an "Unsubscribing from sqr- users" section; simply turn on the "Yes, I really want to unsubscribe" checkbox and click the "Unsubscribe" button. You should get a page back saying that the removal was successful (as well as a confirmation email message). The removal will take effect immediately; there is no need to send in a confirmation e-mail message. If you don't know your password, you can choose to unsubscribe using e-mail confirmation. Instead of entering the password on the "member options" page, just click the "Unsubscribe" button found just below the "Log In" button. You will then see a page noting that a confirmation e-mail has been sent; once you follow the confirmation instructions in that e-mail your removal will be complete. 3.3. When your email address changes If your e-mail address changes -- for example, if your company changes names, or if your mail administrator changes the way your name is spelled out or abbreviated -- you will need to update your subscription to match your new address before you can post to the list (see the ``Posting'' section, below). To do this, simply log in to your "membership configuration" page (see the directions for logging in to this page in the ``Unsubscribing'' section, above). At the top of that page you'll see a "Changing your membership information" section. Fill out the text boxes and click the "Change My Address and Name" button. You will be sent a confirmation e-mail, and once you have responded to that e-mail your subscription will be updated and you can begin posting from your new address. 3.4. Digests You can request to get your messages in digest form (one large message containing all of the posts made each day). To do this, log in to your "membership configuration" page (see the directions on doing this in the ``Unsubscribing'' section, above). At the bottom of the page, you will see a section titled "Your sqr-users Subscription Options". Change the "Set Digest Mode" option (the second option in the list) to "On" and click the "Submit My Changes" button at the bottom of the page. You actually have a choice of two different digest formats, "MIME" or "Plain Text". The MIME format sends each individual list message as a separate MIME attachment to the digest; the plain text format consists of one large text message, with all of the individual messages run together. Which format you will want to use depends on your mail- reading software (and personal preference). If you are not sure which format will work best, you can just leave the default setting of "MIME" and see if the next morning's digest is easy to read in your mail reader -- you can change to the other format at any time using that same web page. If you use digests, you should not just "reply" to the digest mailing. Instead, be sure your message's subject header matches the subject in the original posting to which you are replying, and that you don't include a quoted copy of the entire digest in your post. To restore normal distribution, simply follow the above instructions choosing the "Off" setting for the Digest option. 3.5. Obtaining your password You will not be able to change your subscription options without your password. If you have forgotten your password, simply click the "Email My Password to Me" button on the "member options" page and your password will be emailed to you. You will also be e-mailed a copy of your password at the beginning of each month, as part of a "mailing list memberships reminder" message from the Mailman software. 3.6. Problems If the above instructions do not work, please contact the list manager at "sqr-users-manager@sqrug.org". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a description of what you were trying to do and what exactly happened when you made the attempt. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). More specifically, in order for Mailman to recognize that this message was sent by a subscriber, the return address on your message much exactly match the addresss you used to subscribe -- if you have more than one address you will need to be sure that you are sending from the correct one. (See the ``When you email address changes'' section, above, if your e-mail address has changed since you subscribed.) 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list as other subscribers' mail systems repond....) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) The list server will delete these special attachments from your message and send you a warning notice. Also, if you are trying to send (for example) SQR source code files, make sure your mail-reader software is assigning proper MIME types to your attachments or they may not be distributed. o keep in mind that over 500 people will receive your message, and that it will appear in the list archives. Try to keep your messages on-topic and relatively short. Consider sending your message directly to particular people if it won't interest many of the list's subscribers. o ignore abusive and inappropriate messages that get sent to the list, rather than getting drawn into a debate. The very nature of these messages will cause most subscribers to automatically discredit them -- no "response" is necessary. To the contrary, any response will only "add fuel to the fire," prolonging the controversy and further interupting the normal conversation on the list. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@sqrug.org". Be sure your subject heading describes your specific problem or question (i.e. don't just use "SQR Question"). In the body of your message, please include the following information: o SQR product name and version number (see notes below) o Operating system name and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. (For PeopleSoft- specific questions, see other lists mentioned in the ``Related Mailing Lists'' section.) In 2001, PeopleSoft purchased from Brio the rights to the source code for SQR and began releasing its own line of SQR. PeopleSoft's SQR version numbering is different from Brio/Hyperion's, so it's very important to mention whether you are using Hyperion's "SQR" or "SQR for PeopleSoft". (This info is included automatically if you include the full SQR version-id string as described below.) To get the version-id string for your copy of SQR, you can run the following program: begin-program show $sqr-ver end-program This will produce a line that looks something like this: SQR/3.0.15/Intel/SCO Unix R3.2 V5.0/Oracle 7.2.2.3/Sep 25 1996 Include the full line of output in your message. Note that the oper- ating system and database version numbers listed here are the ones under which this copy of SQR was compiled, so you'll still need to include this information for your own environment. In a command-line environment (Unix, etc.), you can also get this version-id string by saying sqr -id 4.3. Replying to a Message Messages sent out on the list have a Reply-To header pointing to the list. This means that you should be able to simply use your mail reader's "reply" function to send a reply to the list. Generally, all answers to questions sent out on the list should be public replies, so that other subscribers can benefit. In those cases where a private reply is appropriate, be sure to over-ride the default Reply-To address. If your message is not actually a reply to the earlier message, please do not use the "reply" function. Instead, address a new e-mail message to the list as described in the previous section. (This is because the list archives will incorrectly show the new message in the original thread if you use "reply".) You should quote enough lines from the original message that later readers can understand your answer even if they missed the original question. At the same time, you should remove any unnecessary lines from the quote in order to make your message shorter and easier to understand. (Remember that some people read the mailing list in digest form, and the digests become much larger if unnecessary lines are quoted.) 5. Job Announcements Please do not post job announcements on the sqr-users list, but use the sqr-jobs list instead. (See ``Related Mailing Lists'' for more information on this list.) A large number of sqr-users subscribers do not want to receive job announcements (for various reasons) and such posts tend to cause a lot of disruption of the discussion on the list. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jan 02 13:50:57 2006 Date: Mon, 2 Jan 2006 13:48:58 -0500 From: "Sudheer Bachu" Subject: [sqr-users] Font size problem in sqr report Hi, Am working on sqr reports using HTML procedures(tables). Iam getting the data and the layout fine....but the size of the font is my main concern. Can somebody help me out in controlling the size and font of the numbers or characters. =20 I used ...alter-printer font=3D3 point-size=3D12, alter-printer font=3D5 point-size=3D12( am using consistently any one of these at a time not both) commands which didn't gave any results. Here is the problem.... =20 let's say if I have a number $314,235.... of which first 3 digits are of different size than others and also the case. =20 =20 Please let me know if you can help me out =20 Sudheer Bachu _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jan 03 15:09:46 2006 From: "kyle.leonard" Subject: Re: [sqr-users] Font size problem in sqr report Date: Tue, 3 Jan 2006 15:07:50 -0500 Changing the XX for the point-size=xx will change the size of the font, the font=x changes the typeface (ie Arial, Times, etc). Also note that different output accepts changing the fonts differently...IE PDF output allows different choices in fonts than does HTML output. As for a number with different fonts for different parts of the number... You'll have to substring the number into different fields and print each substring separately with an alter-printer between print statements. Good luck, Kyle Leonard 1AnswerSolutions On Mon, 2 Jan 2006 13:48:58 -0500, Sudheer Bachu wrote > Hi, > > Am working on sqr reports using HTML procedures(tables). Iam > getting the data and the layout fine....but the size of the font is > my main concern. > > Can somebody help me out in controlling the size and font of the numbers > or characters. > > > > I used ...alter-printer font=3 point-size=12, alter-printer font=5 > point-size=12( am using consistently any one of these at a time not > both) commands which didn't gave any results. Here is the problem.... > > > > let's say if I have a number $314,235.... > > of which first 3 digits are of different size than others and also > the case. > > > > > > Please let me know if you can help me out > > > > Sudheer Bachu > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users ___________________________________ Kyle J. Leonard kyle.leonard@1answersolutions.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jan 02 14:39:54 2006 Date: Mon, 2 Jan 2006 14:38:04 -0500 From: "Sudheer Bachu" Subject: [sqr-users] How do i change the color of a column Hi, How can i change the color of a specific column or a specific row in a html table in a sqr report =20 =20 Sudheer Bachu _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jan 03 09:08:28 2006 Date: Tue, 3 Jan 2006 09:05:37 -0500 From: "Debbie Larney" Subject: [sqr-users] Read a file into sqr I have a text file that I am reading in through sqr. The file has no carria= ge returns or line breaks so the file wraps around. The end of a line appea= rs to be delineated by a non ascii character so I can identify the end of a= line. I think I need to in essence do a find and replace on the non ascii = character so that I can replace it with a line break and read the file line= by line into the sqr. Anyone have sample code or ideas doing a find and re= place within sqr. Do I have to first read the entire file into a string an= d then do the find and replace. If so what are the limitations with this me= thod. Thanks, Debbie ********************************************************************=20 CONFIDENTIALITY NOTICE:=20 The information contained in this e-mail is legally privileged and confiden= tial information intended only for the use of the individual or entity to w= hom it is addressed. If the reader of this message is not the intended rec= ipient, you are hereby notified that any viewing, dissemination, distributi= on, or copying of this e-mail message is strictly prohibited. If you have = received and/or are viewing this e-mail in error, please immediately notify= the sender by reply e-mail, and delete this e-mail from your system. Thank you.=20 ********************************************************************=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jan 03 15:01:07 2006 From: "kyle.leonard" Subject: Re: [sqr-users] Read a file into sqr Date: Tue, 3 Jan 2006 14:59:02 -0500 Debbie, SQR reads a text file line by line. Just put the read within an endless loop and break out when the end-of-file is reached. For example: open 'blah.txt' as 1 for reading record=100:vary while 1 if #end-file break end-if read 1 into $some_variable:500 !The 500 indicate how many columns or chars wide the widest line is. let $paragraph = $paragraph || ' ' || $some_variable !OR ANOTHER APPROACH read 1 into $name:30 $addr:30 $city:20 $state:2 $zip:5 ! <--do something here with the retrieved variables (store in array, print, etc)--> end-while close 1 NOTE: I am referencing version 8.1 help file for my example. Kyle Leonard 1AnswerSolutions On Tue, 3 Jan 2006 09:05:37 -0500, Debbie Larney wrote > I have a text file that I am reading in through sqr. The file has no > carriage returns or line breaks so the file wraps around. The end of > a line appears to be delineated by a non ascii character so I can > identify the end of a line. I think I need to in essence do a find > and replace on the non ascii character so that I can replace it with > a line break and read the file line by line into the sqr. Anyone > have sample code or ideas doing a find and replace within sqr. Do I > have to first read the entire file into a string and then do the > find and replace. If so what are the limitations with this method. > > Thanks, > > Debbie > > ******************************************************************** > CONFIDENTIALITY NOTICE: > The information contained in this e-mail is legally privileged and > confidential information intended only for the use of the individual > or entity to whom it is addressed. If the reader of this message is > not the intended recipient, you are hereby notified that any viewing, > dissemination, distribution, or copying of this e-mail message is > strictly prohibited. If you have received and/or are viewing this e- > mail in error, please immediately notify the sender by reply e-mail, > and delete this e-mail from your system. > > Thank you. > ******************************************************************** > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users ___________________________________ Kyle J. Leonard kyle.leonard@1answersolutions.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jan 04 10:59:41 2006 Subject: RE: [sqr-users] Read a file into sqr Date: Wed, 4 Jan 2006 10:57:05 -0500 From: "Bob Buford" Hi Debbie, I would expect that the "non-ascii" character is really an ascii "non-printable" character. If you can determine what it is, and that it ends each line, then you can read for it and build a complete record line that you can then process. (If not any brighter ideas, you could do like I did and write a loop to evaluate and display each character and its ascii number). Are these non-printable characters at the same interval (e.g. every 50 characters)? If so, perhaps you could read into a variable of fixed length. Just some thoughts to help you further along this quest Bob -----Original Message----- From: Debbie Larney [mailto:debbie.larney@thicare.com]=20 Sent: Tuesday, January 03, 2006 9:06 AM To: sqr-users@sqrug.org Subject: [sqr-users] Read a file into sqr I have a text file that I am reading in through sqr. The file has no carriage returns or line breaks so the file wraps around. The end of a line appears to be delineated by a non ascii character so I can identify the end of a line. I think I need to in essence do a find and replace on the non ascii character so that I can replace it with a line break and read the file line by line into the sqr. Anyone have sample code or ideas doing a find and replace within sqr. Do I have to first read the entire file into a string and then do the find and replace. If so what are the limitations with this method. Thanks, Debbie ******************************************************************** CONFIDENTIALITY NOTICE:=20 The information contained in this e-mail is legally privileged and confidential information intended only for the use of the individual or entity to whom it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any viewing, dissemination, distribution, or copying of this e-mail message is strictly prohibited. If you have received and/or are viewing this e-mail in error, please immediately notify the sender by reply e-mail, and delete this e-mail from your system. Thank you.=20 ********************************************************************=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jan 04 11:20:37 2006 Date: Wed, 4 Jan 2006 09:18:46 -0700 From: Robert Goshko Subject: Re: [sqr-users] Read a file into sqr On 03/01/06, Debbie Larney wrote: > I have a text file that I am reading in through sqr. The file has no carr= iage returns or line breaks so the file wraps around. The end of a line app= ears to be delineated by a non ascii character so I can identify the end of= a line. I think I need to in essence do a find and replace on the non asci= i character so that I can replace it with a line break and read the file li= ne by line into the sqr. Anyone have sample code or ideas doing a find and = replace within sqr. Do I have to first read the entire file into a string = and then do the find and replace. If so what are the limitations with this = method. It is probably a UNIX based file, they just have a line feed (0x0a) character and look like one big long line in Notepad, PC based files have a carriage return and line feed (0x0d 0x0a) at the end of each line. SQR parses files by looking for a "newline" which is either of the combinations so it will read the file fine. -- ...Rob -- No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Robert Goshko Registered Linux User #260513 Want a Gmail account, 2.6+ GB web mail (for free), just ask me. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jan 04 17:21:06 2006 From: "Gopal Krishan" Subject: RE: [sqr-users] Read a file into sqr Date: Thu, 5 Jan 2006 09:26:22 +1100 Try following: - open the file in microsoft Wordpad (not microsoft word) - save after making a dummy change - try processing the new file using your sqr Gopal. -----Original Message----- From: sqr-users-bounces+gkrishan=bigpond.net.au@sqrug.org [mailto:sqr-users-bounces+gkrishan=bigpond.net.au@sqrug.org]On Behalf Of Robert Goshko Sent: Thursday, January 05, 2006 3:19 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Read a file into sqr On 03/01/06, Debbie Larney wrote: > I have a text file that I am reading in through sqr. The file has no carriage returns or line breaks so the file wraps around. The end of a line appears to be delineated by a non ascii character so I can identify the end of a line. I think I need to in essence do a find and replace on the non ascii character so that I can replace it with a line break and read the file line by line into the sqr. Anyone have sample code or ideas doing a find and replace within sqr. Do I have to first read the entire file into a string and then do the find and replace. If so what are the limitations with this method. It is probably a UNIX based file, they just have a line feed (0x0a) character and look like one big long line in Notepad, PC based files have a carriage return and line feed (0x0d 0x0a) at the end of each line. SQR parses files by looking for a "newline" which is either of the combinations so it will read the file fine. -- ...Rob -- No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. ================================================ Robert Goshko Registered Linux User #260513 Want a Gmail account, 2.6+ GB web mail (for free), just ask me. _______________________________________________ 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 From sqr-users-bounces@sqrug.org Wed Jan 04 12:36:53 2006 Date: Wed, 04 Jan 2006 12:34:23 -0500 From: "George Jansen" Subject: Re: [sqr-users] Read a file into sqr The alternative would be to use some other tool, e.g. Perl. For example, us= ing "z" as the delimiter for convenience, you could /tmp>echo 'AAAAAAAAAAAAAAzBBBBBBBBBBBBBzCCCCCCCCCCCz' > stuff.txt /tmp>perl -e '$/ =3D "z"; while(<>) { chop; print $_, "\n";}' stuff.txt AAAAAAAAAAAAAA BBBBBBBBBBBBB CCCCCCCCCCC >>> robert.goshko@gmail.com 01/04/06 11:18 AM >>> On 03/01/06, Debbie Larney wrote: > I have a text file that I am reading in through sqr. The file has no carr= iage returns or line breaks so the file wraps around. The end of a line app= ears to be delineated by a non ascii character so I can identify the end of= a line. I think I need to in essence do a find and replace on the non asci= i character so that I can replace it with a line break and read the file li= ne by line into the sqr. Anyone have sample code or ideas doing a find and = replace within sqr. Do I have to first read the entire file into a string = and then do the find and replace. If so what are the limitations with this = method. It is probably a UNIX based file, they just have a line feed (0x0a) character and look like one big long line in Notepad, PC based files have a carriage return and line feed (0x0d 0x0a) at the end of each line. SQR parses files by looking for a "newline" which is either of the combinations so it will read the file fine. -- ...Rob -- No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Robert Goshko Registered Linux User #260513 Want a Gmail account, 2.6+ GB web mail (for free), just ask me. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jan 03 09:25:36 2006 Date: Tue, 3 Jan 2006 09:23:48 -0500 From: "White . Denise" Subject: [sqr-users] Anyone out there? Is this list dead? I am still getting the monthly hints email, but have not gotten any digests for months (other than the one with the monthly hints). I checked the website, but there do not seem to be any new posts since 10/1/2005. What happened? Denise M. White EBS Programmer/Analyst III Dynamics Research Corporation _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jan 03 09:42:08 2006 Date: Tue, 3 Jan 2006 06:39:44 -0800 (PST) From: Tom Vincent Subject: Re: [sqr-users] Anyone out there? Well, obviously all the possible SQR questions have been answered. :) Seriously, I think a lot of SQR people get their info from the list on IT Toolbox. There's about 3,000 subscribers to that list. Tom DE "White . Denise" wrote: Is this list dead? I am still getting the monthly hints email, but have not gotten any digests for months (other than the one with the monthly hints). I checked the website, but there do not seem to be any new posts since 10/1/2005. What happened? Denise M. White EBS Programmer/Analyst III Dynamics Research Corporation _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users -*-*-*-*-*-*-*-*-* Tom Vincent -*-*-*-*-*-*-*-*-* "The test of our progress is not whether we add more to the abundance of those who have much; it is whether we provide enough for those who have too little." - Franklin Roosevelt _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jan 03 09:45:31 2006 From: "the dragon" Subject: RE: [sqr-users] Anyone out there? Date: Tue, 03 Jan 2006 08:42:35 -0600 Hi Denise Lady luck never smiles So lend your love to me, awhile Do with me what you will Break the spell take your fill On and on we rode the storm The flame has died, the fire has gone Oh, this empty bed is a night alone I realized that long ago Is anybody out there? Anybody there? Does anybody wonder? Anybody care? Oh, I just gotta know If you're really there and you really care 'Cause baby I'm not F- f - f - foolin', ah f - f - f - foolin' Not f - f - f - foolin', ah f - f - f - foolin' Won't you stay with me awhile Close your eyes don't run and hide Easy love is not easy ride Just wakin' up from what we had Could stop good love from goin' bad -------------------------------------------------------------------------- In any case, I'm here, occassionally. I usually reply to replies individually, after I determine they are not interlopers. While I support the concept of this group, and approve of the exchange of ideas, I refuse to share information with wanna be coders from the Pan-Asia area who are trying to take American jobs when they have absolutely no experience. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. I work to live; I don't live to work. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Is this list dead? I am still getting the monthly hints email, but have not gotten any digests for months (other than the one with the monthly hints). I checked the website, but there do not seem to be any new posts since 10/1/2005. What happened? Denise M. White EBS Programmer/Analyst III Dynamics Research Corporation _________________________________________________________________ Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jan 03 09:52:17 2006 Subject: Re: [sqr-users] Anyone out there? From: JOHN_HARRIS@qvc.com Date: Tue, 3 Jan 2006 09:43:59 -0500 This is a multi-part message in MIME format... --0__=0ABBFA78DFC36F528f9e8a93df938690918c0ABBFA78DFC36F52 Content-type: text/plain; charset=US-ASCII I am getting posts. Thank you. Regards, John (Embedded image moved John Harris to file: Programmer/Analyst pic06224.jpg) Application Development - Internal QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262 Telephone 484-701-3303 Fax 484-701-8689 e-mail jharris@qvc.com This message may contain information that is privileged or confidential. This message may contain information that is privileged or confidential. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. |---------+-----------------------------------------------> | | "White . Denise" | | | Ext: | | | Sent by: | | | sqr-users-bounces+john_harris=qvc.co| | | m@sqrug.org | | | | | | | | | 01/03/2006 09:23 AM | | | Please respond to "This list is for | | | discussion about the SQR database | | | reporting language from | | | Hyperion Solutions." | | | | |---------+-----------------------------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: | | cc: (bcc: JOHN HARRIS/QVC) | | Subject: [sqr-users] Anyone out there? | >------------------------------------------------------------------------------------------------------------------------------| Is this list dead? I am still getting the monthly hints email, but have not gotten any digests for months (other than the one with the monthly hints). I checked the website, but there do not seem to be any new posts since 10/1/2005. What happened? Denise M. White EBS Programmer/Analyst III Dynamics Research Corporation _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --0__=0ABBFA78DFC36F528f9e8a93df938690918c0ABBFA78DFC36F52 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'image/jpeg' MIME type. It has been automatically discarded before sending the message to the list. --0__=0ABBFA78DFC36F528f9e8a93df938690918c0ABBFA78DFC36F52 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --0__=0ABBFA78DFC36F528f9e8a93df938690918c0ABBFA78DFC36F52-- From sqr-users-bounces@sqrug.org Tue Jan 03 09:48:57 2006 Subject: RE: [sqr-users] Anyone out there? Date: Tue, 3 Jan 2006 09:46:44 -0500 From: "Sudheer Bachu" That was aw=3D=3Dwsome sunny -----Original Message----- From: sqr-users-bounces+sbachu=3Dcreditacceptance.com@sqrug.org [mailto:sqr-users-bounces+sbachu=3Dcreditacceptance.com@sqrug.org] On Behalf Of the dragon Sent: Tuesday, January 03, 2006 9:43 AM To: sqr-users@sqrug.org Cc: DWhite@drc.com Subject: RE: [sqr-users] Anyone out there? Hi Denise Lady luck never smiles So lend your love to me, awhile Do with me what you will Break the spell take your fill On and on we rode the storm The flame has died, the fire has gone Oh, this empty bed is a night alone I realized that long ago Is anybody out there? Anybody there? Does anybody wonder? Anybody care? Oh, I just gotta know If you're really there and you really care 'Cause baby I'm not F- f - f - foolin', ah f - f - f - foolin' Not f - f - f - foolin', ah f - f - f - foolin' Won't you stay with me awhile Close your eyes don't run and hide Easy love is not easy ride Just wakin' up from what we had Could stop good love from goin' bad ------------------------------------------------------------------------ -- In any case, I'm here, occassionally. I usually reply to replies=20 individually, after I determine they are not interlopers. While I support=20 the concept of this group, and approve of the exchange of ideas, I refuse to=20 share information with wanna be coders from the Pan-Asia area who are trying=20 to take American jobs when they have absolutely no experience. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your=20 services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be=20 recovered, so don't waste it by giving it away. I work to live; I don't live to work. "Time is the coin of your life. It is the only coin you have, and only you=20 can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Is this list dead? I am still getting the monthly hints email, but have not gotten any digests for months (other than the one with the monthly hints). I checked the website, but there do not seem to be any new posts since 10/1/2005. What happened? Denise M. White EBS Programmer/Analyst III Dynamics Research Corporation _________________________________________________________________ Don't just search. Find. Check out the new MSN Search!=20 http://search.msn.click-url.com/go/onm00200636ave/direct/01/ _______________________________________________ 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 From sqr-users-bounces@sqrug.org Tue Jan 03 10:13:25 2006 Date: Tue, 03 Jan 2006 10:11:32 -0500 From: don.barclay@srs.gov Subject: Re: [sqr-users] Anyone out there? Denise, I bcc'd you on this so you could see the response. There may be a problem with the digests. I have been getting about a dozen e-mails a week from the list. I checked the web-site, and I see 164 posts since 10/1/05 (the recent messages page is ordered oldest to newest, so you'll have to scroll down to see the latest posts). Don sqr-users-bounces+don.barclay=srs.gov@sqrug.org wrote on 01/03/2006 09:23:48 AM: > Is this list dead? I am still getting the monthly hints email, but have > not gotten any digests for months (other than the one with the monthly > hints). I checked the website, but there do not seem to be any new > posts since 10/1/2005. What happened? > > Denise M. White > EBS Programmer/Analyst III > Dynamics Research Corporation > > _______________________________________________ > 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 From sqr-users-bounces@sqrug.org Tue Jan 03 10:32:26 2006 Date: Tue, 3 Jan 2006 07:29:59 -0800 (PST) From: Sam Spritzer Subject: Re: [sqr-users] Anyone out there? I am here. I get a few posts occasionally but not like in the old days. "White . Denise" wrote: Is this list dead? I am still getting the monthly hints email, but have not gotten any digests for months (other than the one with the monthly hints). I checked the website, but there do not seem to be any new posts since 10/1/2005. What happened? Denise M. White EBS Programmer/Analyst III Dynamics Research Corporation _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ************************************************************ "In the beginning, there was something...which exploded yet, they find nothing." --------------------------------- Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Mar 01 16:15:31 2006 Subject: RE: [sqr-users] Anyone out there? Date: Wed, 1 Mar 2006 15:12:58 -0600 From: "Lindquist, Maria" What is the link for that ittoolbox.com? =20 -----Original Message----- From: sqr-users-bounces+mlindqui=3Duwc.edu@sqrug.org [mailto:sqr-users-bounces+mlindqui=3Duwc.edu@sqrug.org] On Behalf Of Tom Vincent Sent: Tuesday, January 03, 2006 8:40 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Anyone out there? Well, obviously all the possible SQR questions have been answered. :) =20=20=20 Seriously, I think a lot of SQR people get their info from the list on IT Toolbox. There's about 3,000 subscribers to that list. =20=20=20 Tom DE "White . Denise" wrote: Is this list dead? I am still getting the monthly hints email, but have not gotten any digests for months (other than the one with the monthly hints). I checked the website, but there do not seem to be any new posts since 10/1/2005. What happened? Denise M. White EBS Programmer/Analyst III Dynamics Research Corporation _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users =20=20 -*-*-*-*-*-*-*-*-* Tom Vincent -*-*-*-*-*-*-*-*-* "The test of our progress is not whether we add more to the abundance of those who have much; it is whether we provide enough for those who have too little." - Franklin Roosevelt _______________________________________________ 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 From sqr-users-bounces@sqrug.org Wed Mar 01 16:27:13 2006 Subject: RE: [sqr-users] Anyone out there? Date: Wed, 1 Mar 2006 15:25:16 -0600 From: "Thompson, Betty P" http://www.ittoolbox.com/ -----Original Message----- From: sqr-users-bounces+thompsob=3Duww.edu@sqrug.org [mailto:sqr-users-bounces+thompsob=3Duww.edu@sqrug.org] On Behalf Of Lindquist, Maria Sent: Wednesday, March 01, 2006 3:13 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Anyone out there? What is the link for that ittoolbox.com? =20 -----Original Message----- From: sqr-users-bounces+mlindqui=3Duwc.edu@sqrug.org [mailto:sqr-users-bounces+mlindqui=3Duwc.edu@sqrug.org] On Behalf Of Tom Vincent Sent: Tuesday, January 03, 2006 8:40 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Anyone out there? Well, obviously all the possible SQR questions have been answered. :) =20=20=20 Seriously, I think a lot of SQR people get their info from the list on IT Toolbox. There's about 3,000 subscribers to that list. =20=20=20 Tom DE "White . Denise" wrote: Is this list dead? I am still getting the monthly hints email, but have not gotten any digests for months (other than the one with the monthly hints). I checked the website, but there do not seem to be any new posts since 10/1/2005. What happened? Denise M. White EBS Programmer/Analyst III Dynamics Research Corporation _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users =20=20 -*-*-*-*-*-*-*-*-* Tom Vincent -*-*-*-*-*-*-*-*-* "The test of our progress is not whether we add more to the abundance of those who have much; it is whether we provide enough for those who have too little." - Franklin Roosevelt _______________________________________________ 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 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Mar 15 09:23:23 2006 From: "CGServices - HRIS Desk" Subject: RE: [sqr-users] Anyone out there? Date: Wed, 15 Mar 2006 09:20:53 -0500 In all jesting fun - there are signs of artificial intelligence all over the place... :) -----Original Message----- From: sqr-users-bounces+hris=cgservices.com@sqrug.org [mailto:sqr-users-bounces+hris=cgservices.com@sqrug.org] On Behalf Of Thompson, Betty P Sent: Wednesday, March 01, 2006 4:25 PM To: This list is for discussion about the SQR database reportinglanguagefrom Hyperion Solutions. Subject: RE: [sqr-users] Anyone out there? http://www.ittoolbox.com/ -----Original Message----- From: sqr-users-bounces+thompsob=uww.edu@sqrug.org [mailto:sqr-users-bounces+thompsob=uww.edu@sqrug.org] On Behalf Of Lindquist, Maria Sent: Wednesday, March 01, 2006 3:13 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Anyone out there? What is the link for that ittoolbox.com? -----Original Message----- From: sqr-users-bounces+mlindqui=uwc.edu@sqrug.org [mailto:sqr-users-bounces+mlindqui=uwc.edu@sqrug.org] On Behalf Of Tom Vincent Sent: Tuesday, January 03, 2006 8:40 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Anyone out there? Well, obviously all the possible SQR questions have been answered. :) Seriously, I think a lot of SQR people get their info from the list on IT Toolbox. There's about 3,000 subscribers to that list. Tom DE "White . Denise" wrote: Is this list dead? I am still getting the monthly hints email, but have not gotten any digests for months (other than the one with the monthly hints). I checked the website, but there do not seem to be any new posts since 10/1/2005. What happened? Denise M. White EBS Programmer/Analyst III Dynamics Research Corporation _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users -*-*-*-*-*-*-*-*-* Tom Vincent -*-*-*-*-*-*-*-*-* "The test of our progress is not whether we add more to the abundance of those who have much; it is whether we provide enough for those who have too little." - Franklin Roosevelt _______________________________________________ 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 _______________________________________________ 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 From sqr-users-bounces@sqrug.org Wed Mar 15 16:20:55 2006 Date: Wed, 15 Mar 2006 16:17:41 -0500 From: =?ISO-8859-1?Q?Eric_Gigu=E8re?= Subject: Re: [sqr-users] Anyone out there? I'm not an artificial one! :) Auto-replies never give answers to questions, a shame! :P Eric. CGServices - HRIS Desk wrote: > In all jesting fun - there are signs of artificial intelligence all over the > place... :) > > -----Original Message----- > From: sqr-users-bounces+hris=cgservices.com@sqrug.org > [mailto:sqr-users-bounces+hris=cgservices.com@sqrug.org] On Behalf Of > Thompson, Betty P > Sent: Wednesday, March 01, 2006 4:25 PM > To: This list is for discussion about the SQR database reportinglanguagefrom > Hyperion Solutions. > Subject: RE: [sqr-users] Anyone out there? > > http://www.ittoolbox.com/ > > -----Original Message----- > From: sqr-users-bounces+thompsob=uww.edu@sqrug.org > [mailto:sqr-users-bounces+thompsob=uww.edu@sqrug.org] On Behalf Of > Lindquist, Maria > Sent: Wednesday, March 01, 2006 3:13 PM > To: This list is for discussion about the SQR database reportinglanguage > fromHyperion Solutions. > Subject: RE: [sqr-users] Anyone out there? > > What is the link for that ittoolbox.com? > > > -----Original Message----- > From: sqr-users-bounces+mlindqui=uwc.edu@sqrug.org > [mailto:sqr-users-bounces+mlindqui=uwc.edu@sqrug.org] On Behalf Of Tom > Vincent > Sent: Tuesday, January 03, 2006 8:40 AM > To: This list is for discussion about the SQR database reporting > languagefrom Hyperion Solutions. > Subject: Re: [sqr-users] Anyone out there? > > Well, obviously all the possible SQR questions have been answered. :) > > Seriously, I think a lot of SQR people get their info from the list on IT > Toolbox. There's about 3,000 subscribers to that list. > > Tom > DE > > "White . Denise" wrote: > Is this list dead? I am still getting the monthly hints email, but have > not gotten any digests for months (other than the one with the monthly > hints). I checked the website, but there do not seem to be any new posts > since 10/1/2005. What happened? > > Denise M. White > EBS Programmer/Analyst III > Dynamics Research Corporation > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > > > > > -*-*-*-*-*-*-*-*-* > Tom Vincent > > -*-*-*-*-*-*-*-*-* > > "The test of our progress is not whether we add more to the abundance of > those who have much; it is whether we provide enough for those who have too > little." - Franklin Roosevelt > > _______________________________________________ > 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 > > _______________________________________________ > 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 > > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jan 05 13:39:11 2006 Date: Thu, 5 Jan 2006 13:37:02 -0500 From: "Kaithi, Murali" Subject: [sqr-users] Rounding to the next whole number I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Servic= es, utilizing MessageLabs proprietary SkyScan infrastructure. For more info= rmation on a proactive anti-virus service working around the clock, around = the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jan 05 13:43:09 2006 Subject: RE: [sqr-users] Rounding to the next whole number Date: Thu, 5 Jan 2006 13:41:21 -0500 From: "Sudheer Bachu" Hi murali, You can divide the number with any number and id it is an amount edit the number while printing like Your_final_print_variable =3D edit(&calculated_number,'$$$,$$$,$$0' )=20= =20 Else it is just a number then use this PRINT $ Your_final_print_variable (0,+{col_sep},{col_amt}) edit 999 Thanks Sudheer Bachu -----Original Message----- From: sqr-users-bounces+sbachu=3Dcreditacceptance.com@sqrug.org [mailto:sqr-users-bounces+sbachu=3Dcreditacceptance.com@sqrug.org] On Behalf Of Kaithi, Murali Sent: Thursday, January 05, 2006 1:37 PM To: This list is for discussion about the SQR database reporting languagefromHyperion Solutions. Subject: [sqr-users] Rounding to the next whole number I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 From sqr-users-bounces@sqrug.org Thu Jan 05 13:56:10 2006 Subject: RE: [sqr-users] Rounding to the next whole number Date: Thu, 5 Jan 2006 13:53:43 -0500 From: "Kaithi, Murali" Sudheer, Thanks for your reply,=20 I am not trying to print the result, after I divide the number, I just want to investigate the result whether it is a whole number or not if not get the next whole number. How do I investigate the result number after dividing. Thanks, Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of Sudheer Bachu Sent: Thursday, January 05, 2006 1:41 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Hi murali, You can divide the number with any number and id it is an amount edit the number while printing like Your_final_print_variable =3D edit(&calculated_number,'$$$,$$$,$$0' )=20=20 Else it is just a number then use this PRINT $ Your_final_print_variable (0,+{col_sep},{col_amt}) edit 999 Thanks Sudheer Bachu -----Original Message----- From: sqr-users-bounces+sbachu=3Dcreditacceptance.com@sqrug.org [mailto:sqr-users-bounces+sbachu=3Dcreditacceptance.com@sqrug.org] On Behalf Of Kaithi, Murali Sent: Thursday, January 05, 2006 1:37 PM To: This list is for discussion about the SQR database reporting languagefromHyperion Solutions. Subject: [sqr-users] Rounding to the next whole number I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 Email has been scanned for all viruses by PAETEC Email Scanning Servic= es, utilizing MessageLabs proprietary SkyScan infrastructure. For more info= rmation on a proactive anti-virus service working around the clock, around = the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jan 05 14:27:34 2006 From: "Kyle Leonard" Subject: RE: [sqr-users] Rounding to the next whole number Date: Thu, 5 Jan 2006 13:27:49 -0600 Hi Murali, One way to do this is to change the number to a string, look for a decimal point in the string, copy everything after the decimal to a number variable. If it is greater than 0, it is non-whole. If it is equal to 0, whole. begin-procedure check_for_whole_nbr ( #number_in, $whole ) move #number_in to $str_nbr let #offset = instr($str_nbr, '.', 1) let #length = length($str_nbr) let $piece = substr($str_nbr, #offset, #len) move $piece to #piece if #piece > 0 $whole = 'false' else $whole = 'true' end-if end-procedure If there is a simpler way to do this, I'd like to know. I don't remember a function in SQR to do this. Kyle _________________________________________ Kyle J. Leonard Consultant 1Answer Solutions -----Original Message----- From: sqr-users-bounces+kyle.leonard=1answersolutions.com@sqrug.org [mailto:sqr-users-bounces+kyle.leonard=1answersolutions.com@sqrug.org] On Behalf Of Kaithi, Murali Sent: Thursday, January 05, 2006 12:54 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Sudheer, Thanks for your reply, I am not trying to print the result, after I divide the number, I just want to investigate the result whether it is a whole number or not if not get the next whole number. How do I investigate the result number after dividing. Thanks, Murali -----Original Message----- From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org] On Behalf Of Sudheer Bachu Sent: Thursday, January 05, 2006 1:41 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Hi murali, You can divide the number with any number and id it is an amount edit the number while printing like Your_final_print_variable = edit(&calculated_number,'$$$,$$$,$$0' ) Else it is just a number then use this PRINT $ Your_final_print_variable (0,+{col_sep},{col_amt}) edit 999 Thanks Sudheer Bachu -----Original Message----- From: sqr-users-bounces+sbachu=creditacceptance.com@sqrug.org [mailto:sqr-users-bounces+sbachu=creditacceptance.com@sqrug.org] On Behalf Of Kaithi, Murali Sent: Thursday, January 05, 2006 1:37 PM To: This list is for discussion about the SQR database reporting languagefromHyperion Solutions. Subject: [sqr-users] Rounding to the next whole number I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 From sqr-users-bounces@sqrug.org Thu Jan 05 14:06:04 2006 Subject: RE: [sqr-users] Rounding to the next whole number Date: Thu, 5 Jan 2006 14:02:29 -0500 From: "Peter Burton" Murali, mod -- Returns the fractional remainder, f, of x_value/ y_value such that x_value = i * y_value + f, where i is an integer, f has the same sign as x_value, and the absolute value of f is less than the absolute value of y_value. The arguments are promoted to the type of the greatest precision and the function returns a value of that type. Syntax: dst_var = mod(x_value, y_value) $B!|(J x_value = decimal, float, or integer literal, column, variable, or expression. $B!|(J y_value = decimal, float, or integer literal, column, variable, or expression. $B!|(J dst_var = decimal, float, or integer variable. Example: let #fmodvar = mod(#fxvar, #fyvar) Peter -----Original Message----- From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org [mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] On Behalf Of Kaithi, Murali Sent: Thursday, January 05, 2006 1:54 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Sudheer, Thanks for your reply, I am not trying to print the result, after I divide the number, I just want to investigate the result whether it is a whole number or not if not get the next whole number. How do I investigate the result number after dividing. Thanks, Murali -----Original Message----- From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org] On Behalf Of Sudheer Bachu Sent: Thursday, January 05, 2006 1:41 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Hi murali, You can divide the number with any number and id it is an amount edit the number while printing like Your_final_print_variable = edit(&calculated_number,'$$$,$$$,$$0' ) Else it is just a number then use this PRINT $ Your_final_print_variable (0,+{col_sep},{col_amt}) edit 999 Thanks Sudheer Bachu -----Original Message----- From: sqr-users-bounces+sbachu=creditacceptance.com@sqrug.org [mailto:sqr-users-bounces+sbachu=creditacceptance.com@sqrug.org] On Behalf Of Kaithi, Murali Sent: Thursday, January 05, 2006 1:37 PM To: This list is for discussion about the SQR database reporting languagefromHyperion Solutions. Subject: [sqr-users] Rounding to the next whole number I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 From sqr-users-bounces@sqrug.org Thu Jan 05 14:09:49 2006 Subject: Re: [sqr-users] Rounding to the next whole number From: Roger.Harris@certegy.com Date: Thu, 5 Jan 2006 14:06:06 -0500 Try this Let #result = Ceil(#value / 10) |---------+----------------------------------------------------> | | "Kaithi, Murali" | | | | | | Sent by: | | | sqr-users-bounces+roger.harris=certegy.co| | | m@sqrug.org | | | | | | | | | 01/05/2006 01:37 PM | | | Please respond to "This list is for | | | discussion about the SQR database | | | reporting language from Hyperion | | | Solutions." | | | | |---------+----------------------------------------------------> >----------------------------------------------------------------------------------------------| | | | To: "This list is for discussion about the SQR database reporting languagefrom | | Hyperion Solutions." | | cc: | | Subject: [sqr-users] Rounding to the next whole number | >----------------------------------------------------------------------------------------------| I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------------------------------------------------------------------------------ This message contains information from Certegy, Inc which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e:mail postmaster@certegy.com. ============================================================================== _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jan 05 14:12:49 2006 Subject: RE: [sqr-users] Rounding to the next whole number Date: Thu, 5 Jan 2006 13:06:27 -0600 From: "Bob Stone" Try truncating it, then compare the truncated value to the original. If they're not equal, then add 1 to the truncated value to get your 'rounded up' whole number. -----Original Message----- From: sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org [mailto:sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org] On Behalf Of Kaithi, Murali Sent: Thursday, January 05, 2006 12:54 PM To: This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Sudheer, Thanks for your reply,=20 I am not trying to print the result, after I divide the number, I just want to investigate the result whether it is a whole number or not if not get the next whole number. How do I investigate the result number after dividing. Thanks, Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of Sudheer Bachu Sent: Thursday, January 05, 2006 1:41 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Hi murali, You can divide the number with any number and id it is an amount edit the number while printing like Your_final_print_variable =3D edit(&calculated_number,'$$$,$$$,$$0' )=20=20 Else it is just a number then use this PRINT $ Your_final_print_variable (0,+{col_sep},{col_amt}) edit 999 Thanks Sudheer Bachu -----Original Message----- From: sqr-users-bounces+sbachu=3Dcreditacceptance.com@sqrug.org [mailto:sqr-users-bounces+sbachu=3Dcreditacceptance.com@sqrug.org] On Behalf Of Kaithi, Murali Sent: Thursday, January 05, 2006 1:37 PM To: This list is for discussion about the SQR database reporting languagefromHyperion Solutions. Subject: [sqr-users] Rounding to the next whole number I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 From sqr-users-bounces@sqrug.org Thu Jan 05 14:23:49 2006 Subject: Re: [sqr-users] Rounding to the next whole number From: JOHN_HARRIS@qvc.com Date: Thu, 5 Jan 2006 14:20:58 -0500 This is a multi-part message in MIME format... --0__=0ABBFA7EDFFB47468f9e8a93df938690918c0ABBFA7EDFFB4746 Content-type: text/plain; charset=US-ASCII You can use the ROUND function. This will return a rounded value, rounded to x decimals of precision. Example: LET #OLD_NUMBER = 36.5156 LET #NEW_NUMBER = ROUND(#OLD_NUMBER,2) Post execution value: 36.5200 Example: LET #OLD_NUMBER = 36.5156 LET #NEW_NUMBER = ROUND(#OLD_NUMBER,0) Post execution value: 37.0000 Thank you. Regards, John (Embedded image moved John Harris to file: Programmer/Analyst pic28703.jpg) Application Development - Internal QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262 Telephone 484-701-3303 Fax 484-701-8689 e-mail jharris@qvc.com This message may contain information that is privileged or confidential. This message may contain information that is privileged or confidential. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. |---------+-----------------------------------------------> | | "Kaithi, Murali" | | | | | | Ext: | | | Sent by: | | | sqr-users-bounces+john_harris=qvc.co| | | m@sqrug.org | | | | | | | | | 01/05/2006 01:37 PM | | | Please respond to "This list is for | | | discussion about the SQR database | | | reporting language from | | | Hyperion Solutions." | | | | |---------+-----------------------------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: "This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions." | | | | cc: (bcc: JOHN HARRIS/QVC) | | Subject: [sqr-users] Rounding to the next whole number | >------------------------------------------------------------------------------------------------------------------------------| I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --0__=0ABBFA7EDFFB47468f9e8a93df938690918c0ABBFA7EDFFB4746 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'image/jpeg' MIME type. It has been automatically discarded before sending the message to the list. --0__=0ABBFA7EDFFB47468f9e8a93df938690918c0ABBFA7EDFFB4746 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --0__=0ABBFA7EDFFB47468f9e8a93df938690918c0ABBFA7EDFFB4746-- From sqr-users-bounces@sqrug.org Thu Jan 05 14:37:34 2006 Subject: RE: [sqr-users] Rounding to the next whole number Date: Thu, 5 Jan 2006 14:35:05 -0500 From: "Kaithi, Murali" John, Thanks for the reply, Your second example is what I want but wouldn't it give me 36 if the #OLD_NUMBER is 36.4156 but I still want 37. Thanks, Murali -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of JOHN_HARRIS@qvc.com Sent: Thursday, January 05, 2006 2:21 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Rounding to the next whole number You can use the ROUND function. This will return a rounded value, rounded to x decimals of precision. Example: LET #OLD_NUMBER =3D 36.5156 LET #NEW_NUMBER =3D ROUND(#OLD_NUMBER,2) Post execution value: 36.5200 Example: LET #OLD_NUMBER =3D 36.5156 LET #NEW_NUMBER =3D ROUND(#OLD_NUMBER,0) Post execution value: 37.0000 =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20 =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20 Thank you.=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20 =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20 Regards,=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20 =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20 John=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20 =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20 =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20 =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20 (Embedded image moved John Harris=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20 to file: Programmer/Analyst=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20 pic28703.jpg) Application Development - Internal=20=20 =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20 QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262 Telephone 484-701-3303 Fax 484-701-8689 e-mail jharris@qvc.com This message may contain information that is privileged or confidential. This message may contain information that is privileged or confidential. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. |---------+-----------------------------------------------> | | "Kaithi, Murali" | | | | | | Ext: | | | Sent by: | | | sqr-users-bounces+john_harris=3Dqvc.co| | | m@sqrug.org | | | | | | | | | 01/05/2006 01:37 PM | | | Please respond to "This list is for | | | discussion about the SQR database | | | reporting language from | | | Hyperion Solutions." | | | | |---------+-----------------------------------------------> =20 >----------------------------------------------------------------------- -------------------------------------------------------| | | | To: "This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions." | | | | cc: (bcc: JOHN HARRIS/QVC) | | Subject: [sqr-users] Rounding to the next whole number | =20 >----------------------------------------------------------------------- -------------------------------------------------------| I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Servic= es, utilizing MessageLabs proprietary SkyScan infrastructure. For more info= rmation on a proactive anti-virus service working around the clock, around = the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jan 05 14:41:12 2006 Subject: RE: [sqr-users] Rounding to the next whole number Date: Thu, 5 Jan 2006 14:37:44 -0500 From: "Kaithi, Murali" Kyle, Thank you very much for your resolution. I guess I will go with this unless I find a easier or smaller code. Thanks again, Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of Kyle Leonard Sent: Thursday, January 05, 2006 2:28 PM To: 'This list is for discussion about the SQR database reportinglanguagefrom Hyperion Solutions.' Subject: RE: [sqr-users] Rounding to the next whole number Hi Murali, One way to do this is to change the number to a string, look for a decimal point in the string, copy everything after the decimal to a number variable. If it is greater than 0, it is non-whole. If it is equal to 0, whole. begin-procedure check_for_whole_nbr ( #number_in, $whole ) move #number_in to $str_nbr let #offset =3D instr($str_nbr, '.', 1) let #length =3D length($str_nbr) let $piece =3D substr($str_nbr, #offset, #len) move $piece to #piece if #piece > 0 $whole =3D 'false' else $whole =3D 'true' end-if end-procedure If there is a simpler way to do this, I'd like to know. I don't remember a function in SQR to do this. Kyle _________________________________________ Kyle J. Leonard Consultant 1Answer Solutions -----Original Message----- From: sqr-users-bounces+kyle.leonard=3D1answersolutions.com@sqrug.org [mailto:sqr-users-bounces+kyle.leonard=3D1answersolutions.com@sqrug.org] On Behalf Of Kaithi, Murali Sent: Thursday, January 05, 2006 12:54 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Sudheer, Thanks for your reply, I am not trying to print the result, after I divide the number, I just want to investigate the result whether it is a whole number or not if not get the next whole number. How do I investigate the result number after dividing. Thanks, Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of Sudheer Bachu Sent: Thursday, January 05, 2006 1:41 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Hi murali, You can divide the number with any number and id it is an amount edit the number while printing like Your_final_print_variable =3D edit(&calculated_number,'$$$,$$$,$$0' )=20=20 Else it is just a number then use this PRINT $ Your_final_print_variable (0,+{col_sep},{col_amt}) edit 999 Thanks Sudheer Bachu -----Original Message----- From: sqr-users-bounces+sbachu=3Dcreditacceptance.com@sqrug.org [mailto:sqr-users-bounces+sbachu=3Dcreditacceptance.com@sqrug.org] On Behalf Of Kaithi, Murali Sent: Thursday, January 05, 2006 1:37 PM To: This list is for discussion about the SQR database reporting languagefromHyperion Solutions. Subject: [sqr-users] Rounding to the next whole number I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 Email has been scanned for all viruses by PAETEC Email Scanning Servic= es, utilizing MessageLabs proprietary SkyScan infrastructure. For more info= rmation on a proactive anti-virus service working around the clock, around = the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jan 05 14:48:47 2006 Date: Thu, 05 Jan 2006 14:46:41 -0500 From: don.barclay@srs.gov Subject: RE: [sqr-users] Rounding to the next whole number Uh, what's wrong with Roger's solution?: Let #result = Ceil(#value / 10) Don't get much simpler than that. Don sqr-users-bounces+don.barclay=srs.gov@sqrug.org wrote on 01/05/2006 02:37:44 PM: > Kyle, > Thank you very much for your resolution. I guess I will go with this > unless I find a easier or smaller code. > > Thanks again, > Murali _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jan 05 15:12:51 2006 From: "Kyle Leonard" Subject: RE: [sqr-users] Rounding to the next whole number Date: Thu, 5 Jan 2006 14:04:08 -0600 There you go...I thought there was a function. Kyle _________________________________________ Kyle J. Leonard Consultant 1Answer Solutions -----Original Message----- From: sqr-users-bounces+kyle.leonard=1answersolutions.com@sqrug.org [mailto:sqr-users-bounces+kyle.leonard=1answersolutions.com@sqrug.org] On Behalf Of don.barclay@srs.gov Sent: Thursday, January 05, 2006 1:47 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Uh, what's wrong with Roger's solution?: Let #result = Ceil(#value / 10) Don't get much simpler than that. Don sqr-users-bounces+don.barclay=srs.gov@sqrug.org wrote on 01/05/2006 02:37:44 PM: > Kyle, > Thank you very much for your resolution. I guess I will go with this > unless I find a easier or smaller code. > > Thanks again, > Murali _______________________________________________ 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 From sqr-users-bounces@sqrug.org Thu Jan 05 14:58:52 2006 Subject: RE: [sqr-users] Rounding to the next whole number Date: Thu, 5 Jan 2006 13:51:44 -0600 From: "Bob Stone" I concur. Divide your number by ten and round up. If it's a whole number, you didn't change it (15 ceilings to 15, for example). short sweet and to the point. -----Original Message----- From: sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org [mailto:sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org] On Behalf Of don.barclay@srs.gov Sent: Thursday, January 05, 2006 1:47 PM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Uh, what's wrong with Roger's solution?: Let #result =3D Ceil(#value / 10) Don't get much simpler than that. Don sqr-users-bounces+don.barclay=3Dsrs.gov@sqrug.org wrote on 01/05/2006=20 02:37:44 PM: > Kyle, > Thank you very much for your resolution. I guess I will go with this > unless I find a easier or smaller code. >=20 > Thanks again, > Murali=20 _______________________________________________ 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 From sqr-users-bounces@sqrug.org Thu Jan 05 14:55:10 2006 Subject: RE: [sqr-users] Rounding to the next whole number Date: Thu, 5 Jan 2006 14:51:56 -0500 From: "Kaithi, Murali" Don, I am sorry there is nothing wrong with Roger's solution, it's just I didn't understand Ceil Could you or Roger tell me what is this and where It's coming from. Thanks Roger for replying. Thanks, Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of don.barclay@srs.gov Sent: Thursday, January 05, 2006 2:47 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Uh, what's wrong with Roger's solution?: Let #result =3D Ceil(#value / 10) Don't get much simpler than that. Don sqr-users-bounces+don.barclay=3Dsrs.gov@sqrug.org wrote on 01/05/2006 02:37:44 PM: > Kyle, > Thank you very much for your resolution. I guess I will go with this > unless I find a easier or smaller code. >=20 > Thanks again, > Murali=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Servic= es, utilizing MessageLabs proprietary SkyScan infrastructure. For more info= rmation on a proactive anti-virus service working around the clock, around = the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jan 05 15:05:32 2006 Date: Thu, 05 Jan 2006 14:55:44 -0500 From: don.barclay@srs.gov Subject: RE: [sqr-users] Rounding to the next whole number Ceiling - returns a value representing the smallest integer that is greater than or equal to a value. Exactly what you are looking for. Don sqr-users-bounces+don.barclay=srs.gov@sqrug.org wrote on 01/05/2006 02:51:56 PM: > Don, > I am sorry there is nothing wrong with Roger's solution, it's just I > didn't understand Ceil > Could you or Roger tell me what is this and where It's coming from. > Thanks Roger for replying. > > Thanks, > Murali _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jan 05 15:02:19 2006 Subject: RE: [sqr-users] Rounding to the next whole number From: Roger.Harris@certegy.com Date: Thu, 5 Jan 2006 14:52:58 -0500 I stand by my previous post. The Ceiling function returns the smallest integer that is greater than or equal to the value, thus Let #result = Ceil(#value / 10) For #value = 100 => #result = 10 For #value > 100 and <= 110 => #result = 11 For #value > 110 and <= 120 => #result = 12 etc This is the most straight forward solution. Roger |---------+----------------------------------------------------> | | "Kaithi, Murali" | | | | | | Sent by: | | | sqr-users-bounces+roger.harris=certegy.co| | | m@sqrug.org | | | | | | | | | 01/05/2006 02:35 PM | | | Please respond to "This list is for | | | discussion about the SQR database | | | reporting language from Hyperion | | | Solutions." | | | | |---------+----------------------------------------------------> >----------------------------------------------------------------------------------------------| | | | To: "This list is for discussion about the SQR database reportinglanguage from | | Hyperion Solutions." | | cc: | | Subject: RE: [sqr-users] Rounding to the next whole number | >----------------------------------------------------------------------------------------------| John, Thanks for the reply, Your second example is what I want but wouldn't it give me 36 if the #OLD_NUMBER is 36.4156 but I still want 37. Thanks, Murali -----Original Message----- From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org] On Behalf Of JOHN_HARRIS@qvc.com Sent: Thursday, January 05, 2006 2:21 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Rounding to the next whole number You can use the ROUND function. This will return a rounded value, rounded to x decimals of precision. Example: LET #OLD_NUMBER = 36.5156 LET #NEW_NUMBER = ROUND(#OLD_NUMBER,2) Post execution value: 36.5200 Example: LET #OLD_NUMBER = 36.5156 LET #NEW_NUMBER = ROUND(#OLD_NUMBER,0) Post execution value: 37.0000 Thank you. Regards, John (Embedded image moved John Harris to file: Programmer/Analyst pic28703.jpg) Application Development - Internal QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262 Telephone 484-701-3303 Fax 484-701-8689 e-mail jharris@qvc.com This message may contain information that is privileged or confidential. This message may contain information that is privileged or confidential. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. |---------+-----------------------------------------------> | | "Kaithi, Murali" | | | | | | Ext: | | | Sent by: | | | sqr-users-bounces+john_harris=qvc.co| | | m@sqrug.org | | | | | | | | | 01/05/2006 01:37 PM | | | Please respond to "This list is for | | | discussion about the SQR database | | | reporting language from | | | Hyperion Solutions." | | | | |---------+-----------------------------------------------> >----------------------------------------------------------------------- -------------------------------------------------------| | | | To: "This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions." | | | | cc: (bcc: JOHN HARRIS/QVC) | | Subject: [sqr-users] Rounding to the next whole number | >----------------------------------------------------------------------- -------------------------------------------------------| I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------------------------------------------------------------------------------ This message contains information from Certegy, Inc which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e:mail postmaster@certegy.com. ============================================================================== _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jan 05 15:09:38 2006 Subject: RE: [sqr-users] Rounding to the next whole number From: JOHN_HARRIS@qvc.com Date: Thu, 5 Jan 2006 14:56:58 -0500 This is a multi-part message in MIME format... --0__=0ABBFA7EDFFE0F268f9e8a93df938690918c0ABBFA7EDFFE0F26 Content-type: text/plain; charset=US-ASCII CEIL returns the smallest integer that is greater than or equal to the number provided. Thank you. Regards, John (Embedded image moved John Harris to file: Programmer/Analyst pic30333.jpg) Application Development - Internal QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262 Telephone 484-701-3303 Fax 484-701-8689 e-mail jharris@qvc.com This message may contain information that is privileged or confidential. This message may contain information that is privileged or confidential. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. --0__=0ABBFA7EDFFE0F268f9e8a93df938690918c0ABBFA7EDFFE0F26 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'image/jpeg' MIME type. It has been automatically discarded before sending the message to the list. --0__=0ABBFA7EDFFE0F268f9e8a93df938690918c0ABBFA7EDFFE0F26 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --0__=0ABBFA7EDFFE0F268f9e8a93df938690918c0ABBFA7EDFFE0F26-- From sqr-users-bounces@sqrug.org Thu Jan 05 15:16:14 2006 Subject: RE: [sqr-users] Rounding to the next whole number Date: Thu, 5 Jan 2006 15:05:10 -0500 From: "Kaithi, Murali" Thank you Roger, I appreciate your help. Thanks, Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of Roger.Harris@certegy.com Sent: Thursday, January 05, 2006 2:53 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number I stand by my previous post. The Ceiling function returns the smallest integer that is greater than or equal to the value, thus Let #result =3D Ceil(#value / 10) For #value =3D 100 =3D> #result =3D 10 For #value > 100 and <=3D 110 =3D> #result =3D 11 For #value > 110 and <=3D 120 =3D> #result =3D 12 etc This is the most straight forward solution. Roger |---------+----------------------------------------------------> | | "Kaithi, Murali" | | | | | | Sent by: | | | sqr-users-bounces+roger.harris=3Dcertegy.co| | | m@sqrug.org | | | | | | | | | 01/05/2006 02:35 PM | | | Please respond to "This list is for | | | discussion about the SQR database | | | reporting language from Hyperion | | | Solutions." | | | | |---------+----------------------------------------------------> =20 >----------------------------------------------------------------------- -----------------------| | | | To: "This list is for discussion about the SQR database reportinglanguage from | | Hyperion Solutions." | | cc: | | Subject: RE: [sqr-users] Rounding to the next whole number | =20 >----------------------------------------------------------------------- -----------------------| John, Thanks for the reply, Your second example is what I want but wouldn't it give me 36 if the #OLD_NUMBER is 36.4156 but I still want 37. Thanks, Murali -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of JOHN_HARRIS@qvc.com Sent: Thursday, January 05, 2006 2:21 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Rounding to the next whole number You can use the ROUND function. This will return a rounded value, rounded to x decimals of precision. Example: LET #OLD_NUMBER =3D 36.5156 LET #NEW_NUMBER =3D ROUND(#OLD_NUMBER,2) Post execution value: 36.5200 Example: LET #OLD_NUMBER =3D 36.5156 LET #NEW_NUMBER =3D ROUND(#OLD_NUMBER,0) Post execution value: 37.0000 Thank you. Regards, John (Embedded image moved John Harris to file: Programmer/Analyst pic28703.jpg) Application Development - Internal QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262 Telephone 484-701-3303 Fax 484-701-8689 e-mail jharris@qvc.com This message may contain information that is privileged or confidential. This message may contain information that is privileged or confidential. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. |---------+-----------------------------------------------> | | "Kaithi, Murali" | | | | | | Ext: | | | Sent by: | | | sqr-users-bounces+john_harris=3Dqvc.co| | | m@sqrug.org | | | | | | | | | 01/05/2006 01:37 PM | | | Please respond to "This list is for | | | discussion about the SQR database | | | reporting language from | | | Hyperion Solutions." | | | | |---------+-----------------------------------------------> >----------------------------------------------------------------------- -------------------------------------------------------| | | | To: "This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions." | | | | cc: (bcc: JOHN HARRIS/QVC) | | Subject: [sqr-users] Rounding to the next whole number | >----------------------------------------------------------------------- -------------------------------------------------------| I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------------------------------------------------------------------------ ------ This message contains information from Certegy, Inc which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e:mail postmaster@certegy.com. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=3D _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Servic= es, utilizing MessageLabs proprietary SkyScan infrastructure. For more info= rmation on a proactive anti-virus service working around the clock, around = the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jan 06 06:32:15 2006 Subject: RE: [sqr-users] Rounding to the next whole number Date: Fri, 6 Jan 2006 06:29:07 -0500 From: "Bob Buford" Hi Kaithi, I haven't used this, but it is in the SQR Commands list: ceil Returns a value representing the smallest integer that is greater than or equal to num_value. This function returns a value of the same type as num_value.Syntax: dst_var =3D ceil(num_value) num_value =3D decimal, float, or integer literal, column, variable, or expression. dst_var =3D decimal, float, or integer variable. Example: let #fceilvar =3D ceil(#fvar) There's also a command "floor" which works in the opposite manner (largest integer smaller than or equal to num_value). Bob=20 -----Original Message----- From: Kaithi, Murali [mailto:Murali.Kaithi@spencergifts.com]=20 Sent: Thursday, January 05, 2006 1:54 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Sudheer, Thanks for your reply, I am not trying to print the result, after I divide the number, I just want to investigate the result whether it is a whole number or not if not get the next whole number. How do I investigate the result number after dividing. Thanks, Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of Sudheer Bachu Sent: Thursday, January 05, 2006 1:41 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number Hi murali, You can divide the number with any number and id it is an amount edit the number while printing like Your_final_print_variable =3D edit(&calculated_number,'$$$,$$$,$$0' )=20=20 Else it is just a number then use this PRINT $ Your_final_print_variable (0,+{col_sep},{col_amt}) edit 999 Thanks Sudheer Bachu -----Original Message----- From: sqr-users-bounces+sbachu=3Dcreditacceptance.com@sqrug.org [mailto:sqr-users-bounces+sbachu=3Dcreditacceptance.com@sqrug.org] On Behalf Of Kaithi, Murali Sent: Thursday, January 05, 2006 1:37 PM To: This list is for discussion about the SQR database reporting languagefromHyperion Solutions. Subject: [sqr-users] Rounding to the next whole number I have to divide a number by 10 and if the resulting number is not a whole number, I have to Round up to the next whole number. How can I accomplish this? Appreciate your response. Thanks, Murali ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jan 06 09:08:22 2006 Subject: RE: [sqr-users] Rounding to the next whole number Date: Fri, 6 Jan 2006 09:06:06 -0500 From: "Kaithi, Murali" Roger, Thanks for your reply, I applied it and it's working perfectly. Thanks for everybody else for kind responses. I think I need to brush up my SQR skills now to dig new cool functions like this. Thanks, Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of Roger.Harris@certegy.com Sent: Thursday, January 05, 2006 2:53 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] Rounding to the next whole number I stand by my previous post. The Ceiling function returns the smallest integer that is greater than or equal to the value, thus Let #result =3D Ceil(#value / 10) For #value =3D 100 =3D> #result =3D 10 For #value > 100 and <=3D 110 =3D> #result =3D 11 For #value > 110 and <=3D 120 =3D> #result =3D 12 etc This is the most straight forward solution. Roger |---------+----------------------------------------------------> | | "Kaithi, Murali" | | | | | | Sent by: | | | sqr-users-bounces+roger.harris=3Dcertegy.co| | | m@sqrug.org | | | | | | | | | 01/05/2006 02:35 PM | | | Please respond to "This list is for | | | discussion about the SQR database | | | reporting language from Hyperion | | | Solutions." | | | | |---------+----------------------------------------------------> =20 >----------------------------------------------------------------------- -----------------------| | | | To: "This list is for discussion about the SQR database reportinglanguage from | | Hyperion Solutions." | | cc: | | Subject: RE: [sqr-users] Rounding to the next whole number | =20 >----------------------------------------------------------------------- -----------------------| John, Thanks for the reply, Your second example is what I want but wouldn't it give me 36 if the #OLD_NUMBER is 36.4156 but I still want 37. Thanks, Murali -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of JOHN_HARRIS@qvc.com Sent: Thursday, January 05, 2006 2:21 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Rounding to the next whole number You can use the ROUND function. This will return a rounded value, rounded to x decimals of precision. Example: LET #OLD_NUMBER =3D 36.5156 LET #NEW_NUMBER =3D ROUND(#OLD_NUMBER,2) Post execution value: 36.5200 Example: LET #OLD_NUMBER =3D 36.5156 LET #NEW_NUMBER =3D ROUND(#OLD_NUMBER,0) Post execution value: 37.0000 Thank you. Regards, John (Embedded image moved John Harris to file: Programmer/Analyst pic28703.jpg) Application Development - Internal QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262 Telephone 484-701-3303 Fax 484-701-8689 e-mail jharris@qvc.com This message may contain information that is privileged or confidential. This message may contain information that is