On 04/26/2021, at 12:53, Joel Braverman mailto:joeljbr...@gmail.com>> wrote:
> have a few thousand of these:
> '199','627','1151','1249','1557','1558','1565','1689','1693','1711','1770','1780'
>
> I want to break them up into subgroups as our SQL system chokes at > 4000
> items in a query.
This breaks the items into groups of 3 — look for anything which isn’t a comma,
followed by a comma, repeat 3 times.
Find: ([^,]*,){3}
Replace: &\r
This drops everything after the first 3 items (needs a tweak to remove trailing
comma) — as above but also capture rest of line, and replace
have a few thousand of these:
'199','627','1151','1249','1557','1558','1565','1689','1693','1711','1770','1780'
I want to break them up into subgroups as our SQL system chokes at > 4000
items in a query. How do I do that? I found a regex:
[^,\\w][^\\,]*[^,]
which seems to find all items, but