Robert Presender wrote:
> On Apr 10, 2005, at 9:00 AM, Richard Gaskin wrote:
>
>> I need to evaluate a large number of short strings to
>> determine whether they are numeric. Some of these are
>> percentages, and include the "%", and others are
>> currency and can contain "$". the Euro, Yen, or an
I just found in my stack folder a currency number formatting stack.
There is no author, no about, no idea who made it.
But it came from my external stacks.
The idea is that if you can make a parser to make a currency format of any
kind, this process
can be easily reversed to do the opposite...
Hi Richard:
I put the following into the msg box
put "12%" into holder
put holder is a number
The above returns returns false
Regards Bob
On Apr 10, 2005, at 9:00 AM, Richard Gaskin wrote:
I need to evaluate a large number of short strings to determine whether
they are numeric. Some of these
Richard,
You could add zero to it and see if you get an error.
Since currency signs are usually the first of last character, you could strip
the first or last character after using the zero test above, then test for
zero again.
Or make a list of all major currencies and see if the first or last cha
Richard,
You could add zero to it and see if you get an error.
Since currency signs are usually the first of last character, you could strip
the first or last character after using the zero test above, then test for
zero again.
Or make a list of all major currencies and see if the first or last c
On Apr 10, 2005, at 9:03 AM, Richard Gaskin wrote:
I need to evaluate a large number of short strings to determine
whether they are numeric. Some of these are percentages, and include
the "%", and others are currency and can contain "$". the Euro, Yen,
or any number of other signs.
If this is a
Hi Richard,
A post by Thierry Douez (Rép : Seperate numbers from text Date: 6 avril
2005 10:18:44 GMT+02:00) might get you started:
Hi,
DR> Is there a way to seperate numbers from text in a string?
DR> e.g "string69" to return 69 or "string69also" to return 69
try this :
put "asdfsdfsdf765xcxcc
in
> Sent: Sunday, April 10, 2005 17:03
> To: How to use Revolution
> Subject: Currency and percentage in numeric evaluation
>
> I need to evaluate a large number of short strings to
> determine whether they are numeric. Some of these are
> percentages, and include the &
I need to evaluate a large number of short strings to determine whether
they are numeric. Some of these are percentages, and include the "%",
and others are currency and can contain "$". the Euro, Yen, or any
number of other signs.
With dates we have a convenient test: try to convert it, and