Toad World® Forums

Is it possible to do find and replace with regular expressions in toad automation?

I am trying to take a log file, strip out a bunch of messages and load it into a sql table. I have created 8 regular expressions to run for Find and Replace. I need to refresh my data daily and want this automated.

Is there a way to do this using Toad Data Point?

TIA

Although the find and replace in Toad Data Point supports regular expressions (Main Menu - Edit> Find & Replace), the find & replace in automation does not. Automation does, however, support kicking off an outside program - so if there was a way you could use an outside program to run your Find and Replace you could include that in a Toad Data Point automation. Sorry could not find a way to do this in Toad Data Point automation!