Hi
I have created a flat file destinations from our SQL view to a csv file. It exports ok except the format seems to be getting corrupt on export.
The field in questions is a long text filed which as other characters in other than comma's. For example a colon
). I think this is then creating carriage returns.
Does anyone know how to get it so it ignores these and then create the text file correctly.
Thanks
I have created a flat file destinations from our SQL view to a csv file. It exports ok except the format seems to be getting corrupt on export.
The field in questions is a long text filed which as other characters in other than comma's. For example a colon
). I think this is then creating carriage returns.Does anyone know how to get it so it ignores these and then create the text file correctly.
Thanks