Some of the methods used to process text replace this task are either good or bad, and you may leave a comment to yourself.

I remember when I was just working, I had to generate some other data insertion scripts based on the results output by the SQL Server Enterprise Manager. This makes it difficult for me to be a new employee, copy & paste was adopted immediately. After being discovered by the boss, he immediately scolded me and taught me to use the powerful Excel tool ~ After the old general data is copied to the Excel file, the new columns are added to each column, and the statement templates are added to these new columns respectively, then, I thought it was very advanced to repeat these templates into each row using Excel. Now, I have an eye open. It is much better than my own C & P method, and I sigh that my skills are poor.

Not much time has elapsed to find that SQL select statements can output some text at will. These data connection script templates can be output together and displayed in the SQL Server Enterprise Manager as text. It is more convenient than using Excel.

After some time in contact with. net, I used the method of reading text files for similar practices, but I always felt that the task was too small to pay.

In the past year, I finally had some knowledge of the Regular Expression and started to apply it to my daily work, currently, to replace a text file with Perl, you only need a few commands and some simple regular expressions. The efficiency has reached the peak, I also feel that I have improved a lot and it is imperative to learn Regular Expressions well.

I have seen my progress through the different processing methods that have worked the same way over the past few times ~

Take a good look at mastering regular expressions ~ This is not a tool book, it is not used to read and view it at will, but should be studied in an orderly manner under the lamp.