Let us know what you end up doing. From what I remember RTRIM hasn't worked for me in the past. I have used option two a few times as Doug suggested (although I didn't loop it).
Jason On Thu, Aug 23, 2012 at 2:02 PM, Susan Palmer <[email protected]> wrote: > ** > Thanks Doug ... > > Yes I do want clean data. And doing it quietly would probably be the most > 'correct' way ... but any command I could use that might transmit a slight > electrical shock with the message could be somewhat satisfying ... :) > > I'll give the RTRIM a try ! > > Susan > > > On Thu, Aug 23, 2012 at 3:50 PM, Mueller, Doug <[email protected]>wrote: > >> ** >> >> Susan,**** >> >> ** ** >> >> Just checking on the requirement…**** >> >> ** ** >> >> What is the end result goal?**** >> >> ** ** >> >> I suspect it is that you don't want to have extraneous white space at the >> end of strings and would like for**** >> >> the data to be entered without that extra whitespace.**** >> >> ** ** >> >> If that is the final goal, why not just clean the data and forget about >> error messages. What are you going to**** >> >> do, give an error that the data is bad so the user has to go and remove >> the extra return (or space or tab) and**** >> >> go again? Wouldn't it be better to simply clean it quietly and move on?* >> *** >> >> ** ** >> >> With this in mind, would the RTRIM function do what you are looking for? >> It removes whitespace. And, I**** >> >> assume it is not just CR you want not there, but also why have trailing >> spaces or tabs. So, if RTRIM does**** >> >> indeed include CR as whitespace, you should be good to go. No error >> report, data clean, no disruption of user,**** >> >> you get what you need.**** >> >> ** ** >> >> If RTRIM itself doesn't work, you could put a little loop in place that >> does an RTRIM (to get rid of spaces and**** >> >> tabs) then an if 'field' LIKE "%" + "**** >> >> " and if matches, trim the length by one and loop back before the RTRIM. >> If it doesn't match (else) jump out**** >> >> of the loop.**** >> >> ** ** >> >> Of course, if you really really want to give the user an annoying error, >> you can…..**** >> >> ** ** >> >> And, as someone mentioned, to get a return character in a qualification >> just type it in between quotes. So,**** >> >> enter a ", hit the return, enter another " and you will have a return >> captured. But, be careful as there could**** >> >> be any number of CRs in the middle of text and there could be any number >> at the end of the text too; and**** >> >> returns could have spaces or tabs between them.**** >> >> ** ** >> >> Just something to think about.**** >> >> ** ** >> >> Doug Mueller**** >> >> ** ** >> >> *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"_ **** >> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ >> > > _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"
