This is still allowing me to enter text into the field as well as numbers. It is getting closer though - I will post whatever Remedy tells me when I hear back. Thanks for the help.
Sue -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rabi Tripathi Sent: Friday, March 30, 2007 12:33 PM To: [email protected] Subject: Re: Validate field data - allowing some to be NULL Sue: I am not sure why you gave up on the character field. Did you try the qualification I sent? Using that or a variaion of it, you can keep the character field and be in complete control of the type of message the user gets. Here's a refined scheme: First do the following Set Field... RTRIM( LTRIM( 'Requested storage amount in GB: ')) ...on field 'Requested storage amount in GB: ' to remove leading and trailing blank characters and then use the qualification: ( 'Requested storage amount in GB: ' LIKE "*[^.0-9]*" ) OR ( 'Requested storage amount in GB: ' LIKE "*.*.*" ) OR ( 'Requested storage amount in GB: ' = "." ) on a filter to throw the error. If the field won't be used in a numeric calculation, there is no harm in keeping it as a character field. --- "Barber, Sue" <[EMAIL PROTECTED]> wrote: > I think I will have to go with changing the field - > I still have to > throw an error though - they don't want the system > message. I was > hoping not to change the field as this is already in > use. > > Thanks, Sue > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Rabi > Tripathi > Sent: Friday, March 30, 2007 11:04 AM > To: [email protected] > Subject: Re: Validate field data - allowing some to > be NULL > > If you insist on keeaping the character field, try: > ( 'Requested storage amount in GB: ' LIKE > "*[^.0-9]*" > ) OR ( 'Requested storage amount in GB: ' LIKE > "*.*.*" )...then throw error > > You can play around and make it smarter by allowing > leading or trailing spaces, disallowing "." etc. > > -Rabi Tripathi > > --- "Barber, Sue" <[EMAIL PROTECTED]> wrote: > > > Hi all, > > > > > > > > I have a question for you on validating field > data. > > I did search the > > archives and it isn't allowing me to open the > notes > > - says file not > > found, sooo... > > > > > > > > I have a form that people can use to request > > additional network space > > with and the field in question is for them to > enter > > the amount of space > > in GB that they want. I originally had the field > > limited with $DIGIT$, > > but when they made a mistake the entire form was > > being reset. They > > decided they would like a message to be used > > instead, so I have created > > a filter that verifies the field as such: > > > > > > > > ( 'Requested storage amount in GB: ' != $NULL$ ) > > AND ( NOT ( > > 'Requested storage amount in GB: ' LIKE > > "[.0-9][.0-9][.0-9] > > [.0-9][.0-9]")) > > > > > > > > However, I don't want to force them to enter a > > number into all 5 > > spaces, so I need to allow 4 of these to be NULL. > > Anyone know if there > > is a way to do that? They want to be able to > enter > > numbers or > > decimals - like 2 or 2.5. > > > > > > > > Thanks, Sue > > > > > > > > ARS 6.3 - patch 20 > > > > Solaris > > > > Help Desk 6 > > > > > > > > > > > _______________________________________________________________________ > ________ > > UNSUBSCRIBE or access ARSlist Archives at > > www.arslist.org ARSlist:"Where the Answers Are" > > > > > > > _______________________________________________________________________ > _____________ > Expecting? Get great news right away with email > Auto-Check. > Try the Yahoo! Mail Beta. > http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html > > > _______________________________________________________________________ > ________ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org > ARSlist:"Where the Answers Are" > > _______________________________________________________________________ ________ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org ARSlist:"Where the Answers Are" > _______________________________________________________________________ _____________ Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. http://autos.yahoo.com/green_center/ _______________________________________________________________________ ________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
