Can you help me find an email address for Harriet Hall, MD - aka the "Skepdoc"? [more inside]
posted on Jul 25, 2008 - 3 answers ![]()
I need to do a massive replace of Flash object HTML code throughout an entire site. I really don't want to download each page and fix it by hand. [more inside]
posted on Jan 25, 2007 - 11 answers ![]()
How do I find someone's email address from the web? [more inside]
posted on Oct 3, 2006 - 7 answers
I'm writing an query in MS Access to get column 1 = product ID, column 2 = product Description. However, the description field has addtional spec data that I don't need. I want to remove anything after the first word, meaning remove after the first blank space.
Example:
Prod ID Prod Desc
10-362-3 Packing DT
12-345-5 Seal XT L-23
Desired result:
10-362-3 Packing
12-345-5 Seal
I tried to use FIND or SEARCH functions to identify the position of the first blank space and to truncate everything after that. However, Access does not recoganize either FIND or SEARCH. Does anyone have any idea how to accomplish this? Thanks.
posted on Sep 20, 2006 - 4 answers ![]()