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
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.