Skip to main content
add marketing-cloud tag, formatting
Source Link
Adam Spriggs
  • 31.1k
  • 6
  • 44
  • 88

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

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

%%[

Set @pws = Substring(‘AttributeValue("websiteUrl")’,21)
Set @link1 = Concat('http://differentwebsite.com', @pws)
]%%

With the asset linked to: %%=Redirect(@link1)=%%%%=Redirect(@link1)=%%

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)=%%

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)=%%

Source Link
Dave
  • 191
  • 3
  • 18

Removing characters from data extension field via AMPScript

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)=%%