| # CRM – Text Editor If you create a letter or a selection expression, you can use the Text Editor to specify the actual layout of the letter or to specify an expression. Note You can specify letters in the Letters (tdsmi1150m000) session. You can specify selection expression in the Selections (tdsmi0170m000) session Using the text editor The layout of a letter or a selection expression can be very simple or quite complex. It can contain the following data: Normal text For example, "We are excited...". You can use special characters like ö or é but it is not possible to use print effects such as bold, underscore, and different fonts. Table fields You can use all table fields recorded in the Tables to be Displayed in Relation Management (tdsmi0182m000) session, such as tccom100.nama (the business partner's name). Attributes You can use all attributes recorded in the Attributes (tdsmi0550m000) session. For more information, refer to CRM – attributes in the Text Editor. Predefined variables For example, @today (gives current date). For more information, refer to CRM – predefined variables in the Text Editor. It is recommended that you zoom and select table fields and attributes rather than entering them, because you are less likely to make mistakes by selecting them. On the Options menu of the Text Editor, click Start Zoomsession to retrieve the required table fields or attributes. Note Any text that you type after the pipe ( | ) symbol is not used as programming code, but is merely used as additional information for the user. Operators in the Text Editor You can use arithmetic, logical, or relational operators in the Text Editor.
Arithmetic operators
* | multiplication
/ | division
+ | addition
- | subtraction
¥ | remainder after division
& | linking strings (alphanumerical arrays)
Logical operators
or
and
not (negation)
Relational operators
= | equal to
<> | unequal to
> | greater than
< | less than
>= | greater than or equal to
<= | less than or equal to
Functions in the Text Editor You can use the following functions in the Text Editor: Arithmetic Trigonometric Logarithmic String Date
Arithmetic functions | Example
--- | ---
round (X,Y,Z) | produces rounded value of X Y is number of decimals Z is rounding method (0 = down, 1 = normal, 2 = up) | -
val (A) | produces numeric value of string A | val ("8.7") = 8.7
abs (X) | calculates absolute value of X | abs (-10.3) = 10.3
int (X) | produces integer value of X | int (11.6) = 11
pow (X, Y) | raises X to the power of Y | pow (10.2) = 100
sqrt (X) | produces square root of X | sqrt (16) = 4
min (X, Y) | produces smallest value of X and Y | min (6, 10) = 6
max (X, Y) | produces largest value of X and Y | max (6, 10) = 10
pi | constant with value pi (3.1415926) | -
Trigonometric functions
sin (X), cos (X), tan (X) | produces sine, cosine, or tangent of X
asin (X), acos (X), atan (X) | produces arc sine, cosine, or tangent of X
hsin (X), hcos (X), htan (X) | produces hyperbolic sine, cosine, or tangent of X
Logarithmic functions
exp (X) | raises e to the power of X
log (X) | produces natural logarithm of X on the basis of e
log10 (X) | produces logarithmic value of X on the basis of powers of 10
String functions | Example
--- | ---
edit (X,Y) | formats numeric value X according to format Y | edit (10.3, "ZZZ9V,99") = " 10,30"
str (X) | puts numeric value in string | str (10.3) = "10.3"
len (X) | produces length of string X | len ("abc") = 3
strip (X) | deletes spaces after last character | strip ("A ") = "A"
pos (X,Y) | produces position of string Y in string X from left | -
rpos (X,Y) | produces position of string Y in string X from right | -
Date functions | Example
--- | ---
date () | produces current date | -
date (YYYY, MM, DD) | produces date according to specified year (YYYY), month (MM), and day (DD) | date (2008, 5, 1) = 1 May 2008
Related topics CRM – attributes in the Text Editor CRM – predefined variables in the Text Editor CRM – examples of selection expressions CRM – overview |