☆─────────────────────────────────────☆ rex (村上种树) 于 (Thu May 14 23:07:31 2009) 提到: Izzie的事情倒不算什么,早就预料得差不多了,George的事真是来得措手不及... ☆─────────────────────────────────────☆ berry123 (wide open life) 于 (Thu May 14 23:10:38 2009) 提到: 这帮人太能编了。谁会想到是george,这一季他都是默默无闻的。 ☆─────────────────────────────────────☆ fullbloom (花开不败) 于 (Thu May 14 23:13:10 2009) 提到: en they were talking all over him while operating on him...
☆─────────────────────────────────────☆ berry123 (wide open life) 于 (T
Practice Problems for the Civil Engineering PE Exam: A Companion to the Civil Engineering Reference Manual (2008 edition) If you are interested in this book, please message me. Thanks!
Practice Problems for the Civil Engineering PE Exam: A Companion to the Civil Engineering Reference Manual (2008 edition) If you are interested in this book, please message me. Thanks!
你们给人家出个正经主意 如果有回车的话,用instr, substr好了 select address, substr(address,instr(address,chr(10),1)) from addresses; ADDRESS ------------------------------- 4 K St Anchorage 1629 Eleonora Dr. Eagle River SUBSTR(ADDRESS,INSTR(ADDRESS,CHR(10),1)) ------------------------------- 1629 Eleonora Dr. Eagle River
【在 B*****g 的大作中提到】 : 买地址验证软件
z*g
24 楼
多谢 不知道国内现在clinical research 的形式这么样?还有我这种背景读个clinical research的master会不会太吃力,因为我没有什么医学背景?
这真的没有什么好方法. 如果剥逗号前面的字, 你不知道抓多少个字. 如果你只抓住一 个字, Long Beach, South Beach, Palm Beach 都成了 Beach. 因为一些街名没有"街""道" etc 后缀. 你也不能抓 "Street" "," 之间的字 best bet without buying software is trying to look up city names from a geo database.
【在 i****a 的大作中提到】 : 这真的没有什么好方法. 如果剥逗号前面的字, 你不知道抓多少个字. 如果你只抓住一 : 个字, Long Beach, South Beach, Palm Beach 都成了 Beach. : 因为一些街名没有"街""道" etc 后缀. 你也不能抓 "Street" "," 之间的字 : best bet without buying software is trying to look up city names from a geo : database.
你做的 pre-process 把问题搞的更复杂了,不然简单的 split 就可以拿到 city. 按你现在的格式,给个 regular expression 的答案吧。 简单起见,assuming only ST, DR will be used in address line, but you can easily add BLVD etc once you get the idea. Here is the answer: (?<=\bST|DR\.?)(\b[a-zA-Z]+)$\i
北京说的不错,其它办法都是穷糊弄, SUBSTRING能搞定,QAS啥的靠啥赚钱啊 ADDRESS看似简单,但其实很复杂, 没有特定的规律,比如, 你不能假定是,DELIMITED或者SPACE DELIMITED 1629 Eleonora Dr. Eagle River, Michigan 可以有很多VALID的 1629 Eleonora Drive, Eagle River, Michigan 1629 Eleonora Dr, Eagle River, Michigan 1629 Eleonora Dr Eagle River Michigan 1629 Eleonora Eagle River, Michigan 1629 Eleonora Dr #2 Eagle River, Michigan 1629 Eleonora Dr Floor 1 Suite200 Eagle River, Michigan