I have 4623 Sent ids (sentences) and each is 10,000 characters long. I want to divide them into 32-40 character long chunks.
I suppose replace {1,5} with {32,40} should work...the question is what is so special about 32-40 and why a range instead of just saying 40? Does it really matter if the final group is less than 32 (assuming every other group was 40)?
SELECT regexp_matches[1] FROM regexp_matches('0123456789012','(.{1,5})','g')