Replace with newline character

2011-09-30 Thread mweisman
I have some very long sql queries that are stored in a single line with statements separated by a ; to get around a bug in a program I use that limits me to single line queries. When I need to make changes to the queries, I like to split them out into multiple lines to make them readable. Most

Re: Replace with newline character

2011-09-30 Thread Lee Hinde
You can type option-return in the replace box after the semi-colon. Find: ; Replace ; option-return On Sep 30, 2011, at 9:40 AM, mweisman wrote: I have some very long sql queries that are stored in a single line with statements separated by a ; to get around a bug in a program I use that

Re: Replace with newline character

2011-09-30 Thread Fletcher Sandbeck
On Sep 30, 2011, at 9:40 AM, mweisman wrote: I have some very long sql queries that are stored in a single line with statements separated by a ; to get around a bug in a program I use that limits me to single line queries. When I need to make changes to the queries, I like to split them out

Re: Replace with newline character

2011-09-30 Thread Doug McNutt
At 09:49 -0700 9/30/11, Fletcher Sandbeck wrote: Remember that bbedit works with everything as 16 bit unicode. There, all line ends are Apple style 000D entries. Regardless of what will come out on a save you have to check for 0D while it's in memory. It was once true that, for Apple

Re: Replace with newline character

2011-09-30 Thread Rod Buchanan
On Sep 30, 2011, at 11:40 AM, mweisman wrote: I have some very long sql queries that are stored in a single line with statements separated by a ; to get around a bug in a program I use that limits me to single line queries. When I need to make changes to the queries, I like to split them out