OraFAQ Forum: Server Administration » Truncate ???Urgent please

Home » RDBMS Server » Server Administration » Truncate ???Urgent please

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

Truncate ???Urgent please [message #374027]

Mon, 21 May 2001 15:57

anits
Messages: 1
Registered: May 2001

Junior Member

Hi,
I need to truncate value after '_' fro example
008637_20010406.jpg should be 008637
and for 008922111_20010406.jpg should be 008922111

Please its urgent

Anita

Report message to a moderator

Re: Truncate ???Urgent please [message #374028 is a reply to message #374027]

Mon, 21 May 2001 16:08

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

select substr('008922111_20010406.jpg', 1, instr('008922111_20010406.jpg', '_') - 1) from dual;

Report message to a moderator

Re: Truncate ???Urgent please [message #374029 is a reply to message #374027]

Mon, 21 May 2001 17:25

Sundar Venkatasubramaniam
Messages: 26
Registered: May 2001

Junior Member

let f1 be the field then

select substr(f1,1,decode(instr(f1,'_'),0,length(f1),instr(f1,'_')-1)) from your_tabel where f1 is not null;

I put decode here as there is a possiblity of value without _ and you might need entire value in that case.

Report message to a moderator