Basically i'm writing a program to take data from an sql server and export it to a text file.
But in between the fields there are spaces which I have not yet been able to remove.

More Importantly, when the field is negative the sign is put in front of the number. I need to take out the negative sign and insert a trailing negative, which would be a empty space if there was no negative.

So far looking around I believe I need a data format object. But I could be wrong.. does anyone know what i'm doing wrong.. if what I want is possible or not??

Thank you for your help
~Jay