2 Replies Latest reply on Jul 13, 2017 7:04 AM by Sekar R

    Calculcated field

    3417744

      Hello Team,

       

      Currenty, Contact data is loaded using csv file. This has a field 'Phone Number' and it is prefixed with country phone code i.e. +61.

       

      there is an export for contact details including phone number and being used by phone system.

       

      However, the destination system can not load the phone number if it has +61 in it.

       

      Is there any way, we can a hve another calculated field and it removes +61 and contains only vaid number

       

      Ex: +6108333333

       

      the calculated field should have - 08333333

       

      and this calculated field will be used for export instead of orginal phone number.

       

      Radha