I blew it. I removed all the commas from a field that contains a comma delimited list. Luckily it's a consistent condition to put the commas back, but I can not find anywhere on the web specific to what I need and I'm just a little STRESSED!
I need to add the comma after every fifth char and each group of 5 starts with a 4. It is a char field, not a number field for other reasons. So a string like this
410124101541018 needs to be this 41012,41015.41018.
I am going to have to do this for other length groups as well, but the way I've validated that this particular bunch of strings are divisible by five with a remainder of zero is this: where MOD(MY_STRING, 5) = 0
I've been fooling around with INSTR, SUBSTR, REGEXA_SUBSTR, and REPLACE
Your help is greatly appreciated.
I've got to get this done pronto.
THANK YOU THANK YOU