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?
|