Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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

View solution in original post

7 Replies
sunny_talwar

From the Field drop down, select Expression:

Capture.PNG

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

Colin-Albert

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
Author

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

Anonymous
Not applicable
Author

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.

sunny_talwar

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
Author

Thank you all, i got my answer.

thanks community

Colin-Albert

Is the field name correct?  is is BUSSINESS_UNIT_ID or BUSINESS_UNIT_ID