Append and prepend text parser

Configuration options

  • Append text - Add the configured text to the end of the current value.
  • Prepend text - Add the configured text to the beginning of the current value.
  • Text to place - The fixed text to add. Escape sequences such as \n, \r and \t can be used.

Prepend text

Use Prepend when every value needs the same prefix.

Source:
ABC-123

Prepend:
SKU-

Result:
SKU-ABC-123

Append text

Use Append when every value needs the same suffix.

Source:
24.99

Append:
 USD

Result:
24.99 USD

Add line breaks or tabs

The inserted text can contain escape sequences.

Sequence Use
\n Add a line break.
\r Add a carriage return.
\t Add a tab.

This is useful when preparing values for text-based exports or when another parser expects a particular separator.

Use Parser rather than changing the selector

Use Parser when the extracted value is correct but needs a fixed prefix or suffix.

Appending text to URLs

Append and prepend text always adds the configured text. If some URL values are relative and others are already complete URLs, use Replace text with an appropriate pattern instead so only the relative values are changed.

Parser order

The parser uses the value produced by the parser before it. Place it after any cleaning or extraction steps when the added text should apply to the final cleaned value.

Raw value
→ Regex match
→ Remove whitespaces
→ Append text

Empty values

Review the Parser preview when the source column can be empty. Adding fixed text to an empty source may not represent the intended final data. If the output requires conditional behavior, consider whether Replace text or another transformation is more appropriate.

Troubleshooting

  • If text is added in the wrong position, confirm whether Append text or Prepend text is selected.
  • If spacing is incorrect, include the required space in Text to place.
  • If only some records should receive the text, use a conditional pattern with Replace text instead of applying a fixed append/prepend to every value.
  • Check parser order when the added text is later changed or removed by another parser.

Related