Separate word into letters?

[K3lso]

Hi. I was wondering how to separate a word into a combination of letters.

For example, I have the word "ORANGE" in one text field and I want to automatically separate it into a combination of three letters... like "ORA" (in one field); "RAN" (in another field); "ANG" (in another field) and "NGE" (in another field)

ORA-RAN-ANG-NGE (ORANGE)

Any help is appreciated.

Edited September 9, 2009 by Guest

[bcooney]

Where are you going with this? That is, why are you doing this?

Check out the Text functions Left ( ), Middle ( ) and Right ( ).

[David Jondreau]

Depending on what you're trying to accomplish, how about a calculated repeating field =

Let([

thisRep= Get(CalculationRepetitionNumber);

text = table::Field;

three = Middle(text;thisRep;3)

result = If(Length(three) = 3; three)

];

result

)

[comment]

You'd need to use the Extend() function when referring to the text field. But I'd rather wait and see what's the purpose here.

[K3lso]

what Im trying to do is to separate a word into many 3-letters-combination as the text lenght allows.

TextField1= ORANGE

Field2= ORA

Field3= RAN

Field4= ANG

Field5= NGE

Field5= empty (there is no more 3-letter combination)

Next, I´m going to create a search script that will search for any 3-letter-combination match.

SearchField= *"ORA"*

SearchField= *"RAN"* and so..

[bcooney]

And so, you don't need all the other fields. FM's find will allow you to search with wildcards. Using wildcards in Find