By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT REGEXP_REPLACE('Ctn/10Btl/100ml', '(\\d+)(\\D)', '\\1 \\2')
REGEXP_REPLACE('Ctn/10Btl/100ml', '(\d+)(\D)', '\1 \2') |
---|
Ctn/10 Btl/100 ml |
REGEXP_REPLACE('Ctn/10Btl/100ml', '(\d+)(\D)', '\1 \2') |
---|
Ctn/10 Btl/100 ml |