Thanks, Albert. I will watch out for that! I just need to convert the number to a text value to create a report heading, then can switch the currency settings back after generating the header variable and before actually running the report.
Jan ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, February 08, 2005 5:24 PM Subject: [RBG7-L] - RE: Converting Integers to Text Value > Jan - watch out when changing the currency decimal setting. If you change a currency setting from > 2 decimals to none, you will multiply everything by 100. You can change the prefix and delimiters, > but NOT the decimals. > > --- Jan Barley <[EMAIL PROTECTED]> wrote: > > > Thanks, Dawn, James and Mike. > > I did know about the dwrd command. I tried locating the first space in the > > string and sgetting the chars before the space and got all kinds of whacky > > error messages (out of internal space to process, etc.). I think changing > > the currency settings temporarily may be the best route! > > Thanks again for all the input! > > Jan > > > > ----- Original Message ----- > > From: "Dawn Oakes" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[email protected]> > > Sent: Tuesday, February 08, 2005 12:50 PM > > Subject: [RBG7-L] - RE: Converting Integers to Text Value > > > > > > Jan FYI > > I was fooling around with this too. Probably a currency setting or > > something, but my (dwrd(var)) looks like six and 00/100 . So you'd have > > to substitute the ' dollars and zero cents' with whatever you may get in > > the (SRPL....) function. > > > > -----Original Message----- > > From: James Hageman [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, February 08, 2005 12:27 PM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - RE: Converting Integers to Text Value > > > > Try something like ... > > > > set var v1 text= '6' > > set var v1 = (dwrd(.v1)) > > set var v = (SRPL(.v1,' dollars and zero cents',NULL,0)) > > > > > > James > > > > > > > > > > > > > > > > select inwgt,'The value for in weight is ' & (DWRD(inwgt)) & 'pounds' > > > from prodmast > > > > > > will produce this: > > > > > > inwgt ('The value for in weight is ' & (DWRD(inwgt > > > > > > --------- > > > ----------------------------------------------------------------- > > > > > > 126 The value for in weight is one hundred twenty-six pounds > > > 126 The value for in weight is one hundred twenty-six pounds > > > 126 The value for in weight is one hundred twenty-six pounds > > > 126 The value for in weight is one hundred twenty-six pounds > > > 126 The value for in weight is one hundred twenty-six pounds > > > > > > > > > > > > > Is there an RBase function to convert an integer to its text > > > equivalent? I want a report to write out "For the six months > > > ending..." rather than "For the 6 months ending". Have I overlooked a > > function? > > > Thanks. > > > Jan > > > > > > > > > > > > > ===== > Albert Berry > Management Consultant > RR2 - 1252 Ponderosa Drive > Sparwood BC, V0B 2G2 > Canada > (250) 425-5806 > (250) 425-7259 > (708) 575-3952 (fax) > [EMAIL PROTECTED] > >
