Doug & Everyone Else, Here's a little more background. We are going to be "data mining" the occurrence of user defined words from several fields in each row. Our plan is to catalog the results and allow the user to define which rows and which fields and which words to show the "counts" for.
Here are the answers to your questions: 1) Some descriptions are 1 sentence; others are 6 or 8 sentences. 2) We also have an "exclusion" list to not count this, is, a, etc. 3) NO. We need to know that word #1 occurs in row 200 - position 5, row 550 - position 12, etc. 4) NO. This is hopefully going to become part of an existing project to replace a 3rd party program that does the data mining but can't transfer the data back to the database in "user friendly" format. I hope this answers your questions. Thanks, Paul > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Doug > Hamilton > Sent: Thursday, January 15, 2009 5:20 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Looking for Some Input for Text String > Manipulation > > Paul, four questions: > 1) How long are the descriptions? A sentence, as in your example, or > bigger, like a paragraph? > 2) Do you need to know the relative positions of every word (e.g. > positions of "This", "is", "a", "test", "string", etc.) or just certain > words; if so are they "fixed" words (like "string" and "demonstrate" in > your example) or a user-chosen word? > 3) Are you looking for relative position in all 500k rows? ("This" > occurs 1st in 138,234 rows, 2nd in 92,539 rows, 3rd in 17 rows, etc. > 4) Are you making this up? > > Doug > > Paul Buckley wrote: > > >Good Morning All, > > > >I'm wondering if anyone else has done this and is willing to share. > I'm > >working on a project using V8 Turbo. I'm going to be counting the > number of > >words in a description text string for over 500,000 rows of data and I > need > >to know the relative "word" position of words in the string. For > example; > >if the string is 'This is a test string to demonstrate what I need to > do.', > >it has 12 words and the word 'string' is the 5th word and the word > >'demonstrate' is the 7th word. > > > >I know I can use the ItemCnt function to count the number of words, by > first > >changing the delimiter to a space. I'm looking for a slick way to > find a > >words relative position by word count. > > > >If anyone has any suggestions or insight I would greatly appreciate > it. > > > >Thanks in advance, > >Paul Buckley > > > >--- RBASE-L > >================================================ > >TO POST A MESSAGE TO ALL MEMBERS: > >Send a plain text email to [email protected] > > > >(Don't use any of these words as your Subject: > >INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > >REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > >================================================ > >TO SEE MESSAGE POSTING GUIDELINES: > >Send a plain text email to [email protected] > >In the message SUBJECT, put just one word: INTRO > >================================================ > >TO UNSUBSCRIBE: > >Send a plain text email to [email protected] > >In the message SUBJECT, put just one word: UNSUBSCRIBE > >================================================ > >TO SEARCH ARCHIVES: > >Send a plain text email to [email protected] > >In the message SUBJECT, put just one word: SEARCH-n > >(where n is the number of days). In the message body, > >place any > >text to search for. > >================================================ > > > > > > > > > > > >
