Advertisement

12.14.2007 at 02:22PM PST, ID: 23024794
[x]
Attachment Details

Rounding a number and then concatenating it to a string

Asked by AFSCOPS in Miscellaneous Programming, Oracle 7.x

Tags: concatenate, number, rounding, sqr, string

Hello

I am leveraging an SQR script to create an XML document. I added some code to give me delimiters that I extract with a parser I have built (with the help of some EE gurus)

This is the SQR code:

    let $XML_TMP = #Item_Bal_Amt
    let $XML_Item_Bal_Amt = '|item-bal-amt|3|' || $XML_TMP
    print $XML_Item_Bal_Amt        (0)
    !print #Item_Bal_Amt             (+1, #Bal_Col) edit 999,999.00

This is a sample result:

    &a3420v4712H|subscription-total|3|25.000000000000000

I need to round (not trunc) the #Item_Bal_Amt variable and get it into the string.
I tried to look up concat() masking techniques, but there is too much crap on the internet, and  couldn't find what I was after.

Could someone help out with this?
Start Free Trial
 
 
[+][-]12.15.2007 at 06:25AM PST, ID: 20477481

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.17.2007 at 08:10AM PST, ID: 20485729

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.17.2007 at 09:01AM PST, ID: 20486094

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.17.2007 at 09:13AM PST, ID: 20486220

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.17.2007 at 09:18AM PST, ID: 20486246

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.28.2007 at 07:40AM PST, ID: 20542539

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.28.2007 at 07:40AM PST, ID: 20542542

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.29.2007 at 12:51PM PST, ID: 20548999

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Miscellaneous Programming, Oracle 7.x
Tags: concatenate, number, rounding, sqr, string
Sign Up Now!
Solution Provided By: jinesh_kamdar
Participating Experts: 1
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628