How to use regular expressions to modify data in batches in sublime

Sublime Text is a code editor (SublimeText2 is a paid software, but it can be tried indefinitely), and it is also an advanced text editor for HTML and prose. The following column sublime usage tutorial will explain to you the specific method of using regular regularization to modify data in batches in sublime. I hope it will be helpful to friends in need!

The requirements are as follows:

Remove the letters and numbers in front of these knowledge points

If Use PHP scripts to change items one by one. Because the amount of data is too large, it may cause data congestion or the server may crash.

Use the sublime editor to open the sql file of the table. Query these prefixes regularly, replace them with blanks in batches, and then rerun sql to generate the data table.

The regular statement is as follows:

This solves the seemingly complicated problem~

The above is the detailed content of How to use regular expressions to modify data in batches in sublime. For more information, please follow other related articles on the PHP Chinese website!