s like Split Field transformation's Seperator setting, the Delimiter setting of Merge and Prefix & Suffix setting of Append Text transformations also going to be supported non-printable special characters -> space, tab. return and newline.
So, we need to create kb article for these two transformation similar to what we have now for Split transformation (How to use DataBridge Transformation to split a field with a separator and add a new field with selected segment(s) To make sure special, ‘invisible’ characters can be replaced from source data or found in source data, use this syntax to indicate the ‘invisible’ character to look for
[:space:]
[:tab:]
[:newline:]
[:return:]
Use lowercase text.
This syntax is used in the Replace Text transformation and the Split Field transformation.