Forgive me if this has been addressed already.
I work with a lot of fixed length files with fields that range in size, but are not variable and the fields are not delimited. When I try to use the data viewer it appears to me that all of my fields "columns" must be the same size for the data viewer to interpret the data correctly.
Is there a way to specify different column sizes within a fixed file which is not delimited? Is this going to be supported in the future?
I think a good example of this is how MS Excel imports text files and allows you to define the field breaks by dropping/dragging lines. Or even better the spec files you can create in MS Access by defining the complete layout of a file by position.
I work with a lot of fixed length files with fields that range in size, but are not variable and the fields are not delimited. When I try to use the data viewer it appears to me that all of my fields "columns" must be the same size for the data viewer to interpret the data correctly.
Is there a way to specify different column sizes within a fixed file which is not delimited? Is this going to be supported in the future?
I think a good example of this is how MS Excel imports text files and allows you to define the field breaks by dropping/dragging lines. Or even better the spec files you can create in MS Access by defining the complete layout of a file by position.
Comment