View Single Post
  #1  
Old 04-23-2008, 07:31 AM
teognost teognost is online now
Registered User
 
Join Date: 05-25-2004
Location: Prague,Czech Republic
Posts: 200
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?
Attached Files
File Type: bld removebrackets.bld (1.8 KB, 807 views)
Reply With Quote