All Forums Tools
hakme 3 posts Joined 09/11
15 Oct 2014
Load qouted data with delimiter chanrater in values

Hi,
Can we load the below data using Bteq/Mload 13.0 . Please suggest
3 columns with ',' as delimiter and enclosed by quotes with ',' and qoutes possible in values. Can escape the quotes in the values with another quote.
Values:
"abcdef","ghi,jkl","mn""o,p"
Thanks

Thanks Hakme!!!!
feinholz 1234 posts Joined 05/08
15 Oct 2014

Yes you can with MultiLoad. But not with version 13.0.
I believe the first version with the "quoted data" feature was 14.0.
The MultiLoad Reference Manual will have the commands necessary for this feature.
(As a side note, 13.0 is not a supported version of TTU.)
 

--SteveF

You must sign in to leave a comment.