2 Replies Latest reply: Feb 1, 2018 5:42 AM by max payne RSS

    TRIM(IF(SubField(BUYER,' ',1)='Mr.',REPLACE(BUYER,'Mr.',''),

    xxxxx yyyyy

      Can you please explain the meaning for it:: TRIM(IF(SubField(BUYER,' ',1)='Mr.',REPLACE(BUYER,'Mr.',''),

          IF(SubField(BUYER,' ',1)='Mrs.',REPLACE(BUYER,'Mrs.',''),

          IF(SubField(BUYER,' ',1)='Ms.',REPLACE(BUYER,'Ms.',''),BUYER)))) AS BUYER,