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 On Wed, Aug 22, 2012 at 6:20 PM, Grooms, Frederick W < [email protected]> 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**** > > ** ** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Susan Palmer > *Sent:* Wednesday, August 22, 2012 5:01 PM > *To:* [email protected] > *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**** > > [email protected]**** > > **** > > ARS v7.5**** > > Oracle 10g**** > > User Tool v7.5**** > > Sun Solaris**** > > **** > > **** > > ** ** > > ** ** > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
