return partial text string

[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.

 

[Les]

I think you could create a new field using something like
this:

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

 

[JumboShrimps]

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.
.

.

 

[Les]

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.
.

.

.