Beautifier and commas

[Karl Tinsley]

I find the beautifier to be very handy for cleaning my sometimes less-than-consistent code formatting. I have a question about setting up the beautifier.

With the default settings, the beautifier formats my code like so:
Select first_thing,
second_thing,
third_thing

Is it possible to set the beautifier to format the above like this:
Select first_thing
, second_thing
, third_thing

Thanks in advance,

Karl

 

[Marco Kalter]

You will need to edit your beautifier rules (Edit > PL/SQL Beautifier Options), go to the DML tab page, and disable the "Comma after item" option for select statements.

 

[Karl Tinsley]

Perfect!

And thanks for the very quick response. Love your program -- keep up the great work.

Karl

 

[William Robertson]

Except that will give

SELECT first_thing
      ,second_thing
      ,third_thing
FROM   dual;

The vertical selection feature (alt-click) is helpful with moving the commas one place to the left, i.e:

SELECT first_thing
     , second_thing
     , third_thing
FROM   dual;

Or I guess you can globally replace 6 spaces + comma with 5 spaces + comma + space.

Will the beautifier one day be able to do this automatically? It's kind of a chore.

 

[Marco Kalter]

Will the beautifier one day be able to do this automatically?

I have added this to the list of enhancement requests.

It's kind of a chore.

Then don't do it . Just accept what you get right now.