Note:fileA.sql under db-126.96.36.199/sir-abcd may not be the same as fileA.sql under db-188.8.131.52/sir-xyz
Therefore output could be:
db-184.108.40.206/sir-abcd:fileA:1234: update ...... full statement until a ";" is located
db-220.127.116.11/sir-xyz:fileA:675: alter table .... full statement until a ";" is located
directory_path:fileB:NNNN: delete ....
Note: ordering of db-18.104.22.168, db-22.214.171.124 is important
Email validation in proper way is very important validation required in any web pages.
This code is self explainable except that Regular Expression which I used for pattern matching.
I originally published as a thread on my website : http://www…