Community forum

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


stevja01
2013-08-08T15:36:59Z
Is there a task type or method used by anyone to do the following:

Add a header row to a data file. Today we use a .BAT script to append the header from one file to a new file, then we run another command to append the data to the new file to accomplish this. So in VisualCron we create a BAT script and use the Execute task type.
Sponsor
Forum information
Support
2013-08-08T16:51:49Z
What exactly do you mean by header? Just add a line on top of a text file?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
stevja01
2013-08-08T17:00:20Z
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


Support
2013-08-09T07:08:15Z
You should be able to use the Concatenate files Task for this.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
stevja01
2013-08-09T13:36:36Z
Thanks Henrik, sorry I should have tried that, I'll see if that does the trick.
Scroll to Top