Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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>