Trim white space
Please add an option be added to SQL Prompt to trim all white space.
Ideally, the following would be supported:
- Ability to execute against a query window or block of selected code
- Available as a stand-alone shortcut
- Can include as part of a Format SQL style
- Option to remove a) leading spaces, b) trailing spaces, c) both
![](https://secure.gravatar.com/avatar/3e06bf284f85706c7c840061e972051c?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Thomas Franz commented
you can unformat to remove tab / space / crlf in the selected text and change it into a single line (it ensures, that there is one space when replacing crlf, so your code won't break).
Not exactly what you want, but helps a lot (e.g. when you have a long IN()-List or to wrap the column list in an INSERT statement
-
Tim Goergen commented
I would especially like to see this as a stand-alone shortcut, without having to apply all formatting rules.