Skip to Content
0
Former Member
Sep 12, 2007 at 12:32 PM

Assignment/Validation-How Replace will work?

25 Views

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