All, Here's a (hopefully) quick question for you. I have a multi-line character field that I allow users to type whatever they want into, including "return" or "new line" characters. Later in a filter, I use a REPLACE function to remove all return characters and replace them with spaces so that I end up with a single line that holds everything in that field. The method I use to find the return characters is by expanding the Value field in the Filter's Set Field action and actually typing a return character. The expanded value would look like this:
REPLACE($Character_Field$, LTRIM( " ") When it isn't expanded it typically shows a pipe "|" in place of the return character in the filter. This all works great when data is entered using the Remedy User Tool. However, when users enter data in the form through the mid-tier, the return characters are never removed. From everything I can tell, mid-tier is submitting return characters differently than the user tool does. Has anyone seen this before and do you know how to get around it? Thanks in advance for your help. Brent _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
