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.
================================================
