I don't think Tyron wants to replace but wants to capture the text appearing after the string "Street Address: " which is why the best way to do that is to take a SUBSTR() using the output of STRSTR() + LENGTH("Street Address : ") as the starting character position for taking the SUBSTR value of that field. The end character position would depend on how the rest of his data is structured in that field. For e.g. if after "Street Address : " if he has "City : " then the start character position of City minus 1 or 2 would be a good one..
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Thad K Esser Sent: Monday, September 10, 2007 12:10 PM To: arslist@ARSLIST.ORG Subject: Re: Question: Finding Text ** Based on what you said about the text always starting with "Street Address:", you could also use something like: ztmpfield = LTRIM(REPLACE($AddressField$,"Street Address:","")) Takes care of it without any other string manipulations. Or since you know the text "Street Address:" is always going to be 15 characters, and always going to be at the beginning of the string you could do: ztmpfield = LTRIM(SUBSTR($AddressField$,15)) The LTRIM clears any whitespace that might show up between the colon and the start of the data. It might not be necessary depending on what is generating this (i.e., whether or not you know it will be there). Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Tyrone Dee" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 09/08/2007 10:33 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Question: Finding Text ** Thanks I will give it a try. T. ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Saturday, September 08, 2007 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: Question: Finding Text Tyron, You can use the function STRSTR($FieldToSearchYourString$, "Street Address:") + LEN("Street Address:") to return an integer value of the position where "Street Address:" ends in your string $FieldToSearchYourString$. Then do what you want to do with that.. Let me know if that helped - or if you require any further help using a combination of these functions.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Tyrone Dee Sent: Friday, September 07, 2007 11:30 PM To: arslist@ARSLIST.ORG Subject: Re: Question: Finding Text There will be the words "Street Address:" first and then the address to follow - "Street Address" will always be the same, but what comes after it will be different. Can I some how grab that and place it in a temporary field? THANKS! T. ________________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, September 07, 2007 7:32 PM To: arslist@ARSLIST.ORG Subject: Re: Question: Finding Text On the basis of what will you identify the text then.. If you have a way to identify the text yes there are ways with the available functions in Remedy to do what you want. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Tyrone Dee Sent: Friday, September 07, 2007 7:14 PM To: arslist@ARSLIST.ORG Subject: Question: Finding Text I was wondering how I would take a field with (zero character length) and through workflow find a specific text (i.e. 123 Jones Avenue) and set it to a temporary field. The text I am looking for will not necessarily be in the same place all the time and may not be the same length all the time. Is this possible? Any help is appreciated. Thanks. T. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"