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)"
<[email protected]>
09/08/2007 10:33 AM
Please respond to
[email protected]
To
[email protected]
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: [email protected]
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: [email protected]
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: [email protected]
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: [email protected]
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.
__20060125_______________________This posting was submitted with HTML in
it___ __20060125_______________________This posting was submitted with
HTML in it___
***IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely for
the entity or individual to whom it is addressed. If you are not the intended
recipient, you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message is strictly prohibited.
Nothing in this email, including any attachment, is intended to be a legally
binding signature.***
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
