PDA

View Full Version : 'Replace in File' Parse Error


04-18-2005, 12:02 PM
I have a number of .TAB sql files in a folder that I want to replace text within.
I want to replace
CREATE TABLE [[dbo]].[[
with
CREATE TABLE [[dbo]].[[#
obviously to make temporary tables from script.
I am getting the error "Unmatched [ or [^"
If I just use one square bracket per position, ie using
CREATE TABLE [dbo].[
I get the error"Error expanding macros in property Find: <Error parsing scripts: Unrecoverable Parse Error at position 20 - expecting {section}>"


How do I do the above, Thanks, Mike

kevina
04-18-2005, 02:58 PM
Check the Replace In File step's "Treat all characters as literals (no regular expressions) checkbox.

kinook
04-27-2005, 08:36 AM
http://www.kinook.com/Forum/showthread.php?threadid=380