Modify <A> tag

I connected a dataset to a page with a repeater. Within the dataset isa URL field called “Gallery”. I would like to be able to change the visible text of the tag so that on the page the link does not appear as “http://website.com/pagename”.

Is there a way in the dataset or through custom coding that I can accomplish this?

I would like my link to display as “Click here for more info” or some other text.

I also would like to control when the link should open to a new page or to itself.

I have scoured the forum but cannot find anything that would assist me.

Thanks,
Mike