- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi,
Use below and it should fix your problem.
<?xml version="1.0" encoding='ISO-8859-1' ?>
<!-- ===========================================================================
Additional SQL functions for Adobe Campaign
========================================================================== -->
<package
namespace = "vip"
name = "Vip-additional-functions"
label = "Vip Additional functions"
buildVersion= "6.1"
buildNumber = "8691">
<entities schema="xtk:funcList">
<funcList name="VIPFunctionList" namespace="vip">
<group name="string" label="String">
<function name="VIPReplace" type="string" args="(<String>,<String>,<String>)" help="Replace all occurrences in string of substring from with substring to" minArgs="3" maxArgs="3" display="Replace all occurrences in string of substring from with substring to">
<providerPart provider="PostgreSQL,MSSQL" body="replace($1,$2,coalesce($3,E''))"/>
</function>
</group>
</funcList>
</entities>
</package>