SQL Expression help

[ITCPhil]

The SQL expression option of Crystal Report 10 is fairly new to me. I know how to use it to locate text, but I am wondering on the possibility of an expression to print information from a line of text.

The following 2 lines are from a memo field :
20/03/2006 6:58:44 PM Payant Jonathan
Payant Jonathan assigned this problem to Tousignant Benoit.

What I would like to do is locate the 'assigned a problem to' and then have Crystal print the end of that specific line up to the period, the name basically. Is there a way to do this?

I don't know if it helps, but the Remedy code itself which follows identifies the printed name too, but not a line break so I don't know how to go about doing this. I don't connect directly to Remedy though, I am using an Oracle view.
1) Trace Log+ (Inc) (((((($USER$ + " [highlight]$Assign to Member$[/highlight]") + $Assign to
Member$) + ".

Ideas?
Thanks in advance,
Phil

 

[ITCPhil]

That Remedy code should read :
1) Trace Log+ (Inc) (((((($USER$ + " assigned this problem to ") + $Assign to
Member$) + ".

I replaced the wrong text to highlight.

 

[Turkbear]

Hi,
There are no Memo fields in an Oracle database ( Raw,Long Raw, BLOB,CLOB are the Oracle types) - what exactly is the field type in the view?
Use SqlPlus and do a describe ( or have the Oracle dba do it for you if you do not have direct access to Oracle)






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Turkbear]

Hi,
There are no Memo fields in an Oracle database ( Raw,Long Raw, BLOB,CLOB are some of the similar Oracle types) - what exactly is the field type in the view?
Use SqlPlus and do a describe ( or have the Oracle dba do it for you if you do not have direct access to Oracle)






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Try a Remedy forum as well, such as:

forum773

-k

 

[ITCPhil]

I am using an oracle ODBC so the remedy folks won't be able to answer much here I gather. This is a clob field, didn't think about that, sorry.