Cindy,
There are other threads that talk about this "feature" of ARS.
But here is a short response.
ARS (because some databases require it) store all <CR> (that is a
carriage return) in the DB as a "whitespace<CR>" combination. So in
workflow you have to take that in to consideration. Specifically when
you embed the <CR> in the STRSTR function ARS will expand tha to the
"whitespace<CR>" combination before that function is stored in the DB.
You can counter that behaviour with the LTRIM function around the part
of the STRSTR function that has the "whitespace<CR>" combination.
So you want to do something like:
STRSTR($source_Field$,LTRIM(" <CR>"))
That should return where the first CR is in the field $source_Field$.
You can the check that value and make sure it is >=0 and then use the
SUBSTR() function to "split" out part of that string into the target
fields for the parts of the field that you find.
HTH.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
On 2/22/07, Cindy Sapochetti <[EMAIL PROTECTED]> wrote:
Hi All -
Is there any way to parse the contents of a char field that is set to
multiple rows, and has data that looks like this:
John Doe
123 Main Street
Anywhere, Anystate
Where there is a carriage return delimeter? I notice in the dbase, spaces
and carriage returns are "saved" as spaces - but when it's pulled up in the
GUI, the text displays as if carriage returns are present. Anyone know
what does this?
I need to be able to grab a particular LINE of data (i.e. - "123 Main
Street" in the above example).
Any help would be appreciated!
Thanks,
Cindy
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
