Hi,

At work I have been asked to tell my manager what is different between 2 text files. The data in the text files is a bunch of SQL Statements. Most of them are super long strings. I have the comparison part down & know what is different. I have to now build a report to outline the differences. They said they would accept it in Word or Excel. I am opting for xl.

The part I need help with is some VBA logic to break the SQL Statement into smaller bite size chunks. I was thinking of trying to use VBA's Split function to split the SQL Statements on SQL Keywords.

Maybe there is a program that already does this. Like a feature in Sublime Text or something. If there is please mention it.

If you know of a post where someone has already worked something like this out please point me in the right direction. I can’t be the 1st or only person who has had to do this.

TIA