I am cautious of using getwordnum() for following reason.
Given:
lcString = "1,2,,3"
My observation is there are 4 separate words in that string using the comma as a separator - albeit one is null
? GETWORDCOUNT(m.lcString,",") - returns 3 ? OCCURS(",", m.lcString) + 1 - returns 4 ? ALINES(laLines, m.lcString, 3, ",") - returns 4
Guess it comes down to what a word is defined as.
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Friday, 29 July 2016 4:44 AM To: profoxtech@leafe.com Subject: Re: Bad getwordnum
Sorry Fred they were considered words when it was a numeric value when loaded in the array. We were extracting notes and there were addresses and times in there that muddied the waters.
On Thu, Jul 28, 2016 at 11:44 AM, Fred Taylor fbtaylor@gmail.com wrote:
Hi Stephen,
Got an example where numbers aren't considered words in GETWORDNUM()?
Seems to work fine for me.
Fred
On Thu, Jul 28, 2016 at 6:59 AM, Stephen Russell srussell705@gmail.com wrote:
I got burned by this a long time ago in that numbers are not considered words and we had sets of addresses in our document.
Just giving you a heads up.
On Tue, Jul 26, 2016 at 5:00 AM, Claudio canipotti@gmail.com wrote:
----- Original Message -----
Instead of using Getwordnum, split the string in an array using ALINES(yourarray,yourstring,3,',')
You can then access to each word, even if it's a null string.
Gérard.
[excessive quoting removed by server]