return partial text string

  • Thread starter Thread starter carol
  • Start date Start date
C

carol

would like to design update query that modifies existing
text field as follows:

current field in records read as an email address followed
by # and additional url. i would like to update field to
include only text to left of "#". your help would be
appreciated. thx.
 
I think you could create a new field using something like
this:

Newfld: Mid([yourfld],1,InStr(1,[yourfld],"#",1)-1)
 
I have names with "." between first, last name.
How can I covert this code to change
Bill.Gates to Bill Gates - replacing "." with
" ".
-----Original Message-----
I think you could create a new field using something like
this:

Newfld: Mid([yourfld],1,InStr(1,[yourfld],"#",1)-1)

-----Original Message-----
would like to design update query that modifies existing
text field as follows:

current field in records read as an email address followed
by # and additional url. i would like to update field to
include only text to left of "#". your help would be
appreciated. thx.
.
Click to expand...
.
Click to expand...
 
Hi Jumboshrimps,

You would need something like the following:

Newfld: Mid([yourfld],1,InStr(1,[yourfld],".",1)-1) & " "
& Mid([yourfld], Instr(1,[yourfld],".",1)+1,Len([yourfld])-
Instr(1,[yourfld],".",1)
-----Original Message-----
I have names with "." between first, last name.
How can I covert this code to change
Bill.Gates to Bill Gates - replacing "." with
" ".
-----Original Message-----
I think you could create a new field using something like
this:

Newfld: Mid([yourfld],1,InStr(1,[yourfld],"#",1)-1)

-----Original Message-----
would like to design update query that modifies existing
text field as follows:

current field in records read as an email address followed
by # and additional url. i would like to update field to
include only text to left of "#". your help would be
appreciated. thx.
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top