Built-in Funtions

By Gonçalo Almeida on 12 Mar 2011
Based on these 2 ideas: http://www.outsystems.com/wisdomofthecrowds/IdeaComment_List.aspx?IdeaId=669

I propose the following, that would satisfy everybody, I believe:

- The Index funtion could have 2 extra optional parameters:
       1 - indicating the direction of the search (left->right or right->left); (Default is left->right);
       2 - indicating the Index at wich the search is started at; (Default is 0 or end of string, depending on the direction parameter)
- In the Substr function, the "length" parameter could be optional. If empty than the function assumes "to the end of the string";

Although not as important as the above, I also propose 2 additional built-in math functions who already exist in C#:
- Floor(decimal)
- Ceiling(decimal)
Hugo Bento20 May 2011
I prefer the: Left(var, length) and Right(var, length) for the simplicity (this maybe a VB perspective).
But you are right on the bubble of the Floor and Ceiling, in my opinion all 4 should be Built-in Functions long time ago.
Pedro Oliveira26 May 2011
The index built in function was revised with 6.0