Brian Dunning's FileMaker Custom Functions

Reverse ( Text )

Reverses the order of a list of text values.

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

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

Share on Facebook Share on Twitter

  Sample input:
Reverse ( "The
Quick
Brown
Fox" )
  Sample output:
Fox
Brown
Quick
The

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

Reverses the order of a list of text values.

 

Comments

jj   jj, Tokyo
Oct 17, 2014
11
 
Mike   Mike, Tennessee USA
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   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)

)
 

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Under construction. Email me your wish list for improvements.