2019/10/31

How to match not string with C# regular expression ?

Regular expression:
INSERT INTO \[TABLICA_REJ\](?:(?!VALUES).)*VALUES \(([^,]+,){4}'(?[A-Z0-9]+)'
input:
IF NOT EXISTS (SELECT 1 FROM VEHICLE_PLATES WHERE id = 2191007153548014038060268115) INSERT INTO [VEHICLE_PLATES] ([id],[id2],[name],[name2],[number],[date]) VALUES (2191007153548014038060268115,2190926111229058038052754,'00','0','PZ407TV','2019-10-07 15:27:27');
Check in http://regexstorm.net
example and check
http://regexstorm.net/tester?p=INSERT+INTO+%5c%5bTABLICA_REJ%5c%5d%28%3f%3a%28%3f!VALUES%29.%29*VALUES+%5c%28%28%5b%5e%2c%5d%2b%2c%29%7b4%7d%27%28%3f%3ctab_rej%3e%5bA-Z0-9%5d%2b%29%27&i=IF+NOT+EXISTS+%28SELECT+1+FROM+TABLICA_REJ+WHERE+idr+%3d+2191007153548014038060268115%29%0d%0aINSERT+INTO+%5bTABLICA_REJ%5d+%28%5bidr%5d%2c%5bidw%5d%2c%5bwt_tr%5d%2c%5bkt_rej%5d%2c%5bnr_tab_rej%5d%2c%5bnr_tab_rej_dr%5d%2c%5bdt_wyd%5d%2c%5bdod_tab%5d%2c%5bdt_dodania_dod_tab%5d%2c%5bidentyfikatorSystemowyCepik%5d%2c%5bidentyfikatorStanuCepik%5d%2c%5bzwezone_litery%5d%29+VALUES+%282191007153548014038060268115%2c2190926111229058038052754%2c%2700%27%2c%270%27%2c%27PZ407TV%27%2c%27PZ+407TV%27%2c%272019-10-07+15%3a27%3a27%27%2c%270%27%2cNULL%2c4977814074663942%2c4619151641798971%2c1%29%3b%0d%0a&o=s