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, 200916 yr by Guest

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

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

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

)

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.

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

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