Hi,

 

For linguistic purposes, I would like to have the output of sentences as follows:

 

Input ; John and Mary are students

Output : j o h n, a n d, m a r y, a r e, s t u d e n t s

 

Then I would like to have the output in a (portal or something else) linked to the record of the sentence, for searching purposes.

 

Thanks

This reminds me of the Multiple Keywords, but Have you looked at the auto complete feature for the fields?

Here a couple of Demos at Nightwing.com that might help 

Typeahead 

or

Instant Search

 

HTH

Lee

This reminds me of the Multiple Keywords, but Have you looked at the auto complete feature for the fields?

Here a couple of Demos at Nightwing.com that might help 

Typeahead 

or

Instant Search

 

HTH

Lee

I don't think those will help

 

First, I need to insert spaces between the characters of the words.

 

Secondly, to put each word in a record (of a portal).

What are you needing this for? In other words, why do you need a space between the letters to d a search.  Your description doesn’t make sense to me. 

I already mentioned that I need this " For linguistic purposes", i.e. philology and etymology. So I hope this makes sense to you.

Since all of your alpha characters are lower case, then you could do something like this using the Substitute Function.

 

see attach

linguistic.fp7.zip

Lee was asking how you want to use this result within the processes of your solution, not about your ultimate scientific goals. This information may not only let us suggest a better solution, but even maybe a different approach.

 

Anyway, here's a different method to get your desired text result.

Widen_eos.fp7.zip

Hi eos,

 

Nice Custom Function.

 

Now I have something to study too.

Hi eos,

 

Is there a reason for it to be a CF, it seems to work as a regular calculation?

Is there a reason for it to be a CF

 

It's recursive.

 

it seems to work as a regular calculation

 

How so?

Lee was asking how you want to use this result within the processes of your solution,

 

I'd be curious about that too. Especially the part about having "the output in a (portal or something else) linked to the record of the sentence". It seems like you want to have multiple related records associated with the parent sentence - but the current process does not lead to that.

I often store non-recursive functions as Custom Functions because it's just so simple to call them whenever I want.

Hi Rick,

 

I do that too

 

Hi eos, I initially thought it might be because it recursive. However. I didn’t spot a recursive need, so I put the Let calculation into a regular calculation field and got the same result as the CF.

 

Lee

However. I didn’t spot a recursive need, so I put the Let calculation into a regular calculation field and got the same result as the CF.

 

Hi Lee,

 

sorry, I'm a bit dense here; would you mind posting a file with your calculation field?

 

eos

I put the Let calculation into a regular calculation field and got the same result as the CF.

 

I think the only way to accomplish this is to do it in a file where the custom function is already defined AND the text field is renamed to "myString". Otherwise Filemaker would have highlighted either "myString" or "Widen" and complained that the field/function cannot be found.

DOH -   of course.