Remove a character from a field

Hi All,

I need your assistance. I have two fields called Other and Notes. In both fields there is a asteric (*) present.

How could I write an agent to remove the asteric only for the fields mentioned and leave all other text?

Thanks

John

Subject: Remove a character from a field

@ReplaceSubstring

Subject: Remove a character from a field

You get the value from those fields. Then use strLeft and strRight to get the strings to the left and right of the asterik *. Then u can concatenate the 2 strings and replace the value in the fields.