Difference In File Size Between Fixed Width and Comma Delimitted File
Posted on 2016-11-18
I have a query that I'm exporting. It has about 19,000 records in it about about 166 columns total. I went through the Wizard to create the spec for the file and when it goes to export, the file is about 284 Mb's in size, which is crazy. If I export it as a comma delimitted text file, the file is about 30mbs. I need the file to stay in a specific format to feed into a vendor's site, which is why I did the spec wizard. Does anyone have any idea why the fixed format length would create such a huge file? Or can someone offer another suggestion for exporting this as a text file with fixed width columns?
Any help would be great appreciated.