File transfer
I would like to get the AS400 data into text file with no spaces between the fileds. Is there any way to do that?
Software/Hardware used:
AS400
Software/Hardware used:
AS400
ASKED:
June 14, 2012 5:51 AM
UPDATED:
June 15, 2012 3:49 PM
Answer Wiki:
Just curious as to why you want to eliminate the space between fields.
Eliminating all spaces between fields will make it hard id not impossible to read if there
are numeric fields included.
Are you going to need to parse this out with another program/utility after the load to a test file ? If so how will you determine the break?
To see all answers submitted to the Answer Wiki: View Answer History.
Is there any way to do that?
Remove your code that puts the spaces in when you write the text file. That’s probably the best way.
But you haven’t said anything about what you’re doing, about how you’re doing it. There’s no good way to suggest a way until you describe your process. Most helpful would be showing us your code.
Tom
Don’t you want a field delimiter .. say , tab or |???
This might help
Copy To Import File (CPYTOIMPF)
Remove blanks . . . . . . . . . *BOTH