Skip to Content
Former Member
Aug 02, 2005 at 07:52 PM

XI and files with fixed length fields


I am new to XI and even though I have done a lot of research on XI, I still can’t find an answer to my question. I will be using XI to get flat files via FTP from an old DOS based system that the company still uses. The flat files that the DOS system produces are position sensitive(fixed width fields) and the different file structure all use the same name. Our current host system can distinguish what type of file it is by reading the second byte of the flat file. Each line of the flat file starts with a *# , with the # being a letter from A-Z. Can XI be configured to read the second byte of the file and insert the file into the proper table depending on what the second byte of the file is? Thank you.