concat(a,b,c,d,e,f,g,h, [CR-support i])
|
Group |
Returns the concatenation of the values a to h.
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 |
Value. |
|
d |
Value. |
|
e |
Value. |
|
f |
Value. |
|
g |
Value. |
|
h |
Value. |
|
i |
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 |
b |
c |
d |
e |
f |
g |
h |
i |
Result |
|
Hell |
o world |
true |
Hello world |
||||||
|
H |
e |
l |
l |
o |
world |
! |
true |
Hello world! |
|
|
Hello\NL |
beautiful |
_world |
|
|
|
|
|
true |
Hello beautiful_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).