Q
Problem solve Get help with specific problems with your technologies, process and projects.

Trimming blanks

One Search400.com member writes, " How can I remove blanks when doing an FTP? If the field is "Jack," I would like to end up with "Jack" and not "Jack ". I have looked at your response for the CPYTOIMPF and do not see the option you are talking about." Search400.com expert Shahar Mor responds.

 How can I remove blanks when doing an FTP?  If the field is "Jack," I would like to end up with "Jack" and not  "Jack      ".   I have looked at your response for the CPYTOIMPF and do not see the option you are talking about.
If CPYTOIMPF does not serve you properly you may consider using the SQL2CSV utility from .x1YUb27p2Cz.5@.6aed3f76>here. This utility allows for converting SQL statement to CSV (i.e. select trim (name) will trim the blanks).
This was last published in October 2005

Dig Deeper on FTP

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close