One Way to Deal with DAT Files

This workflow demonstrates a way to restructure your .DAT table in KNIME to something workable. But please note that this relies upon the fact that most of the columns are separated by at least 2 spaces. I use that info for my delimiter decision during file reading. If your new .dat files in the future doesn’t fit this rule, my method won’t work on them.

The last two nodes are not mandatory, because they are needed for the specific case of the sample file used here. You'll be needing only the first three nodes.

Note that the sample file used is .txt, since this is what's being provided by the forum user. The workflow should work for all DAT Files whose columns are separated by at least 2 spaces apart.

External resources

• hub.knime.com/badger101