Hi,

I try to find split a given String into parts.

The string is a SELECT SQL from CURSORGETPROP('SQL',ALIAS())

I like to add a CHR(13) after each field.

So as far as I understand i need to replace al ',' with ','+CHR(13), but only those that are not wraped in "" '' [] ().

How do I find those signs?

Example:

Source = "SELECT aField, bField AS Field2, [, ]+PADR(cField,2) AS cField ..."
Result: "SELECT aField,"+CHR(13)+" bField AS Field2,"+CHR(13)+" [, ]+PADR(cField,2) AS cField ..."

Agnes