I have some part numbers that I would like to add a space within them.
I would like to only add a space within a part number that starts out with a 'LS' or a 'QM'.
So if I have a part number = 'LS18022', I would like to add a space after the 'LS' like 'LS 18022'.
Same thing for the 'QM', 'QM 83212'
So if the part number starts out with a LS or QM add a space within it.
Trying to use regexp_like or regexp_replace or any other solution.
I can use this to remove the space, just need to figure out how to add a space back in.
select trim(regexp_replace('LS 18022','(LS )(\d)' ,'LS\2')) from dual;
This is using Oracle 11g.