Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to remove those un-necessary charater from company ?

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

View solution in original post

5 Replies
paulyeo11
Master
Master
Author

my QVW

tresesco
MVP
MVP

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

View solution in original post

antoniotiman
Master III
Master III

Hi Paul,

maybe

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

Regards,

Antonio

paulyeo11
Master
Master
Author

Hi Tres

Thank you very much , it work.

Paul

paulyeo11
Master
Master
Author

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>