Re: Question concerning REPLACE function

2009-09-17 Thread Grooms, Frederick W
From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brandi Barbour Sent: Wednesday, September 16, 2009 11:05 PM To: arslist@ARSLIST.ORG Subject: Question concerning REPLACE function All, I hope someone has an easy solution to this problem. For example if

Re: Question concerning REPLACE function

2009-09-16 Thread Frank Caruso
Not sure if this will work for you but if the text you are looking for is always surrounded by the "" tags and there is only one set then the following will extract what is between: SUBSTR($VALUE$,STRSTR($VALUE$,"p>")+2,STRSTR($VALUE$," wrote: > ** All, > I hope someone has an easy solution to thi

Question concerning REPLACE function

2009-09-16 Thread Brandi Barbour
All, I hope someone has an easy solution to this problem. For example if i have a field that has a value of CM - Testing and I need it to just have CM - Testing I am trying to use a set fields with REPLACE($csc_char_label1$, "<%>", "") However this is not working and returning the whole valu