Search and Extract from a String 3

[dixie617]

I have a very large memo field in a oracle database that I need to search for the "Imported By:" and extract the name from the field. I have tried numerous formulas but nothing seems to work right. Here is a sample of the field:

{\rtf1\ansi\ftnbj{\fonttbl{\f0 \fmodern Courier New;}{\f1 \fswiss Arial;}}{\colortbl ;\red255\green255\blue255 ;\red0\green0\blue0 ;}{\stylesheet{\f0\fs20\cf0\cb1 Normal;}{\cs1\additive\cf0\cb1 Default Paragraph Font;}}\margl1440\margr1440\margt540\margb1440\headery540\footery720\formshade\sectd\marglsxn1440\margrsxn1440\margtsxn540\margbsxn1440\headery540\footery720\sbkpage\pgncont\plain\plain\fs20\pard\plain\fs20\cf0\f1\sscharaux10001\b\protect WCC: 5 Yr.Old\b0\par\sscharaux0\protect0\par\sscharaux10002\protect See attached scanned report\par\sscharaux0\protect0\par\par\sscharaux10003\i\protect Imported By: Kerry Parascando, MA 03/26/2009 10:40:59\i0\par\f0\cf2\sscharaux0\protect0\par\sscharaux10004\protect _____________________________________________________________________\par\sscharaux0\protect0\par\sscharaux10005\protect External Attachment:\par\sscharaux0\protect0\par\sscharaux10006\protect Type:\tab Image \par Comment:\tab External Document\f1\cf0\sscharaux0\protect0\par}

Any help would be greatly appreciated. Thanks Christine

 

[dixie617]

LB,

Another question for you, if I wanted to use this extracted name as a parameter to run the report, how would I go about it? I tried it already but am getting the error "A subscript must be between 1 and the size fo the array." By the way the formula above is working great, I have run the report several times since Friday with no errors except when I try to add the name to a parameter.

 

[lbass]

Try changing your record selection formula to:

instr({DOCDATA.DATA},"Imported By:") > 0 and
ucase({@yourformula}) = ucase({?Name})

-LB

 

[dixie617]

Now getting "This array must be subscripted. For example: Array [1]

 

[lbass]

Oh, yeah, oops. Just try:

instr({DOCDATA.DATA},"Imported By:") > 0

-LB

 

[dixie617]

You are awesome, was able to add the name parameter without a hitch.

Thank you so much for all the help with this tough one.