As Fred pointed out that is not really a pipe character, it displayed like a
pipe character though there was a visible difference between an actual pipe
character and that. Freds described it correctly as a 'wide pipe
character'.. That is just the way the Admin Tool displayed a carriage return
in code.
That’s quite a smart solution Fred.. I think I had used something similar
for a different special character before.. not sure which one but I wouldn’t
be surprised if it was for %..
Joe
-----Original Message-----
From: Grooms, Frederick W
Sent: Wednesday, August 22, 2012 7:31 PM Newsgroups:
public.remedy.arsystem.general
To: [email protected]
Subject: Re: Data validation in character fields
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:[email protected]] On Behalf Of Susan Palmer
Sent: Wednesday, August 22, 2012 6:29 PM
To: [email protected]
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:[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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.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"
