Separating letters of the word with spaces

[Dr.Hamed]

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

[Lee Smith]

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

[Dr.Hamed]

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).

[Lee Smith]

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. 

[Dr.Hamed]

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

[Lee Smith]

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

[eos]

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

[Lee Smith]

Hi eos,

 

Nice Custom Function.

 

Now I have something to study too.

[Lee Smith]

Hi eos,

 

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

[eos]

Is there a reason for it to be a CF

 

It's recursive.

 

it seems to work as a regular calculation

 

How so?

[comment]

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.

[Rick Whitelaw]

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

[Lee Smith]

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

[eos]

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

[comment]

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.

[Lee Smith]

DOH -   of course.