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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
