Conditional text

[rrdwitt]

Hi, I searched the forum but cannot find this rule. Nor am I probably not asking the correct question.

I want to add a "$" to a field if the "$" is not there, but to NOT add the "$" if
the "$" is in the data. So "123" would be changed to "$123". But "$456" would stay "$456".

Thanks all!!

[sschardan]

This should work for your scenario:


if (Field("Fieldname").indexOf("$") > -1)


{return Field("Fieldname")}


else


{return ("$" + Field("Fieldname"))


Hope this helps

[sschardan]

oops, have a parenthesis instead of a bracket, use this:

{return ("$" + Field("Fieldname")}

[rrdwitt]

Awesome! Thanks! Much appreciated!