Is there a way to replace the last digit with hyphen and one digit?
The original requirements must be changed from File 01 file 01-01 file02 file02-02 I resolved it with AmarGhosh
< Select all names of the Dual Union with the name of the pre-> names (select '/ file01 / some / file 01'), name regexp_replace (name, 'name /' / file02 / another / file02) ^ / File0 ([1-9] +) ',' / file0 \ 1- \ 1 ') New name NEW ------------------------ -------------------- Thank you - Thanks
Comments
Post a Comment