On Mar 28, 2007, at 5:25 PM, Dr Gerard Hammond wrote:
> Hi,
>
> I have a long file full of INSERT, UPDATE and SELECT statements.
> Does anybody have a piece of RegEx code that'll split the lines
> reliably into individual SQL statements.
> RegEx and I don't normally get on.
>
> Files typically look like this.
Do you need to maintain returns in the textual items you have in the
mail or are those long fields that have been wrapped by mail ?
If not I'd try to do this in 2 steps in BBEdit :)
Remove all line endings
Then turn all ; into ; + an end of line
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
|