|I have a series of TXT files that are more or less transaction logs. I am trying to combine all of the files into a single file that can be brought into Excel. If I just copied them all together, the resulting data would appear redundant as some of the files have the same transactions.|
Ideally, I am trying to insert the filename of the text file at the beggining of each line in the text file. This would then allow me to concatenate all the files together and still know exactly where each row came from.
Of course, if that can't be batched, I would certainly be able to make due with a batch that insert a specific string of text into each line a specific file.
I've seen some possible solutions with SED but I can't find any that would batch through a folder of TXT files, grab the filename and then insert it into each file.
I humbly request help from those who can work a FOR TOKENS command like a Pro.