Will LTRIM/RTRIM remove the CR? I seem to remember it leaving them. On Wed, Dec 21, 2011 at 9:46 AM, Doug Blair <[email protected]> wrote:
> ** > Tommy, Anne, > > The extra CR on the end of the field value is part of the Windows > clipboard copy-and-paste function. > > If you train your users to carefully highlight just the actual value/text > before copying they'll do just fine, but of course this is a very common > error and we have to program around it. You can add an active link that > fires on lose-focus, row change,etc, and will remove the CR ( or maybe it's > CR/NL ) with REPLACE(), or you can do the same thing with a filter on the > underlying form. LTRIM(RTRIM(FieldName)) may be helpful too. > > Doug > > -- > Doug Blair > +1 224-558-5462 > > Sent from my iPad2 > Auto-corrected typos, misspellings and non-sequiturs are gratefully > attributed to Steve Jobs :-) > > On Dec 21, 2011, at 10:47 AM, Tommy Morris <[email protected]> > wrote: > > ** > > That also happens on the Remedy Login Field on CTM:People in the User > Tool. The “Row” property is just the number of Rows Displayed.**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Ramey, Anne > *Sent:* Wednesday, December 21, 2011 10:33 AM > *To:* [email protected] > *Subject:* 2+rows in 1 row field**** > > ** ** > > ** **** > > I have an issue where users are able to have more than one row in a one > row field, like incident number, in the mid-tier. I can make this happen > myself. If I copy and paste a cell from excel (not the contents, but the > whole cell) into the incident number field, it pastes in the incident > number and an end-of-line so you can’t see that you’ve actually put the > incident number in there (unless you move up a line with your cursor). > That is just one example, but it is one of the easiest to reproduce. Is > there any way to prevent this? I’ve had some people report accidentally > putting an end-of-line/soft-return in a field and then getting “stuck” in > it and not being able to get out of the field, which is why I ask. They > haven’t yet been able to tell me how they are doing that, but I am hoping > there may be some way to prevent it.**** > > ** ** > > I’m using ITSM 7.6.0 patch 1, ARS 7.5 and have tried this in Mid-tier 7.6 > p4 and 7.5 p7. It seems to happen in any browser.**** > > ** ** > > Thanks,**** > > ** ** > > Anne Ramey**** > > *************************************** > > *E-mail correspondence to and from this address may be subject to the > North Carolina Public Records Law and may be disclosed to third parties > only by an authorized State Official.***** > > ** ** > > _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"
