Replace Symbol

[-Lisa-]

Hello all,

 

 

Trying to come up with a way to remove a percentage symbol if it already exists in the data but return the symbol if it does not exist.

 

 

I already successfully created a replace rule for the presence of a dollar sign:

 

return Field("Price").replace('$', "");

 

 

If I simply replace the dollar symbol with a percentage symbol, I'm not getting the same result:

return Field("Percent").replace("", '%');

 

 

Any ideas on what I'm obviously doing wrong?

 

 

 

Thanks!

[Leosmith]

return Field("Percent").replace("", ' & # 3 7 ; ');

remove the spaces in ascii %

 

check - treat return string as tagged text

[-Lisa-]

Thanks! Unfortunately this doesn't work. Just as with my version, it's returning the percentage sign in front of the number. It need the symbol after the number.

[ScottHillock]

I believe you have the order of your parameters switched on your percentage example.

 

With replace the first parameter is what you are searching for, and the second is what to replace it with.

 

Here's a bit of code that covers both $ and %:

 

var fieldName = Field("field");

var field = fieldName.replace(/\$/g,'').replace(/\%/g,'');

if(fieldName.indexOf('$') > -1){return '$' + field;}
if(fieldName.indexOf('%') > -1){return field + '%';}

return field;