Working on an application that imports excel spreadsheets, transforms the data into a specific formats, etc and then exports the data out to CSV files.
I append all the data to an export table right before I export it out.
I use a query as the export to get the exact fields I want, order, etc.
I have set an export specification that is comma delimited, no text qualifiers, etc.
My issue is that the application that uses these export files needs one of the numeric fields to be a single decimal.
For whatever reason it keeps exporting the numeric field as 2 decimals and it is driving me crazy.
I have set the table field to be a double with 1 decimal, so I know the data has only one decimal and I can see it sitting in the table correctly.
I have set the exporting query to format as general number with 1 decimal, but it still exports with 2 decimals.
Now, earlier in the project before I had really worked out all the bells and whistles it was exporting correctly with only 1 decimal. This was when I was just using a query to transform and export the data and not appending it to an export table first.
I am thinking there has to be a way to enforce the single decimal on the data that is exported? And if the data is sitting in the table with single decimal, why is it it exporting as 2?
Appreciate any input!
Thanks
jdawgwill