Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Data replace in listbox

Dear All,

I need to delete or replace the collon(') symbol in listbox, please find attached snapshot for the same.

In the screenshot, the data in red lined box contains ' symbol at the end. I dont want to load the data which has ' symbol. How can I ignore/delete the first two rows of data in the attached screenshot.

How can I do this, please help me....

Thanks,

Ananth

1 Solution

Accepted Solutions
MVP
MVP

Re: Data replace in listbox

I just tried this script:

Table:

LOAD PurgeChar(Name, Chr(39)) as Name;

LOAD * Inline [

Name

A'Souza

];

Did not give any problem. Are you sure you are using the field name BUSSINESS_UNIT_ID correctly? Can you share the table where you are doing this in the script?

Best,

Sunny

7 Replies
MVP
MVP

Re: Data replace in listbox

From the Field drop down, select Expression:

Capture.PNG

And use the expression: =Replace(BUSINESS_UNIT_ID, Chr(39), '')

Re: Data replace in listbox

There are various functions that can cleanse your data

replace(); keepchar(); purgechar()

It is best to do this in the script rather than in the front-end listbox.

Try      purgechar(BUSINESS_UNIT_ID, chr(39))

Not applicable

Re: Data replace in listbox

Thanks for your quick responce.

I tried in script like

purgechar(BUSSINESS_UNIT_ID,Chr(39)) as BusinessID,

it gave me field not found error

rpayn01215
Contributor

Re: Data replace in listbox

Did you place the call in the same tables script? the field name should be the exact same name as the one in your screenshot.

MVP
MVP

Re: Data replace in listbox

I just tried this script:

Table:

LOAD PurgeChar(Name, Chr(39)) as Name;

LOAD * Inline [

Name

A'Souza

];

Did not give any problem. Are you sure you are using the field name BUSSINESS_UNIT_ID correctly? Can you share the table where you are doing this in the script?

Best,

Sunny

Highlighted
Not applicable

Re: Data replace in listbox

Thank you all, i got my answer.

thanks community

Re: Data replace in listbox

Is the field name correct?  is is BUSSINESS_UNIT_ID or BUSINESS_UNIT_ID

Community Browser