Re: finding a value and a subsequent value

Mike -

Just last week I created a service program which has a subprocedure which parses through a string and breaks it into an array of words and then returns a count of the number of words in the string. Another subprocedure in this service program uses the first subprocedure to load the word array, then looks for duplicate words in the word array, returning the count of dupes found in the string.

I have also created SQL UDF's over these subprocedures for use in text processing.

Perhaps you could adapt this code to your purposes. Let me know, and I'll post a code sample.

- sjl



"Smith, Mike" wrote in message news:mailman.974.1325106924.2619.midrange-l@xxxxxxxxxxxx...

Thanks Steve,

I don't think that will work because it could be
'Sue called with her size five'
In this case I wouldn't want the record. I only want it if is numeric.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of sjl
Sent: Wednesday, December 28, 2011 3:54 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: finding a value and a subsequent value

Mike -

Specify the trailing spaces in your LIKE clause.

However, I might do it this way to catch anything entered in the comments
field in mixed case:

Select COMNT from MYFILE where UPPER(COMNT) like('%SIZE %')

Regards,
Steve


Mike wrote:
I am trying to see if I can do this with sql.
I am searching through comments in a file

I have records like this
'Jane measured size 12'
'Sue called with her size'

So for example purposes lets say I have field ACCT, and COMNT

I want to find records where the word 'size' is in the comment' easy
enough,

Select COMNT from MYFILE where COMNT like('%size'%)

But I only want records where there is a number 2 spaces after the word
'size'

Is it possible to do this with an sql statement?

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.