Toad World® Forums

Easy Formatter question


#1

This will probably be emabarrasingly simple to answer but I’m a total newcomer to Toad. Have literally just installed it and am customising options. I’ve come to the formatter and have noticed that when it formats a list array, it line breaks after every comma.

Example line:

row_id in (‘2-YBDXBYE’, ‘2-YBF9DPU’, ‘2-YBFMIYX’, ‘2-YBFMTPG’, ‘2-YBFXHR9’, ‘2-YBG5QK4’, ‘2-YBGODAD’, ‘2-YBGVKIB’)

after formatting becomes,
row_id IN

(‘2-YBDXBYE’,

‘2-YBF9DPU’,

‘2-YBFMIYX’,

‘2-YBFMTPG’,

‘2-YBFXHR9’,

‘2-YBG5QK4’,

‘2-YBGODAD’,

‘2-YBGVKIB’)

How exactly do I change it so it lists several per line before line break?
Appreciate any help!

Mike