Susan, Try this old-school trick:
1. Open a text editor like 'notepad' 2. In a new doc, type this: a. <Double-quote> b. <Enter> c. <Double-quote> 3. Select all and copy to an active link with a Set Field that puts this string into a tmp_field. Use the tmp_field name in work flow. BTW, you could use the REPLACE function to change them into something else, like an * HTH, Joel Joel Sender [email protected] 310.829.5552 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Susan Palmer Sent: Wednesday, August 22, 2012 3: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"
