Inspiring

Question

Validating comma-delimited list for numeric entries

Forum|Forum|11 years ago
December 16, 2014
3 replies
1410 views

Hi!

I need to validate a comma-delimited list to make sure all the list items are numeric. I could do a cfloop to loop through the list, then an IsValid() to check each entry, but that seems cumbersome, so I was wondering if there was a better way.

Thanks!

This topic has been closed for replies.

S

Steve Sommers

Legend

You could also do a simple regular expression check:

<--- good --->

</cfif>

James Moberg

Inspiring

The regex is too simple in the case of decimal or negative values, but would probably work well with simple positive integers. The isNumericList UDF uses VAL and then compares each values. The justNumericList filters out non-numeric values so that only numeric values remain in the list.

BKBK

Community Expert

@Jamo

Fltering out non-numerical values is undoutedly a commendable solution. However, it introduces new business logic into the situation.

The original poster had 2 requirements: 1) a means of validating a list by detecting any non-numerical list element in it; 2) a creative way of doing so, which involves fewer steps than looping through the list.

James Moberg

Inspiring

I recommend using the CFLib isNumericList() UDF from 2002:

http://www.cflib.org/udf/isNumericList

BreakawayPaulAuthor

Inspiring

I had the idea to just do a replace() to get rid of all the commas and treat the value as one big number. It seems to work.

BKBK

Community Expert

BreakawayPaul wrote:

I had the idea to just do a replace() to get rid of all the commas and treat the value as one big number. It seems to work.

True. That is a creative test. But what if the list begins with 0 or contains negative or decimal numbers?

If you must include those such eventualities, then you could extend the test to something like

<cftry>

<cfoutput>#cfcatch.Detail#</cfoutput>

</cfcatch>

</cftry>

BreakawayPaulAuthor

Inspiring

Aside from the original problem, your reply was helpful because I've never before considered a try/catch around anything but a query. Now I have a whole new bunch of things to try it on.

As far as expecting zeros and negative values, I don't really, because these values come from a form. That said, the point of this is to validate the input, so anything non-numeric needs to be rejected. What I've done for now is to force cfsqltype of numeric, then use a try/catch to trap the error if it's not. I suppose both methods work about equally well.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded