| # Relation Management - Text Editor If you create a letter in the Letters (tdsmi1150m000) session, you use the Text Editor to define the actual layout of the letter. If you create a selection expression in the Selections (tdsmi0170m000) session, you use the Text Editor to create an expression. To use 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). Feature definitions You can use all features recorded in the Feature Definitions (tdsmi0550m000) session. For more information, refer to Relation Management - features in the Text Editor. Predefined variables For example, @today (gives current date). For more information, refer to Relation Management - predefined variables in the Text Editor It is recommended that you zoom and select table fields and features 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 feature definitions. 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 Relation Management - features in the Text Editor Relation Management - predefined variables in the Text Editor Relation Management - examples of selection expressions Overview of Relation Management |