How to remove those un-necessary charater from company ?

[paulyeo11]

Hi All

sales:

LOAD Subject,

     [Opportunity Name],

     [Tax Type],

     [Discount Percent],

     [Discount Amount],

     [S&H Amount],

     [Organization Name] as COMPANY,

     Description

FROM

(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

[paulyeo11]

my QVW

[tresesco · Accepted solution]

Purgechar( [Organization Name], ':' ) as COMPANY

[antoniotiman]

Hi Paul,

maybe

Replace(Company,'Accounts:::::','')

Regards,

Antonio

[paulyeo11]

Hi Tres

Thank you very much , it work.

Paul

[paulyeo11]

Hi Sir

I have use below it work fine , thank you for your offer.

Purgechar

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>