Problem changing hyperlink field to text field 1

[kieranplatt1]

I have 36000 email addresses in a table but could not search on them to find records when they were in 'hyperlink' format. I changed the format to 'text' and I can now search BUT the problem is that many of the email adddresses now show as client@junglematsse.com#

http://client@junglematsse.c

how do I get rid of the # sign and everything after it to just leave the original email address?

Many thanks

Kieran

 

[PHV]

Something like this update query ?
UPDATE yourTable
SET yourField=Left(yourField, InStr(yourField,"#")-1)
WHERE InStr(yourField,"#")>0
;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[kieranplatt1]

Sorry I'm a novice. Where do I put this update query and how do I run it? I assume I replace 'yourTable' with the name of the table i.e. 'Clients'

 

[PHV]

Create a new query, choose the SQL view pane, paste and amend the code, replacing yourTable by the name of the table and yourField by the name of the the column, then click the ! button to execute the query.
Obviously test this in a backup database...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[kieranplatt1]

Worked like a dream - thank you very much.