Hi All,
I have a list of product-ids (MTUID's from EA's) that I want to deploy to a table in the database. And this configuration
< column name="tag" data-type="VARCHAR(50)" list-to-replicant="yes" list-field="TeamSite/Metadata/English-Products-BrowseOnly_codes" value-from-field="TeamSite/Metadata/English-Products-BrowseOnly_codes/[0-3750]/" is-replicant="yes" allows-null="no" is-url="no" />
is allowing me to do it successfully. Now for each of the ID that I get in the list is it possible to concat it with "-PC" at the end of the MTUID. This is to maintain uniquiness across multiple taxonomies in the DB.
I was thinking that
< substitution >
< field name="TeamSite/Metadata/English-Products-BrowseOnly_codes/[0-3750]/" match="^MTS:
.+)" replace="$1-P" global="yes" />
< / substitution>
in a destination section would allow me to do this. But I get the following error in the OD.log
Ignoring unrecognized "substitution" element in destination section
Is this the right way to do this. If not can anyone suggest a better way?
Thanks
