title: Using regex formulas in SQL Server SSMS IDE
body: <p>I have the following query after Script table as INSERT: </p>
  
  <pre><code>INSERT INTO [DWH].[DimSharedDimensionEmployee]
         ([EmployeeId]
         ,[AdminFileId]
         ,[ManagerId]
         ,[EmployeeLastname]
         ,[EmployeeFirstname]
         ,[ManagerFirstname]
         ,[ManagerLastname]
         ,[EmployeeEmail]
         ,[ManagerEmail]
         ,[EmployeeTrigram]
         ,[ManagerTrigram]
         ,[MainFunction]
         ,[EmployeeStatus]
         ,[EmployeeType]
         ,[Gender]
         ,[Department]
         ,[Governance]
         ,[IsWantedBack]
         ,[IsPhysicallyInOffice]
         ,[ContractType]
         ,[BillingTo]
         ,[WorkingFor]
         ,[HostedBy]
         ,[EmployedBy]
         ,[OfficeExtension]
         ,[Office]
         ,[FirstEntryDate]
         ,[EntryDate]
         ,[ExitDate]
         ,[PreferredLanguage]
         ,[BirthDate]
         ,[BirthPlace]
         ,[Nationnalities]
         ,[RecentDiploma]
         ,[RecentSchool]
         ,[RDYearObtained]
         ,[MaritalSituation]
         ,[CurrentRecord]
         ,[BI_StartDate]
         ,[BI_EndDate])
   VALUES
         (&lt;EmployeeId, int,&gt;
         ,&lt;AdminFileId, int,&gt;
         ,&lt;ManagerId, int,&gt;
         ,&lt;EmployeeLastname, nvarchar(50),&gt;
         ,&lt;EmployeeFirstname, nvarchar(50),&gt;
         ,&lt;ManagerFirstname, nvarchar(50),&gt;
         ,&lt;ManagerLastname, nvarchar(50),&gt;
         ,&lt;EmployeeEmail, nvarchar(100),&gt;
         ,&lt;ManagerEmail, nvarchar(100),&gt;
         ,&lt;EmployeeTrigram, nvarchar(5),&gt;
         ,&lt;ManagerTrigram, nvarchar(5),&gt;
         ,&lt;MainFunction, nvarchar(1024),&gt;
         ,&lt;EmployeeStatus, nvarchar(255),&gt;
         ,&lt;EmployeeType, nvarchar(255),&gt;
         ,&lt;Gender, nvarchar(20),&gt;
         ,&lt;Department, nvarchar(1024),&gt;
         ,&lt;Governance, nvarchar(1024),&gt;
         ,&lt;IsWantedBack, bit,&gt;
         ,&lt;IsPhysicallyInOffice, bit,&gt;
         ,&lt;ContractType, nvarchar(255),&gt;
         ,&lt;BillingTo, nvarchar(50),&gt;
         ,&lt;WorkingFor, nvarchar(50),&gt;
         ,&lt;HostedBy, nvarchar(50),&gt;
         ,&lt;EmployedBy, nvarchar(50),&gt;
         ,&lt;OfficeExtension, nvarchar(max),&gt;
         ,&lt;Office, nvarchar(max),&gt;
         ,&lt;FirstEntryDate, datetime2(7),&gt;
         ,&lt;EntryDate, datetime2(7),&gt;
         ,&lt;ExitDate, datetime2(7),&gt;
         ,&lt;PreferredLanguage, varchar(128),&gt;
         ,&lt;BirthDate, datetime2(7),&gt;
         ,&lt;BirthPlace, nvarchar(max),&gt;
         ,&lt;Nationnalities, nvarchar(max),&gt;
         ,&lt;RecentDiploma, nvarchar(max),&gt;
         ,&lt;RecentSchool, nvarchar(256),&gt;
         ,&lt;RDYearObtained, int,&gt;
         ,&lt;MaritalSituation, varchar(25),&gt;
         ,&lt;CurrentRecord, bit,&gt;
         ,&lt;BI_StartDate, datetime2(7),&gt;
         ,&lt;BI_EndDate, datetime2(7),&gt;)
  </code></pre>
  
  <p>I copy and paste it in SSMS and want to replace the values by ? in order to use it in SSIS. I want to use a regex formula here : </p>
  
  <p><a href="https://i.stack.imgur.com/QsMPp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QsMPp.png" alt="enter image description here"></a></p>