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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PAGA - 16 Aug 2007 02:16 GMT

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,

Signature

PAGA

Reply to this Message

Pieter Wijnen - 16 Aug 2007 15:34 GMT

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

> My Access 2007 tables contain thousands of hyperlink addresses in the
> #url#
[quoted text clipped - 5 lines]
>
> Thanks,

Reply to this Message

PAGA - 17 Aug 2007 02:20 GMT

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

Signature

PAGA

> UPDATE MyTable SET URLFIELD = '#' & [URLFIELD] & '#'
> WHERE URLFIELD NOT LIKE '#*#' Takes care of it
[quoted text clipped - 19 lines]
> >
> > Thanks,

Reply to this Message

RedHeadedMonster - 05 May 2008 16:24 GMT

I was just searching for exactly this situation. And found your reponse to
another poster. THANX! worked like a charm.
RHM

>UPDATE MyTable SET URLFIELD = '#' & [URLFIELD] & '#'
>WHERE URLFIELD NOT LIKE '#*#' Takes care of it
[quoted text clipped - 15 lines]
>>
>> Thanks,

Reply to this Message