Parsing user input
-
I smell OCR in the mix - hence the BOK, BOS, B0X, etc.
Software Zen:
delete this; -
When we put our mail on vacation hold, it validates and 'normalizes' the address, so I do understand what you're working with. Where I grew up, our address was RR#1; it wasn't until I was in my teens that we had an address with a number and street name. So.. consider this.. are you only dealing with P.O. and its variants or do you have R.R. addresses as well?
Excellent point. Are there services that allow you to force user input validation of addresses against the USPS databases?
-
Examples (#'s have been removed):
P O BOX
P.O. BOX
PMB
PO B0X
PO BO X
PO BOK
PO BOS
BOX:sigh: The one with the 'K' is interesting. 'K' is on the opposite side of the keyboard -- I can understand the 'S'. The hardest part about parsing crap like this (there are 166,333 records) is determining what other variants I did not parse correctly (for example, considered as a street address, not a PO Box), not which ones I successfully accounted for. Marc
Latest Article - Create a Dockerized Python Fiddle Web App Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny Artificial intelligence is the only remedy for natural stupidity. - CDP1802
Your could fashion the UI to eliminate the need to parse P.O. Box... etc. Have a drop down that contains these options: Street #, P.O. Box, RR#, CR, HC, etc And to the right of it, place a text box that accepts the actual number. Just a thought off the top.
Cheers, Mike Fidler "I intend to live forever - so far, so good." Steven Wright "I almost had a psychic girlfriend but she left me before we met." Also Steven Wright "I'm addicted to placebos. I could quit, but it wouldn't matter." Steven Wright yet again.
-
welcome to my life
Woah... haven't seen you in a long time Chris. How's it going these days?
Cheers, विक्रम "We have already been through this, I am not going to repeat myself." - fat_boy, in a global warming thread :doh:
-
Woah... haven't seen you in a long time Chris. How's it going these days?
Cheers, विक्रम "We have already been through this, I am not going to repeat myself." - fat_boy, in a global warming thread :doh:
i'm here occasionally. not constantly, as previously. it goes... on and on and on and on. :)
-
Nelek wrote:
Software development is a constant war with the universe... Developers trying to do better idiot-proof software and the universe trying to do even dumber users...
You made my day with this phrase!
You are welcome :) :-D
M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.
-
Examples (#'s have been removed):
P O BOX
P.O. BOX
PMB
PO B0X
PO BO X
PO BOK
PO BOS
BOX:sigh: The one with the 'K' is interesting. 'K' is on the opposite side of the keyboard -- I can understand the 'S'. The hardest part about parsing crap like this (there are 166,333 records) is determining what other variants I did not parse correctly (for example, considered as a street address, not a PO Box), not which ones I successfully accounted for. Marc
Latest Article - Create a Dockerized Python Fiddle Web App Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny Artificial intelligence is the only remedy for natural stupidity. - CDP1802
-
i'm here occasionally. not constantly, as previously. it goes... on and on and on and on. :)
I still remember your old profile pic - with hand on your thoughtful face. Got it somewhere? :)
Cheers, विक्रम "We have already been through this, I am not going to repeat myself." - fat_boy, in a global warming thread :doh:
-
I still remember your old profile pic - with hand on your thoughtful face. Got it somewhere? :)
Cheers, विक्रम "We have already been through this, I am not going to repeat myself." - fat_boy, in a global warming thread :doh:
Vikram A Punathambekar wrote:
Got it somewhere
He probably has his face at the same bbody place you have yours. :rolleyes:
-
Examples (#'s have been removed):
P O BOX
P.O. BOX
PMB
PO B0X
PO BO X
PO BOK
PO BOS
BOX:sigh: The one with the 'K' is interesting. 'K' is on the opposite side of the keyboard -- I can understand the 'S'. The hardest part about parsing crap like this (there are 166,333 records) is determining what other variants I did not parse correctly (for example, considered as a street address, not a PO Box), not which ones I successfully accounted for. Marc
Latest Article - Create a Dockerized Python Fiddle Web App Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny Artificial intelligence is the only remedy for natural stupidity. - CDP1802
Maybe who entered used Hungarian autocorrect in, let's say, Word. box autocorrects to boksz, [s]he tried to correct that to something sounding right, but deleted the wrong letter. Or gave up fighting autocorrect :)
-
Vikram A Punathambekar wrote:
Got it somewhere
He probably has his face at the same bbody place you have yours. :rolleyes:
Smarty pants ;P
Cheers, विक्रम "We have already been through this, I am not going to repeat myself." - fat_boy, in a global warming thread :doh: