[OT] Need a simple FileMaker script

[Vaughn Clement]

Hi Geoff, & Mark

The key word was concatenate which is a FileMaker calculation. If he asked
for a find and replace as you answered the process is a one time exercise.
A typical usage of concatenation is where dissimilar entries are in a set
of fields. For example; when you import data like a first and last name in
2 different fields and you want to join them into one field. Keeping in
mind each set of fields contain different text values.  The calculation
will easily and quickly process the fields in a join. In the example I
provided the open quotes provided a space between the 2 joined text values.


Thank you

Vaughn Clement

Apps by Vaughn Clement (Support)
*http://www.appsbyvaughnclement.com/tools/home-page/*
Skype: vaughn.clement
https://secure.join.me/appsbyvclement
FaceTime: vclement at gmail.com
LogMeIn also avaialble
Call on "ooVoo" at address:  vaughnclement or 9282549062
Ph. 928-254-9062


On Thu, Aug 1, 2013 at 7:01 PM, Geoff Canyon <gcanyon at gmail.com> wrote:

> You don't need a script for this unless you want to do it repeatedly, say
> for different sets of data or whatever. If you just want to do this right
> now for whatever set of records you're looking at:
>
> 1. Find the records you want to update. If all of them, then Show All
> Records on the Records menu.
> 2. Click in the field you want to update (in your case A6). It doesn't
> matter which record you're in.
> 3. Select Replace Field Contents... on the Records menu.
> 4. In the dialog, click the radio button next to Replace with calculated
> result: (or click the Specify button next to it)
> 5. In the Specify Calculation dialog, paste this text into the calculation
> entry field (big white box at the bottom):
>
> Left ( LeftWords ( source ; 1 ) ; 5 ) & Left ( MiddleWords ( source ; 2 ; 1
> ) ; 5) & Left ( MiddleWords ( source ; 3 ; 1 ) ; 5)
>
> This assumes the name of the field with the words you want is "source". For
> your example with A5 it would be:
>
> Left ( LeftWords ( A5 ; 1 ) ; 5 ) & Left ( MiddleWords ( A5 ; 2 ; 1 ) ; 5)
> & Left ( MiddleWords ( A5 ; 3 ; 1 ) ; 5)
>
> 6. Click OK to close the Specify Calculation dialog.
> 7. Click Replace.
>
> You're done.
>
> If you need this to always be the case, change A6 to a calculation field
> and use the above calculation as its definition. If you don't need to
> search it, you can set it as unstored and it won't take any space.
>
> If you need to do this for different sets of records, save it as a script
> step to apply later.
>
>
> On Thu, Aug 1, 2013 at 3:33 PM, J. Landman Gay <jacque at hyperactivesw.com
> >wrote:
>
> > This seems like it shouldn't be too hard, but I don't know FileMaker.
> Does
> > anyone know how to:
> >
> > 1. Get the text in one cell
> > 2. Concatenate the first 5 characters (or as many as exist) of the first
> 3
> > words
> > 3. Put the value into another cell
> >
> > Do that for every record.
> >
> > So, if the text in cell A5 is "Every good boy does fine", cell A6 would
> > contain "EveryGoodBoy".
> >
> > --
> > Jacqueline Landman Gay         |     jacque at hyperactivesw.com
> > HyperActive Software           |     http://www.hyperactivesw.com
> >
> > ______________________________**_________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/**mailman/listinfo/use-livecode<
> http://lists.runrev.com/mailman/listinfo/use-livecode>
> >
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>