I am getting a flat file with different delimiters for column and row. For an example
Column delimiter is comma (,)
Row delimiter is ]
I have used FORMAT VARCHAR ',' for column delimiter but not sure how to override the row delimiter.
You can use FILLER with CHAR(1) at the end.