OraFAQ Forum: SQL & PL/SQL » Replace command for restructuring a field?

Home » SQL & PL/SQL » SQL & PL/SQL » Replace command for restructuring a field?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Replace command for restructuring a field? [message #7555]

Fri, 20 June 2003 10:18

Prathab Raj Su
Messages: 2
Registered: June 2003

Junior Member

I have a field here

which is at present in the given format

T0558's-troley#2 fast%

now i need to change it to have only

alphabets,numbers and a -

all other characters(including spaces) should be changed to -.
if the characters are found in the end then it should be removed.

hence in this example it needs to be changed as

T0558-s-troley-2-fast

i tried using the translate but was only able to change the special characters to - ,is there a way to get rid of the last special charater?
thx
prathab

Report message to a moderator