help me.. web developers plz.. mu kiyana de therenneth na bn..

[gembaknb]

machan mata website ekak hadann wadak aawa.. eeke mchn home address eke filter krna wagyk uu ewala thiyenawa.. ugen ahuwata hariyta kiyanneth na bn.. mona reddakd manda.. menna meke theruma ubalawath kiyapnkoo..

If “Home Address” is a “P.O. Box” or “PO Box”
For example,
select rowkey,yourcolumn,replace(' ','',replace('.','',yourcolumn)) as coltotest
        into #temp
      from yourtable
       where yourcol like  '%p%b%x%'

select rowkey,yourcolumn
        from #temp
       where coltotest
         like '%POB[OX]%'

or

var pobReg = /\bbox(?:\b$|([\s|\-]+)?[0-9]+)|(p[\-\.\s]?o.?[\-\s]?|post office\s)b(\.|ox)?/igm;
/*
Matches:
po box
p.o.b.
pob
p.o. box
po-box
p.o.-box
PO-Box
p.o box
pobox
p-o-box
p-o box
post office box
P.O. Box
PO Box
PO box
box 122
Box122
Box-122

Does not match:
123 Boxing Street
34 Box Handler Road
424 PO Dance drive

php walin hri javascript walin hri validate wenne bn..

 

[biri]

මොක්කක්ද යකෝ මේ භාෂාව??????
Home adress eka Filter Karala thiyenne...
man hithana widata,

ube table eke adala row eke thoyena hama p o box kiyana eka wenuwa P.O Box

අනේ මන්ද මොන්ගල් වගේ බන්..........

 

[asiridol]

machan mata website ekak hadann wadak aawa.. eeke mchn home address eke filter krna wagyk uu ewala thiyenawa.. ugen ahuwata hariyta kiyanneth na bn.. mona reddakd manda.. menna meke theruma ubalawath kiyapnkoo..

address eka po box ekakda kiyala balanawa.. post boxes walata parcel deliver karanne nahane.. e wage scene ekak.. address eka resident address ekak wenna one po box nathuwa.. po box ekak enter karanna puluwan hama possibility ekakma manually check karanawa

 

[weechami]

MAMA HITHANA WIDIYATA:
home address kiyana filter ekata search ekak dunnama oya table eke coloum eke search karala ganna one po box gewila hari thiyana ekak e coloumn eka text area ekakinganna data wenna ethi e kiyanne mona widiyata type karala thibunath oya search ekedi e row eka filter karala gannaona preg_replace dala goda daganin ...

 

[isuru_]

machang oya regx ubata php wala, javascript wala validation walata use karanna puluwan.

 

[gembaknb]

machang oya regx ubata php wala, javascript wala validation walata use karanna puluwan.

ee wage ekakata thmi bn.. ithn validate karannawath me magula therenne na ne use krnnwath