correcting fields

[Jean-Paul]

I have a few hundred records with following content:

[email protected]#http://[email protected]

Is there a way to automatically delete averything behind #
# should be omitted too..

Thanks

 

[Keith Wilby]

I have a few hundred records with following content:

[email protected]#http://[email protected]

Is there a way to automatically delete averything behind #
# should be omitted too..

Thanks

Check out the InStr function in the help.

Keith.
www.keithwilby.co.uk

 

[Dale Fye]

What is the datatype of the field where these values appear? If it is a text
field, you could use an update query:

UPDATE yourTable
SET [yourField] = Left([YourField], instr([yourField], "#") - 1)
WHERE instr([yourField], "#") > 1

I don't work with hyperlink fields much, so I'm not sure whether this would
work with that type of field or not.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Jean-Paul]

perfect.... thanks
jp