Jumble ( text )

Randomly re-orders the words in a string.

Average rating: 4.3 (33 votes) Log in to vote

Rob Westergaard - Show more from this author
DataStorm Solutions
http://www.DataStorm-Solutions.com

Sample input:

RemoveFromList ( "She and I went to the same junior high and high schools." )

Sample output:

high high went junior She I schools and to the and same

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( 
     [ 
          numwords = WordCount ( text ) ; 
          current = Int ( Random * numwords ) + 1 ; 
          currword = MiddleWords ( text ; current ; 1 ) ; 
          remain = LeftWords ( text ; current - 1 ) & " " & MiddleWords ( text ; current + 1 ; numwords - current ) 
     ] ; 

     currword & " " & If ( numwords > 2 ; Jumble ( remain ) ; Trim ( remain ) )

)

Randomly re-orders the words in a string.

Parameters:
text = string or text field

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Jumble ( text )

Comments

Support this website.

Support this website.