Password Policy

^(?=.*\d)(?=.*[A-Za-z])(?=.*\W)(?=.*\d)(.{5,10})$

Regex for replacing data into SQL query by using VS

Search Expression

^{:z},{[0-9A-Z ]+},{:z}$

Replace Expression

INSERT INTO TRAN_ERROR_MAPPING
 (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) \n\t 
VALUES('HOST','\1','\3','Administrator','Administrator')\nGO\n\n

Data

058,Request Timed Out,58
004,Low Balance,04
001,Limit Exceeded,01
003,Account Inactive,03
008,Invalid Card Record,07
010,Duplicate Transaction,10
011,Invalid Transaction Code,11
113,Database Error,13
024,Invalid TIN,62
050,Invalid Host Status,50
059,Host Reject,95
055,Host Comms Down,55
051,Host Not Processing,51
050,Host Not Found,50
075,Unknown Transaction Source,30
094,Permission Denied,94
002,Invalid Account,02
080,Message Format Error,28
060,PIN Retries Exceeded,60
014,Warm Card,14
015,Hot Card,15
098,Original Amount Incorrect,98
090,Customer Record Not Found,90
052,Host Busy,53
057,System Error,31
057,System Error,29
024,Incorrect PIN,24
113,Data Source Not Supported,74
003,Account Inactive,67
080,Message Format Error,80
016,Bad Card Status,16

Converted data to SQL queries

INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','058','58','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','004','04','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','001','01','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','003','03','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','008','07','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','010','10','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','011','11','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','113','13','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','024','62','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','050','50','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','059','95','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','055','55','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','051','51','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','050','50','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','075','30','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','094','94','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','002','02','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','080','28','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','060','60','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','014','14','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','015','15','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','098','98','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','090','90','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','052','53','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','057','31','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','057','29','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','024','24','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','113','74','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','003','67','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','080','80','Administrator','Administrator')
GO


INSERT INTO TRAN_ERROR_MAPPING (CHANNEL_CODE,ERROR_CODE,MAPPED_ERROR,CREATED_BY,UPDATED_BY) 
VALUES('HOST','016','16','Administrator','Administrator')
GO