Page 1 of 1

Parsing

PostPosted: Mon Jan 24, 2011 5:07 pm
by MiltonTrickey
Hi All,
I have a feild that holds the city and the state and I want to get rid of the last word in the feild.
Trouble is some feilds have 4 words whilst others only have 2.
What calculation can I use to just get rid of only the last word in every circumstance?

Thanks in advance

Milton.

Re: Parsing

PostPosted: Mon Jan 24, 2011 5:26 pm
by John Sindelar
LeftWords ( YourField ; WordCount ( YourField ) -1 )

Re: Parsing

PostPosted: Tue Jan 25, 2011 1:39 am
by MiltonTrickey
Thanks John,

Works a treat.

On another matter, If I move up to FM PRO 11 Advanced, what benefits do I get when I make a standalone program?
Does the end user need FM?
Can my program be used on a server?
Can it be edited via remote desktop?

Regards

Milton.

Re: Parsing

PostPosted: Tue Jan 25, 2011 9:47 am
by John Sindelar
Hi Milton,

The runtimes that can be generated with FileMaker Advanced have networking disabled (as well as PDF generation). So while the end user does not need FMP Client, they can't connect to served files or share data. Not sure what remote desktop would have to do with it.

As you can tell, runtimes aren't my favorite, nor my speciality. Sry.

Best,

John

Re: Parsing

PostPosted: Wed Jan 26, 2011 5:08 am
by MiltonTrickey
Thanks John,
Very helpful.
If my program is used by 5 people they each need a copy of FMP 11, but do they need 5 copies of FMP 11 server, or just 1 copy?

Very confusing

Thanks for all the great help and advice

Milton

Re: Parsing

PostPosted: Wed Jan 26, 2011 7:23 am
by John Sindelar
They each need a copy of FM11 and (possibly) one copy of server, though one of the FM11 copies can "host" the files, acting as a server. We recommend using server, however, even for 5 clients. More here:

http://www.filemaker.com/products/filem ... aring.html