Convert all hyperlinks to the same #url# 'number'-delimited format

P

PAGA

My Access 2007 tables contain thousands of hyperlink addresses in the #url#
format (URLs bracketed with the number [#] character as a delimiter). But
thousands of other URLs in the same tables do not have the number [#]
character added at either end. Is there a way to convert all the 'bare' URLs
in my tables into Access-formatted [#]url[#] hyperlink addresses?

Thanks,
 
P

Pieter Wijnen

UPDATE MyTable SET URLFIELD = '#' & [URLFIELD] & '#'
WHERE URLFIELD NOT LIKE '#*#' Takes care of it

even safer

UPDATE MyTable SET URLFIELD = '#' & [URLFIELD] & '#'
WHERE URLFIELD NOT LIKE '*#' AND URLFIELD NOT LIKE '#*'

and so on ...

HTH

Pieter
 
P

PAGA

Pieter, thank you!

I'm a novice, so I'm not quite sure how to use this information, or what
screen I should clip it into, but I'll ask a friend.

Your help is very much appreciated
--
PAGA


Pieter Wijnen said:
UPDATE MyTable SET URLFIELD = '#' & [URLFIELD] & '#'
WHERE URLFIELD NOT LIKE '#*#' Takes care of it

even safer

UPDATE MyTable SET URLFIELD = '#' & [URLFIELD] & '#'
WHERE URLFIELD NOT LIKE '*#' AND URLFIELD NOT LIKE '#*'

and so on ...

HTH

Pieter

PAGA said:
My Access 2007 tables contain thousands of hyperlink addresses in the
#url#
format (URLs bracketed with the number [#] character as a delimiter). But
thousands of other URLs in the same tables do not have the number [#]
character added at either end. Is there a way to convert all the 'bare'
URLs
in my tables into Access-formatted [#]url[#] hyperlink addresses?

Thanks,
Click to expand...
Click to expand...
 
Top