Different spacing around commas for lists

2 Posts
2 Users
0 Reactions
535 Views
Posts: 8
Topic starter
(@lamprey)
Member
Joined: 4 years ago
[#50]

Hi,

I’ve been able to get most of the formatting the way I want. But, there are two things that ae in conflict with the current configuration options. As far as I can tell there is only one White Space setting dealing with commas. It would be nice if there were two settings, an additional one for Lists.

Currently, I have the white space “around commas” set to Once Space After and that works great for general formatting when dealing with functions. In this example it puts one space after the commas:

string_agg(convert(nvarchar(max), foo_id), N'; ') within group (order by foo_id) as foo_id_list

 

But, when it comes to Lists (like a select list) it also put a space after the comma. For example:

select
	foo
	, foo1
	, foo2

My request is to keep the white space setting as is for “non-list” items and add a new option for lists (select, group by, etc.). So, for example the select list could be like:

select
	foo
	,foo1
	,foo2

I realize it’s not too hard to fix this up post-format, but it would be a nice option.

Thanks!

 

 


1 Reply
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

Hi Lamprey, thanks for this idea. I have to think about how to introduce this idea without confusing users with too many options.

Give me some time please

Regards

Guido


Reply
Share: