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: vclem...@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 <gcan...@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 <jac...@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 | jac...@hyperactivesw.com > > HyperActive Software | http://www.hyperactivesw.com > > > > ______________________________**_________________ > > use-livecode mailing list > > use-livecode@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
