Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Text Single Field Target Concatenation Table

Notes:

Anchor
Concatenation-Table-Notes
Concatenation-Table-Notes

  1. Where separator is non-configurable, the value “,” (comma) is implicitly used.

  2. Equivalent to "Set Field Value (Clear) (JSU)", “Clear Field Value (JSU)”

Source Value

Target Value

Concatenation Mode

Separator

Result

Notes

null

null

overwrite

"@@"

null

null

null

append

"@@"

null

null

null

prepend

"@@"

null

null

“TA”

overwrite

"@@"

null

null

“TA”

append

"@@"

“TA”

null

“TA”

prepend

"@@"

“TA”

[]

null

overwrite

"@@"

null

[]

null

append

"@@"

null

[]

null

prepend

"@@"

null

[]

“TA”

overwrite

"@@"

null

[]

“TA”

append

"@@"

“TA”

[]

“TA”

prepend

"@@"

“TA”

"SA"

null

overwrite

"@@"

“SA”

“SA”

null

append

"@@"

“SA”

“SA”

null

prepend

“@@”

“SA”

"SA"

“TA”

overwrite

"@@"

“SA”

"SA"

“TA”

append

"@@"

“TA@@SA”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

"SA"

“TA”

prepend

"@@"

“SA@@TA”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

[“SA”]

null

overwrite

“@@”

“SA”

[“SA”]

null

append

“@@”

“SA”

[“SA”]

null

prepend

“@@”

“SA”

[“SA”]

“TA”

overwrite

“@@”

“SA”

[“SA”]

“TA”

append

“@@”

“TA@@SA”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

[“SA”]

“TA”

prepend

“@@”

“SA@@TA”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

[“SA”, “SB”]

null

overwrite

“@@”

“SA@@SB”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

[“SA”, “SB”]

null

append

“@@”

“SA@@SB”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

[“SA”, “SB”]

null

prepend

“@@”

“SA@@SB”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

[“SA”, “SB”]

“TA”

overwrite

“@@”

“SA@@SB”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

[“SA”, “SB”]

“TA”

append

“@@”

“TA@@SA@@SB”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

[“SA”, “SB”]

“TA”

prepend

“@@”

“SA@@SB@@TA”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

Empty Pseudo Value

null

overwrite

“@@”

nullEquivalent to "Set Field Value (Clear) (JSU)", “Clear Field Value (JSU)”

see note: 2

Empty Pseudo Value

null

append

“@@”

“@@”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

Empty Pseudo Value

null

prepend

“@@”

“@@”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

Empty Pseudo Value

“TA”

overwrite

“@@”

nullEquivalent to "Set Field Value (Clear) (JSU)", “Clear Field Value (JSU)”

see note: 2

Empty Pseudo Value

“TA”

append

“@@”

“TA@@”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1

Empty Pseudo Value

“TA”

prepend

“@@”

“@@TA”Where separator is non-configurable, the value “,” (comma) is implicitly used.

see note: 1