Hello,

[FMPdev7/WinXP Pro + FMS7/WinXP Pro]

I noticed some strange behaviour of the 'Words' functions in FileMaker 7.
For example this function:

RightWords("test 1.2.3";1)

- When testing this locally on any of the 2 machines it returns "1.2.3"
- When implementing it in a script or a calc field in a file hosted by
FileMakers Server, it returns "3"

Same behaviour of the LeftWords and WordCounts functions

Is there some kind of logic in it? Is there a point I am missing? Is this a
known issue?


Regards,



Jeroen

For me, it returns "1.2.3" in every example I try. Are you sure both
your FM Server and FM Pro clients are all on the latest versions (which
I believe ius v3 for both Server and Pro)?

Jeroen Aarts wrote:


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

Yes, both FM Developer 7 and FileMaker Server 7 are updated to version 3.
BTW, the behaviour described in my post does not appear on the fix list of
FileMaker 7, FileMaker Developer 7 or FileMaker Server 7.


Jeroen


"Howard Schlossberg" <howard (AT) antispahm (DOT) fmprosolutions.com> wrote

Yes the fields are all of type 'text', and yes bothy machines have exactly
the same system setup (number, currency,...).

When testing on another file, created by myself (the file causing the
problem was originally created by someone else), the behavior did not show
up - everything went as expected. So I presume somehow that the system
settings are stored within the file (although I did not get a dialog to ask
if I would use the system or the file settings)

BTW, I was testing the word functions in debugging a plug-in auto-update
script where plug-in information typically is of the form [name] [x.x] and I
spent half a day searching for the problem.

Anyway, I am stopping my Nitpicking Quest and just turn on to the good old
Middle function :-) Thanks for your reactions Howard and Martin!


Regards,



Jeroen

"Martin Trautmann" <t-use (AT) gmx (DOT) net> wrote