1. Get the number words using ITEMCNT, say vCount 2. Set up a loop with an index, vIndex that goes from 1 to vCount 3. For each value of vIndex, SSUB(textstring,.vIndex) is the word and vIndex is the relative position.
(you may need to use negative vIndex if textstring still has spaces instead of commas) Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForenSys.ca 416 512 6950 > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Paul > Buckley > Sent: January 15, 2009 10:54 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Looking for Some Input for Text String Manipulation > > 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 > > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.176 / Virus Database: 270.10.7/1894 - Release Date: 1/15/2009 > 7:46 AM
