Im exporting some data into a text file through a DTS package to automate a process. when the text file is generated, it is adding some spaces to the values, this is 1 record:"C","28958 ","FEDEX Employees Credit Association ","3955 Airways Blvd. ","Memphis "," ","TN ","38116 ","US ","30351001 "," "," "," "," ","24 Hours ","Walk Up "," "," "," "," "," "," "," "," ","1 "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ","FEDEX Employees Credit Association ","Cash Dispenser "," "," "," "
How can I remove all the unwanted spaces during the export?
Trimming
Posted - 2006-08-08 : 13:42:27
