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

Creating a comma delimited file

I need to create a comma delimited file and I'm trying to use CPYTOIMPF: CPYTOIMPF FROMFILE(MYLIB/MYFILE MYMBR) TOSTMF('/MYFLR/MYFILE.CSV') MBROPT(*REPLACE) STMFCODPAG(*STDASCII) RCDDLM(*CRLF) STRDLM(*NONE) FLDDLM(',').

For some reason the resulting file is created with the commas, but in fixed locations: each field is padded with blanks on the right. Is there any way to get rid of the blanks?


Write a simple program to strip them, or use one of the freeware utilities that will convert spooled files to .CSV files.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: tips, tutorials and more.

Ask your OS/400 questions--or help out your peers by answering them--in our live OS/400 discussion forums.


This was last published in January 2002

Dig Deeper on Installation

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.

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

Specify Value for Parameter RMVBLANK

Type choice, press Enter.


Remove blanks . . . . . . . . . *NONE

*NONE
*LEADING
*TRAILING
*BOTH
*EOR
Cancel

-ADS BY GOOGLE

SearchDataCenter

Close