#1
|
|||
|
|||
Removing brackets from a text file
I have a text file like :
--ApplyTo:[Upgrade] bla bla --ApplyTo:[BusinessData] IF NOT EXISTS(SELECT * FROM syscolumns WHERE id = OBJECT_ID('[og].[ClearVisionExport]') AND name = 'UserComment') ALTER TABLE [og].[ClearVisionExport] ADD [UserComment] [VARCHAR] (4000) NULL --ApplyTo:[None] SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON I need to remove all the brackets after ApplyTo so : ApplyTo:[Upgrade] becomes ApplyTo:Upgrade ApplyTo:[BusinessData] becomes ApplyTo:BusinessData and so on. I tried to implement a replace step(see the attachment) but I cannot make it working. Any idea how to do this? |
|
|