This should do it for you. Returns 1 if anything but numeric, comma or
decimal is in the field:
reFind("[^[:digit:].,]",yourVariable)
On 1/8/07, Roberto Perez <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I have to display an alphanumeric field that may contain numbers (e.g.,
> GPA's) or text (e.g., "n/a"). I have no control over the input form, or
> the database, so I have to work with whatever I'm given access to.
>
> So, to format the display of that field, and hoping that the field will
> contain a GPA, I have the following:
>
> numberFormat(GPA, '9.999')
>
> This works fine as long as the field has a number. For those cases were
> the field can contain text, e.g., a "n/a" string, I tried to use the
> following:
> <cfif isNumeric("GPA")>#numberFormat(GPA, '9.999')#<cfelse>#GPA#</cfif>
>
> Obviously, this always displays the CFELSE portion because the original
> field is not numeric.
>
> So my question is, how can I check that all characters in the field are
> numbers (between 0 to 9) and a comma or a dot, so that I can apply the
> numberFormat part? (rememer I don't have access to editing the table, so I
> cannot make the field a numeric one per se, which would be the best
> solution).
>
> Any ideas or suggestions are welcome.
>
> Regards,
>
> Roberto Perez
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266002
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
