concat( a, b, [CR-support c] )
|
Group |
Returns the concatenation of the values a and b.
Note: Please note that this function also allows 'hidden' values as parameters and treats them like 'real' values. See the explanations for the Empty Flag.
Description of Parameters
|
Parameter |
Description |
|
a |
Value. |
|
b |
Value. |
|
c |
Controls placeholder behaviour, see following table. Default: false. |
Available Placeholders
|
Placeholder |
Description |
|
\t or \TAB |
Will be converted to a tabulator. |
|
\NL |
Parameter c=true: Will be converted to LF (line feed). Parameter c=false: Will be converted to CR (carriage return) LF (line feed). |
|
\CR |
Parameter c=true: Will be converted to CR (carriage return). Parameter c=false: Placeholder is ignored. |
See the following examples. Note: If you use the output format CSV in Phase 6 (Content), the linebreaks will be escaped again, meaning that after inserting an LF, you will get a literal \NL again in your field. You can avoid this by using the Integration Unit CSVWithoutQuotesIU. See also section Content Settings. In addition, when inserting a Unicode character, make sure to select an output encoding that can actually represent this character properly (meaning it being part of the character set of the encoding).
Examples
|
Parameter a |
Parameter b |
Parameter c |
Result |
|
Hell |
o_world |
true |
Hello_World |
|
Hello\NL |
world |
true |
Hello world |
Note: If you are curious, open a result file in a file editor that can display control characters (for example, Notepad ++ or the internal editor in Lobster_data).