Home > IT Answers > FTP Field seperator
vibgyor
280 pts.
 FTP Field seperator
FTP Column seperator
Can we provide a tab or '~' symbol between each fields in the text file while doing an FTP?

I need a column seperator between two coulmns in my text File. It will be good if the column sepertaor can be a tab ot '~' symbol.

 



Software/Hardware used:
AS400
ASKED: May 7, 2012  7:27 AM
UPDATED: May 8, 2012  12:15 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

FTP will not add delimiters to your data. You should look at the CPYTOIMPF command to create a delimited file and FTP that

BigKat
 7,185 pts.
 

Can we provide a tab or ‘~’ symbol between each fields in the text file while doing an FTP?

No. FTP only transfers record images. If the records don’t have delimiters, then FTP won’t send them.

If you need delimiters, put them into the file before using FTP. Usually, the easiest way to create a copy of a database file that has delimiters inserted is to use the CPYTOIMPF command. Then use FTP to send the copy that you created.

Tom

TomLiotta
 108,085 pts.