Help with trimming a string

[mikedaruke]

Hi,

I have a FQDM in a database and I want to drop the domain. How can I do that in a select? Was trying RTRIM but I need to use wildcards. Pretty much from the first period to the end i want deleted.

So...

Server.domain.com

is

Server

Thanks!

 

[LKBrwnDBA]

Try:

SUBSTR(FQDM,1,INSTR(FQDM,'.')-1)

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[taupirho]

Try

select substr('server.domain.com',0,instr('server.domain.com','.')-1)
from dual



In order to understand recursion, you must first understand recursion.

 

[mikedaruke]

Thanks guys, one last thing, can you do a or statement in a replace?

Like if I have two things to replace?

Something like this?

replace(column, 'replace || replace 1', '')

 

[SantaMufasa]

Yes, you may place functions (or operations), inside of functions (or operations), inside of function (or operations), ad nauseum.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[SantaMufasa]

In my post, above, I should have used the term "nest" instead of "in", but you still get the point, I hope. <grin>

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]