In the Admin tool, the character used to show up as a wide pipe character. That's probably what you are thinking of.
Fred ----- Original Message ----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Susan Palmer Sent: Wednesday, August 22, 2012 6:29 PM To: arslist@ARSLIST.ORG Subject: Re: Data validation in character fields ** Hi Fred, That would have never crossed my mine. I tried using a pipe character, seems I've done that before but maybe it just showed up that way when doing email type filters. I will give this a try and let you know how it goes! Thanks! Susan ----- Original Message ----- On Wed, Aug 22, 2012 at 6:20 PM, Grooms, Frederick W wrote: ** You probably will have to use 2 filters Filter 1 Set a DisplayOnly field to the Carriage Return using SQL (for the list I am calling it zCarriageReturn) SQL = SELECT chr(10) from DUAL Filter 2 Run-If to show error 'FieldToCheck' Like (("%" + $zCarriageReturn$) + "%") I know some people will say to just use a Return inside 2 double quotes, but that will not always work. The method above will always work Fred ----- Original Message ----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Susan Palmer Sent: Wednesday, August 22, 2012 5:01 PM To: arslist@ARSLIST.ORG Subject: Data validation in character fields ** Hi everyone, On a regular form with a character field I need to be able to validate that there are no 'carriage returns' at the end of the data. Example: The field should contain - ABC Company but instead it contains - ABC Company ABC Company ABC Company This is purely a human error during input. They may be copy/pasting from a spreadsheet and somehow do paste more than once or any other creative way of doing this. Unlikely they are actually typing this. The field length is 100 characters, 76 of which display. But since only 1 row is displayed it's not evident when you look at the record that the above situation occurs. So I want to put a filter in that will produce an error when there is a 'carriage return' (or whatever they are called these days) upon save. But I cannot figure out how to create that special character in the qualification line. I was thinking something like 'Site Name' LIKE "%symbol" but I don't know what to put where the word symbol is. There is never a situation when we want the CR. >From a Remedy perspective this whole thing doesn't even matter. But we have >other systems that suck the data out of Remedy and they break when they get >this data. No suitable comment available for that issue. I'd appreciate any ideas you may have. Thanks, Susan Susan Palmer ShopperTrak 200 W Monroe 11th Floor Chicago, IL 60606 312-529-5325 spal...@shoppertrak.com ARS v7.5 Oracle 10g User Tool v7.5 Sun Solaris _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
