Community

Does anyone know if it is possible to automate the process of merging three text files into one textfile each week? This will be a recurring process. For example, I need to submit a Positive Pay reconciliation to the bank each week in one text file. Currently I have 3 separate text files that consist of a Header, Details, and Trailer. This is a Fixed Width Text files that need to be combined. Can anyone help? Thanks.

1. Could make a macro using File/Open, then Edit/Insert/Files or FileName. then File/SaveAs. Would need to always have the same filenames for the macro to work.

2. Could create a batch file to append the files with Xcopy and call the batch file using Tools. Could use wildcards for filenames if different each week.

May need to add extra steps to remove lines with extra header/footers. That could be done on the final combined file with a RegEx

Thank you Bob. I was able to do the batch file and it worked.

And it only took less than three minutes!

I actually went to expert exchange and received this answer to create a .bat file

@echo off
cls
set file1=BOAHeader.txt

set file2=BOADetails.txt

set file3=BOATrailer.txt

set dest=BOAPPOutput.txt

type %file1% > %dest%
type %file2% >> %dest%
type %file3% >> %dest%

I did this earlier. However, thanks again for your response.

What about making a file called "MyCopy.bat" containing -

@echo off
copy %1 + %2 + %3 %4


Then call
MyCopy BOAHeader.txt BOADetails.txt BOATrailer.txt BOAPPOutput

Alan

Thank you, I will try that.