I am trying to reconstruct some lines from a flat file (processed in the port pipeline) in an orchestration by concatenating elements in a transformation. The problem is that elements in the flat file that contained only spaces are truncated to empty strings. Elements with text and padded spaces are kept in that condition (Pad Character Type = None). How can I keep spaces in empty elements???
An alternative would be to have a flat file schema that both transforms a line to several elements and then keeps the same line as one element. But I cannot find a way to do that. E.g. for one line in a flat file:
"abc ghi" ->
<something name="abc " address=" " code=" ghi" line = "abc ghi" >
Do you have any suggestions how to either keep spaces for empty elements or to process same line twice in flat file processing.
Thanks for your help!