Column and Row separator in Multiload

Tools

Column and Row separator in Multiload

Hello All,

I am getting a flat file with different delimiters for column and row. For an example

abc,def,xyz]

abc,def,xyz]

abc,def,xyz]

Column  delimiter is  comma (,)

Row delimiter is ]

I have used FORMAT VARCHAR ',' for column delimiter but not sure how to override the row delimiter.

Please advice.

Tags (1)
1 REPLY

Re: Column and Row separator in Multiload

You can use FILLER with CHAR(1) at the end.