4 Replies Latest reply on Dec 21, 2017 5:38 AM by suresh.gooty

    Unable to remove the new line character in calcuation

    Sriram Anantha Padmanaban

      I was using the below formula in 10.1 / 10.2 version and it was working as expected to remove the new line character and now it is not working in 10.2.4 (desktop) connecting to a 10.4.0 Server

      Formula used:

      REGEXP_REPLACE([ABC], "\r*\n*", "") -> This is used to remove all the new line characters

      I think REGEXP is depreciated so It is throwing a calculation error and trying

      REPLACE(REPLACE([ABC], '\r', ''),'\n','') is not working and removing the new line character

       

      Output shown is

       

      your help to fix this formula is highly appreciated.

       

      Regards,

      Sriram