You have set dozens of variables using the AttributeValue() function and need to change it to the Lookup() function… This is useful for a very specific case; you want to keep the data source as specified in the Lookup() function and skip any fallback values from Profile Attributes…
Data Extensions vs All Subscribers
All Subscribers list is a default publication list for sendable data extensions. Dynamic, conditional content can use variable evaluation to show/hide content if not empty and so on. All Subscribers Profile Attributes are fallback values for empty values in nullable fields of a sendable data extension. These fallback values may be incorrect or unwanted in some cases. To limit the data source, set variables using the Lookup() function instead of the AttributeValue() function.
Regex
To find and replace these strings in an AMPScript email use the following formula.
SET @c_dataSource = _DataSourceName
/*Old Format*/
SET @MyAttributeValue = AttributeValue(‘MyAttributeValue’)
/*New Format*/
SET @MyAttributeValue = Lookup(@c_dataSource, ‘MyAttributeValue’, ‘SubscriberKey’, _subscriberkey)
Find the Old Format
AttributeValue\('(?<=')(\w.*)'\)
Replace with the New Format
Lookup\(@c_dataSource, '$1', 'SubscriberKey', _subscriberKey\)
More Examples
SET @c_dataSource = _DataSourceName
/*Old Format*/
SET @myVariable = Lookup(@c_dataSource, 'myVariable', 'SubscriberKey', SubscriberKey)
/*New Format*/
SET @myVariable = Field(@tsdeRow, 'myVariable', 0)
Find the Old Format
Lookup\(@c_dataSource, (\'.*?\'), 'SubscriberKey', SubscriberKey\)
Replace with the New Format
Field(@tsdeRow, $1, 0)