Here's our business example:
1. We receive a product file from our client that has this layout, .txt FILE, PIPE delimited:
40720|ACME PRODUCT|BLUE|08/08/2013
40721|PAINT CAN|WHITE|08/15/2010
2. We create a header file, .txt FILE, PIPE delimited like this:
ITEM|ITEM DESCRIPTION|COLOR|EXPIRATION DATE
3. Our .bat script runs to merge both files, merging the contents of the header file first and a carriage return, then the data to create a file we can import that has this layout, .txt FILE, PIPE delimited:
ITEM|ITEM DESCRIPTION|COLOR|EXPIRATION DATE
40720|ACME PRODUCT|BLUE|08/08/2013
40721|PAINT CAN|WHITE|08/15/2010