Thanks all, I'll pass this on. It's not for me, I don't even own FM.
Geoff had it right, I was using the word "concatenate" in the LiveCode
sense since I don't know any better. The script needs to combine the
first few letters of the words in a single cell.
Mark, we're not trying to create un
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
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.
Hi Jacque
Actually it is very much the same as LiveCode
Field Name1&" "&Field Name2 this will concatenate two fields. into a new
calculation field where the results are shown.
Thank you
Vaughn Clement
Apps by Vaughn Clement (Support)
*http://www.appsbyvaughnclement.com/tools/home-page/*
Skyp
Jacque-
Thursday, August 1, 2013, 1:33:32 PM, you wrote:
> 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
I don't have the answer for you, but those are pretty weird
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
