The customer is going crazy that when I FTP the file there are trailing spaces after all the 0001 and 2011 record types I built. The 2000 record type looks okay.
The difference is that the 0001 and 2011 records final/last field is being supressed, so this command seems to move spaces into the record to make up for it not being there.
Should I move nulls or low-values to the record before I string the fields to it? Should I "delimiting by" with something else?
If you can think of anything to try, please advise.
Thank you so much for your help.
~Sharon
Edited: Please use BBcode when You post some code, that's rather readable, Thanks...Anuj
I tried the FTP using TRAILINGBLANKS False and it still didnt seem to help,
so Im going to rewrite the program to write alternative records when the final field is spaces.
Is there anythng I can do to remove the "square" carraige return that the FTP puts at the end of each line?