- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi,
There is no REPLACE function available as part of query editor in Campaign. You will have to create one of your own.
Please refer to the documentation Adding additional SQL functions
I have a package for you which you can use directly.
<?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 = "8857">
<entities schema="xtk:funcList">
<funcList name="VIPFunctionList" namespace="vip">
<group name="string" label="String">
<function name="(example is here, you can change to the name you want : VIPReplace)" type="string" args="(<LookIn>,<From>,<To>)" 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,$3)"/>
</function>
</group>
</funcList>
</entities>
</package>
Import it and then you will see the option inside expression editor for use.
You can then user the expression
VIPReplace(@firstName,"-","")+VIPReplace(@lastName,"-","")
Hope this helps.
Regards,
Vipul