Reverse ( Text )

Reverses the order of a list of text values.

Average rating: 4.1 (36 votes) Log in to vote

Andrew Persons
Excelisys
http://www.excelisys.com/

Sample input:

Reverse ( "The
Quick
Brown
Fox" )

Sample output:

Fox
Brown
Quick
The

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

Case ( ValueCount ( Text ) > 0 ;

Reverse ( RightValues ( Text ; ValueCount ( Text ) - 1 ) ) & LeftValues (
Text ; 1 ) ; 

LeftValues ( Text ; 1 )

)

Reverses the order of a list of text values.

Comments

		Mike Oct 23, 2015
It appears this adds an extra "Â¶" at the end of the list, resulting in an extra line that is blank. Is there a way to eliminate this? Otherwise, this CF works great. Thanks.

		ross doran Dec 13, 2018
Hi Mike! Late response, but in case anyone finds this and is curious - I was able to get the desired result by doing the below. Cheers! Case ( ValueCount ( Text ) > 0 ; List(Reverse ( RightValues ( Text ; ValueCount ( Text ) - 1 ) ); GetValue(Text; 1)); GetValue(Text; 1) )

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