Hi Fajar,
Sekedar mau melengkapi saja, sebetulnya tidak ada solusi yg benar-benar
tepat, anda harus mempelajari pattern nya terlebih dahulu baru dapat
menentukan logic-nya. Mungkin yg paling tepat adalah no HP/telp diletakkan
pada field terpisah.
select remarks,
translate(upper(substr(remarks,instr(remarks,'081'),15))
,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ, ','0123456789')
from nama_table;
Dari contoh di ataspun kita masih menggunakan assumsi, yaitu semua no hp
diawali dengan '081', maksimum panjangnya saya asumsikan tidak lebih dari 15
karakter, segala huruf alphabet, spasi dan tanda coma akan di hapus dengan
menggunakan function TRANSALATE
Regards,
Aply
----- Original Message -----
From: "cyuniart" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, July 20, 2006 10:04 AM
Subject: [indo-oracle] Re: Query mengambil number in Varchar field
> coba ditambahi dikit pake nama field di instr
>
> select trim(substr(remark, instr(remark, 'CP') + 2)) from <nama_tabel>
>
>
>
> --- In [email protected], FAJAR SIDIK <[EMAIL PROTECTED]>
> wrote:
>>
>> Thks bangnapi ... but kok error ...
>> errror: not enough argument for function ... pada instr nya ...
>> gimana yah ... :-D
>>
>> __________________________________________________
>> Apakah Anda Yahoo!?
>> Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik
> terhadap spam
>> http://id.mail.yahoo.com
>>
>> [Non-text portions of this message have been removed]
>>
>
>
>
>
>
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.blogspot.com
> Mirror: http://indooracle.wordpress.com
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.blogspot.com
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> __________ NOD32 1.1668 (20060719) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>
___________________________________________________________
Try the all-new Yahoo! Mail. "The New Version is radically easier to use" – The
Wall Street Journal
http://uk.docs.yahoo.com/nowyoucan.html
------------------------ Yahoo! Groups Sponsor --------------------~-->
Something is new at Yahoo! Groups. Check out the enhanced email design.
http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
