Genii Weblog
Pushing harder at the limits of formulas
Tue 15 Sep 2020, 03:27 PM
Tweetby Ben Langhinrichs
I was curious how a more complex formula would work with Exciton Boost. While this may look dense, it is a real one I created for the Lotusphere Sessions db back in 2004. Here it is in formula language without the escaped quotes and with colors to guide the eye. (Also, you can copy this, as it is text rather than an image.)
sorted := @Sort(Speaker; [CustomSort];
@If(
@Do(R:=@Transform(@Explode($A; " "); "W";
@If(@Matches(W; "{a-z}*"); W+@RightBack($A; W)+", "+@LeftBack($A; W); @Nothing));
@If(@Trim(R) != ""; @Trim(R)[1]; @RightBack($A; " ")+", "+@LeftBack($A; " "))) >
@Do(R:=@Transform(@Explode($B; " "); "W";
@If(@Matches(W; "{a-z}*"); W+@RightBack($B; W)+", "+@LeftBack($B; W); @Nothing));
@If(@Trim(R) != ""; @Trim(R)[1]; @RightBack($B; " ")+", "+@LeftBack($B; " ")));
@True; @False));
If you look in the properties after POSTing this, you see that the Speaker item has a text list as specified.
The SpeakersSorted item has the same text list, now sorted by last name. A tweak would make this sort with German sorting rules (van der Welten after Veems).
==> Request a free Exciton Boost evaluation license, and we'll send you the license and a link to the software as soon as it is released. <==
Copyright © 2020 Genii Software Ltd.
What has been said: