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
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.