Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Purgechar( [Organization Name], ':' ) as COMPANY
my QVW
Purgechar( [Organization Name], ':' ) as COMPANY
Hi Paul,
maybe
Replace(Company,'Accounts:::::','')
Regards,
Antonio
Hi Tres
Thank you very much , it work.
Paul
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>