A field used in a sendable data extension contains a value that I'm trying to remove the beginning characters from then add the remaining characters to the end of a different URL.
Example:
Data Extension Value (everything after the '/' is unique to each record): 'www.mywebsite.com/bill'
Target URL: 'www.differentwebsite.com'
Desired Outcome: www.differentwebsite.com/bill
I believe I could accomplish this with the substring and concat function, but can't seem to figure out the proper formatting as I receive an error stating:
The function call uses an unrecognized function name. Function Name: ‘AttributeValue Function Call: ‘AttributeValue("websiteURL")*
Here's what I tried so far:
%%[
Set @pws = Substring(‘AttributeValue("websiteUrl")’,21)
Set @link1 = Concat('http://differentwebsite.com', @pws)
]%%
With the asset linked to: %%=Redirect(@link1)=%%