i am trying to replace (') in field which have value in text format and have special character as(') need to replace it with space, while using replace function in Enrichment activity(editing formula using expression) e.x.Replace(@fa,'\'',"'") , its giving error as unterminated string , Do we have any other way to required . Thanks in Advance
Solved! Go to Solution.
Views
Replies
Total Likes
You can use JavaScript code to replace your special characters.
var Name = 'Ak\'sha\'y';
logInfo("Old Name "+Name);
var newName = Name.replace(/'/g,' ');
logInfo(newName);
Regards
Akshay
You can use JavaScript code to replace your special characters.
var Name = 'Ak\'sha\'y';
logInfo("Old Name "+Name);
var newName = Name.replace(/'/g,' ');
logInfo(newName);
Regards
Akshay
Hi @AkshayAnand
Thanks this worked , but just curious to know , can we do same by any other way using any Formula using expression available in tool?
Views
Replies
Total Likes
Hi @ayushhtiwari , yes you can.
Use Replace(<string>, "'", " ")
Views
Replies
Total Likes
Hi @vt0509 it's giving "unterminated string constant error"
Views
Replies
Total Likes
Views
Likes
Replies