Link to home
Start Free TrialLog in
Avatar of ChasDevlin
ChasDevlinFlag for United Kingdom of Great Britain and Northern Ireland

asked on

CPYTOIMPF

Copy to import file.

I got asked to use this command to create a semi-colon delimitted extract file.  The idea was to save space by avoiding blanks. But it keeps all blanks, even on numeric fields.  so I'm worse off than with a fixed position file (size wise.

We're on OS 4 release 3, does it get improved in later versions?  Any obvious parameter I've missed.

If I've got say text 30 and numeric 13.2 I end up with

"ANDY                            ";13.2               ;.....  etc

I tried making the text fields variable length fields but the command included the max field length it seems.

ASKER CERTIFIED SOLUTION
Avatar of Peter Price
Peter Price

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Moondancer
Moondancer

This question was LOCKED with a PROPOSED ANSWER and awaits your decision today.  Once a question is LOCKED with a Proposed Answer, few new experts will step in to help on that question, since the assumption is, you've been helped.  If the Proposed Answer helped you, please accept it and award that expert.  If it did not help you, please reject it and add comments as to status and what else is needed.
 
If you wish to award multiple experts, just comment here with detail, I'll respond as soon as possible.  As it stands today, you asked the question, got help and not one expert was awarded for the contribution(s) made.  Your response is needed.  I'll monitor through month end, and if you've not returned to complete this, we'll need to decide.  Expert input is welcome (as always) to determine the outcome here if the Asker does not respond.
 
Your response in finalizing this (and ALL) your question(s) is appreciated.
 
Moondancer
Community Support Moderator @ Experts Exchange

Finalized today by EE Moderator.