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

Removing trailing blanks on text fields

When using CPYTOIMPF, I can get a very nice CSV file except for one problem. I can't figure out how to remove the trailing blanks on text fields? For example, "Description" instead of "Description ". Any suggestions would be greatly appreciated. I'm on V4R5.
As far as I know and tested, the trailing blanks are trimmed. If one of the end-of-line character options is selected (ENDLINFMT(*FIXED) is not specified) the database file records are transformed to variable-length stream file text lines as they are copied. Each database file record is trimmed of any trailing blanks. Then, the data is converted to the destination data format (if specified) and the end-of-line character is appended to the end of the text line.


Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: Tips, tutorials and more.

Check out this Search400.com Featured Topic: Networking and the iSeries

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

Dig Deeper on FTP

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.