FORMULA LANGUAGE
Examples: Trimming, repeating, adding a new line, and changing case
1. (@Trim). This example returns [Now is the time], removing all extraneous spaces.
Untrimmed := " Now is the time ";
Trimmed := @Trim(Untrimmed);
@Prompt([Ok]; "Untrimmed"; "[" + Untrimmed + "]");
@Prompt([Ok]; "Trimmed"; "[" + Trimmed + "]")
2. (@Trim, @ProperCase). This example converts the words in Name to initial uppercase characters and deletes leading, trailing, and extraneous spaces. If " jane j smith" is entered for Name, this formula converts it to "Jane J Smith."
@Trim(@ProperCase(Name))
3. (@Repeat). This example returns "Great Month! Great Month! Great Month!" in the Comments field if the Sales field is 100,000 or greater.
FIELD Comments := @If(Sales >= 100000; @Repeat("Great Month! "; 3); Sales >= 50000; "Good Month"; "I want to see you in my office");
SELECT @All
4. (@NewLine). This example returns the user name and the date separated by a new line.
@UserName + @NewLine + @Text(@Now)
5. (@LowerCase). This example returns the user name in lowercase.
@LowerCase(@UserName)
6. (@UpperCase). This example returns the user name in uppercase.
@UpperCase(@UserName)
Véase también
Trimming, repeating, adding a new line, and changing case
Glosario
¿Desea opinar sobre la Ayuda?
Ayuda sobre la Ayuda
Abrir la Ayuda en pantalla completa
Glosario
¿Desea opinar sobre la Ayuda?
Ayuda sobre la Ayuda
Abrir la Ayuda en pantalla completa