All Forums Tools
TDUser2000 17 posts Joined 07/12
06 Mar 2013
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.
 
 
 
 

KS42982 137 posts Joined 12/12
07 Mar 2013

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

You must sign in to leave a comment.