Larry,
Since you're using static text anyway, how about
(SKEEP(CurrencyString,'1234567890.-')) (string keep):
*(SKEEP(**source**, **chars**))*
Keeps characters within the *source *string, using *chars* as a comparison.
This function is CASE SENSITIVE.
In the following example, the value of *vskeep* is *ldilliamennighway.*
SET VAR vskeep = (SKEEP('3935 Old William Penn
Highway','abcdefghijklmnopqrstuvwxyz'))
Spaces are also recognized.
In the following example, the value of *vskeep2* is *ld illiam enn ighway.*
SET VAR vskeep2 = (SKEEP('3935 Old William Penn Highway','
abcdefghijklmnopqrstuvwxyz'))
On Fri, Apr 17, 2009 at 7:38 AM, Lawrence Lustig <[email protected]>wrote:
> I'm writing a form on which I want to display a bunch of currency figures
> (aged payables and receivables) without the dollar sign or any decimals.
> That is $421,187.16 should display as 421,187 with no decimal. I'm
> retrieving the values with SELECT and placing them into static text labels
> using PROPERTY CAPTION. . .
>
> I figured the easiest way would be to change the CURRENCY setting to have
> no decimals (SET CURR ' ' PREF 0 B), but this has the effect of retrieving
> the whole number and shifting the decimal to places, multiplying all the
> numbers by 100.
>
> So far, the best I can find is (ROUND(FLOAT(CurrColumn, 0))).
>
> Has anyone done this before?
> --
> Larry
>
>
