Export text file with structure (dash and pipe characters)

KNIME Analytics Platform
2

See if this helps.

If you need to rename the columns you can us either the Column Renamer or Table Manipulation nodes. Have you tried saving the file as txt inside Excel?