Hi,
REPLACE($Field$, RIGHT("
",1), "")
You need to do something like the above to remove newlines.
The problem is that when you save a string only containing newline, Remedy
will insert a SPACE in it.
What originally looks like "|" will be " |" when you close and reopen the
workflow object.
The solution is to do a RIGHT(" |", 1) which will take the rightmost
character.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> Kevin, I think if you set it to " ", then whenever remedy commits it to
> the database, it will truncate tailing whitespace. Test it out and see
> if it works (I'm not giving any promises though).
>
> Thanks,
>
>
> Gary Opela, Jr
>
> Sr. Remedy Developer
>
> Leader Communications, Inc.
>
> 405 736 3211
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Thornley
> Sent: Monday, January 07, 2008 4:30 PM
> To: [email protected]
> Subject: Re: Help on Replace Function
>
> All
>
> OK I'm halfway home. The expand box adding the carriage return works. So
> how do you delete a line that only has a carriage return it it ? I did't
> really want to insert the " " but the function wouldn't let me set it to
> NULL.
>
> Kevin
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr
> OC-ALC/ITMA
> Sent: Monday, January 07, 2008 1:54 PM
> To: [email protected]
> Subject: Re: Help on Replace Function
>
> Kevin, whenever you are setting your value to REPLACE(), hit the expand
> box to the right of the field, then hit an enter.
>
> Fore example, you would have:
>
> REPLACE($FIELD$, "Bob is here.
> ", " ")
>
> Just hit return after your period, and it should work. You will have to
> use your expand box function to be able to hit return. Whenever you hit
> Okay on the expand box window that pops up, the new line will show up as
> a NPC (Non printable character), such as a solid block.
>
> Thanks,
>
>
> Gary Opela, Jr
>
> Sr. Remedy Developer
>
> Leader Communications, Inc.
>
> 405 736 3211
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Thornley
> Sent: Monday, January 07, 2008 3:37 PM
> To: [email protected]
> Subject: Help on Replace Function
>
> **
>
>
> All
>
> I can't seem to remember how to use a carriage return with the replace
> function. Basically I need to search for a certain 1 line sentence &
> remove it. Using the example below it only finds the string and replaces
> it with a space. I need it to find the string + the carriage return and
> replace it with nothing.
>
> REPLACE ( Some Field, "This is a test"," ")
>
> Thanks
> Kevin
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
> ________________________________________________________________________
> _______
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
> Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> ________________________________________________________________________
> _______
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
