How to Pull Information from memo text

[rji1124]

Hi... I was wondering if there is any way to pull specific information from a freeform text field. Wea re CR9.0, using Peregrine Service Center P4 database...

Here is an example:

(I want to pull the words SCAutomate and the 6 character code after it - every occurrence)

05/02/06 08:52:24: updated by SCAutomate nub141
30 - 45 a day
Update provided by Sam at 05/02/06 08:40:40 US/Central
Rick,
I will provide the specs and forward to the Client Interface Enhancment's Group for further review. How much time would this save you per month?
Thanks,
Dave
05/01/06 07:44:15: updated by SCAutomate hly26
I would like to see what the CSR is to complete this?
Thanks
Update provided by Dave at 04/28/06 17:04:49 US/Central
Rick,
I looked at this interface and there is no current option that can be turned on for this problem. Would you like to pursue programming for this interface to accomplish this task.
Thanks,
Dave
Update provided by Dave at 04/26/06 09:11:01 US/Central
Rick,
I do not believe that this logic can just be added to the report. Maybe there is a report that can be created that will contain all Merrill Accounts that have upcoming maturites. This is just preliminary thinking and I would have to search for this.
Thanks,
Dave
Update provided by Dave at 04/26/06 08:15:49 US/Central
Rick,
I will review this issue for you.
Thanks,
Dave
Update provided by Mike at 04/26/06 08:10:12 US/Central
Assigning this ticket to Dave for assistnance.

 

[satinsilhouette]

I would use some string functions like instr to use to search for the words you are trying to extract with mid or left or etc.

 

[synapsevampire]

I think that you're mistaken, the second code has 5 letters, not 6.

Here's a cheat:

whileprintingrecords;
stringvar array Sc:= split({table.field},"SCAutomate");
stringvar array ScOut;
redim ScOut[ubound(Sc)];
numbervar counter;
For counter := 1 to ubound(Sc) do(
ScOut[Counter] := left(Sc[counter],instr(Sc[counter]," ")-1)
);
join(ScOut,",")

This will supply them in a comma delimited string.

You stated that you wanted them out, but not in what format or where...if you need something else, please supply specifics.

-k

 

[rji1124]

Thanks for the info...

The first instance of the code is nub141 (6 chars).. the rest are 5 chars...

The result I wanted to try and get was to show:
SCAutomate xxxxxx

 

[synapsevampire]

Did you try my solution?

If you have multiple numnbers in the text, why would the output only be one? Do you only want the first or the last?

Anyway, try my solution and get back to me.

-k

 

[synapsevampire]

btw, to add in the text, use:

whileprintingrecords;
stringvar array Sc:= split({table.field},"SCAutomate");
stringvar array ScOut;
redim ScOut[ubound(Sc)];
numbervar counter;
For counter := 1 to ubound(Sc) do(
ScOut[Counter] := "ScAutomate " + left(Sc[counter],instr(Sc[counter]," ")-1)
);
join(ScOut,",")

-k

 

[rji1124]

OK... I am almost there... all I need to add is the 5-6 character code following the SCAutomate piece! Thanks so much for steering me the right way on this...

 

[synapsevampire]

The above code should be doing that already...

You should consider putting a little more time into your posts to explain what you have tried and what you are getting.

-k