Hi, I need to write formula which can replace value of the field.
For example: In Assigement, I need to check Name1 field for Company name and than replace the value with new value. There is no REPLACE function available in Assigement tab in data manager. How can I replace the value?
For example:
Name 1 contains Mr. Robert D'soza- For this value I need to remove Mr. and last name and wants to make name1: Robert and name2: D'soza. I tried different ways like trim left, trim right and all but unable to write excact formula.
Can some one help me out ???
Regards,
R.n