How to fetch data from html tag that stored in Salesforce marketing cloud data extension? [closed]

Question

Example :

1. I have stored below html tag as one field in data extension. I need to retrieve the href url from this. How to retrieve this ? and also How to retrieve "Visit google.com!" from html stored in data extension
2. How to send the HTML code in the data extension field as an email attachment? How to send the below code as email attachment in email ?

HTML :

<h1> The a element </h1>
<a href="https://www.google.com">Visit google.com!<a>

Answer 1

Using AMPscript RegExMatch function would help to get the URL.

Update to get both URL and link text. Try this:

%%[
  set @html = AttributeValue('Your column name');

  set @url_Pattern = '(?<=href=").*(?=")'
  set @linkText_Pattern = '(?<=>).*(?=<a>)'

  set @url = RegExMatch(@html, @url_Pattern, 0)
  set @linkText = RegExMatch(@html, @linkText_Pattern, 0)
]%%

URL: %%=v(@url)=%%<br>
Link Text: %%=v(@linkText)=%%

Reference: RegExMatch function