Removing zeros from .csv file

30 pts.
Tags:
AS/400
CPYTOIMPF
CSV
I'm creating a .csv file using CPYTOIMPF Command.. I have a numeric Field in the File. I want to remove the zeros since i am not using it regularly. Pls help me

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    Whatever is in the file goes to the .csv .. You could copy the file to one that doesn't have that column and use that file to create the .csv. Phil
    50,205 pointsBadges:
    report
  • TomLiotta
    I want to remove the zeros since i am not using it regularly. What do you mean "regularly"? Does it mean that you don't often use the numeric field? Does it mean that you use the numeric field in an irregular way? Does it mean that you use the .CSV file in an irregular way? CPYTOIMPF is intended as a DB2 database EXPORT function. It can be used for general .CSV creation, but that's not how it should be expected to work. If it doesn't work as you need, you have two general options. First, don't use CPYTOIMPF. Use a different function such as downloading to Excel and saving the result as a .CSV from Excel, or searching the internet for one of the various .CSV creation tools that others have made available. Because you are the one who knows your requirements, you are the one who would know which tool works as you need. Or create a new file description that presents the data in the column without leading zeros. You can create a SQL VIEW for example, that would do that. Then use CPYTOIMPF to export that VIEW. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following