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

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

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.

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

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