Hello,
I am struggling to find a solution to the following: I would like to find a way using PL/SQL regexp and/or string manipulation functions to "overlay" strings x and y which results in z like so:
x := 'X XXX XXX '
y := ' X XXX X XX XX '
z := 'XX XXXXX X XXXX XX '
I realize that a function could be written to iterate through the strings character by character and perform the operation, but I need to do this with a large volume of long strings, so I was hoping to find a fast way to do this with regexp or some other "immediate" method to avoid iterating.
Thanks in advance for any input/ideas,
Dennis