<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3314.2100" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=200395316-24092003>Got
it! Thanks, boy that sure saved me a lot of work.</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> paul.hartland@fsmail.net
[mailto:paul.hartland@fsmail.net]<BR><B>Sent:</B> Wednesday, September 24,
2003 10:57 AM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> Re: RE: [AccessD] Find a Word & Put in New
Field<BR><BR></DIV></FONT>
<P><BR>sorry try this line<BR></P>
<P>yourfieldname = Replace (yourfieldname,MyDocNo, "")</P>
<P>Paul <BR><BR></P>
<BLOCKQUOTE
style="BORDER-LEFT: #ff0000 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">Message
date : Sep 24 2003, 04:52 PM <BR>From : Hollis,Virginia
<HOLLISVJ@PGDP.USEC.COM><BR>To : 'Access Developers discussion and problem
solving' <ACCESSD@DATABASEADVISORS.COM><BR>Copy to : <BR>Subject : RE:
[AccessD] Find a Word & Put in New Field <BR><BR><BR><BR><BR><BR>
<META content="MSHTML 5.00.3314.2100" name=GENERATOR><BR><BR>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=100264215-24092003>Do
I <BR>put it in a module & run it?</SPAN></FONT></DIV><BR>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
<br>class=100264215-24092003></SPAN></FONT> </DIV><BR>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=100264215-24092003>I
<BR>get the error: Expected = on Replace (....</SPAN></FONT></DIV><BR>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
<br>class=100264215-24092003></SPAN></FONT> </DIV><BR>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
<br>class=100264215-24092003>Va.</SPAN></FONT></DIV><BR>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
<br>class=100264215-24092003></SPAN></FONT> </DIV><BR>
<DIV> </DIV><BR>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px"><BR>
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
<br>size=2>-----Original Message-----<BR><B>From:</B>
paul.hartland@fsmail.net
<BR>[mailto:paul.hartland@fsmail.net]<BR><B>Sent:</B> Wednesday, September
24, <BR>2003 8:09 AM<BR><B>To:</B> Access Developers discussion and
problem <BR>solving<BR><B>Subject:</B> Re: [AccessD] Find a Word & Put
in New <BR>Field<BR><BR></DIV></FONT><BR>
<P><BR>Virginia,</P><BR>
<P>What you could do is something like the following :</P><BR>
<P>Dim MyDocNo as String</P><BR>
<P>MyDocNo = Mid(yourfieldname,Instr(yourfieldname,"DS-"),16)</P><BR>
<P>Replace (yourfieldname,MyDocNo, "")</P><BR>
<P>yourotherfield = MyDocNo</P><BR>
<P>this should work, please remember to back up your table etc before
trying <BR>it</P><BR>
<P>Paul Hartland<BR><BR><BR></P><BR>
<BLOCKQUOTE <br>style="BORDER-LEFT: #ff0000 2px solid; MARGIN-LEFT: 5px;
PADDING-LEFT: 5px">Message <BR>date : Sep 24 2003, 02:02 PM <BR>From
: Hollis,Virginia <BR><HOLLISVJ@PGDP.USEC.COM><BR>To : 'Access
Developers discussion and problem <BR>solving'
<ACCESSD@DATABASEADVISORS.COM><BR>Copy to : <BR>Subject : [AccessD]
<BR>Find a Word & Put in New Field <BR>This is a real challenge...
<BR><BR><BR>Is it possible to search a field for certain text, remove
the word <BR>for <BR>placement in another field? <BR><BR>We have a part
description that <BR>lists the document number in the <BR>description.
The document numbers are <BR>all the same length and all start with
<BR>DS-, (ex: DS-MDD-15987-001). But <BR>the document number might be
anywhere in <BR>the description. The document <BR>number needs to be
separated out into a field <BR>by itself. <BR><BR>There <BR>are over
3,000 records & I really don't want to sit here for days
<BR><BR>doing a copy & paste to move the number to a new field.
<BR><BR>Any <BR>ideas? Or can this be done at all? <BR><BR>Virginia
<BR><BR>_______________________________________________ <BR>AccessD
mailing list <BR><BR>AccessD@databaseadvisors.com
<BR><BR>http://databaseadvisors.com/mailman/listinfo/accessd
<BR>Website: <BR>http://www.databaseadvisors.com
<BR></BLOCKQUOTE></BLOCKQUOTE><BR><BR>[ (no filename) (0.2 Kb)
]</BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>