5 Replies Latest reply: May 18, 2017 3:36 AM by PAUL YEO RSS

    How to remove those un-necessary charater from company ?

    PAUL YEO

      Hi All

       

       

      sales:

       

       

      LOAD Subject,

           [Opportunity Name],

           [Tax Type],

           [Discount Percent],

           [Discount Amount],

           [S&H Amount],

           [Organization Name] as COMPANY,

           Description

      FROM

      [C:\Users\Paul Yeo\Dropbox\0_Q_Development\JEREMY\Sales_Order.csv]

      (txt, utf8, embedded labels, delimiter is ',', msq);

       

       

      My company field give the below result :-

       

       

      Accounts::::.Show Laser pt

      Accounts::::Abbot Indonesia, PT

      Accounts::::Adi Quarto, PT

       

       

      May i know how to remove those charater not necessay.

       

       

      Paul