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]
