topic Problem removing characters from a string in QlikView

Problem removing characters from a string

bguiliano — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

New to qlikview, i have a list box that has county name like:

ABCD - countyname

I wanted to remove the 'ABCD -' from the displayed text.

I tried:

mid(countyname,8)

This seemed to keep they original text and append the county name text i want to the end.

what am i missing?

Thanks

Re: Problem removing characters from a string

StarinieriG — Wed, 02 Oct 2019 15:29:06 GMT

Hi,

try with subfield(countyname,'-',2)

Re: Problem removing characters from a string

bguiliano — Wed, 02 Oct 2019 15:26:36 GMT

i just tried and it appears to be the same issue.

Seems as though the original text is locked and can't be deleted for some reason

Re: Problem removing characters from a string

sunny_talwar — Wed, 02 Oct 2019 15:31:05 GMT

Would you be able to share a sample to show the issue?

Re: Problem removing characters from a string

bguiliano — Wed, 02 Oct 2019 15:42:44 GMT

this is before adding the mid(countyname,8)

after

Re: Problem removing characters from a string

sunny_talwar — Wed, 02 Oct 2019 15:45:43 GMT

I see the problem, but where exactly are you using the code? In the script? Can you share the script that you have used?

Re: Problem removing characters from a string

bguiliano — Wed, 02 Oct 2019 17:04:48 GMT

No, i was adding to the list box under properties/expressions

Re: Problem removing characters from a string

sunny_talwar — Wed, 02 Oct 2019 17:20:08 GMT

List box expression is not the right place to use this... either do the transformation in the script or do it on the general tab

Re: Problem removing characters from a string

Brett_Bleess — Wed, 09 Oct 2019 21:03:52 GMT

Brent, did Sunny's last post get you where you needed to be? If so, do not forget to come back and use the Accept as Solution button to mark his post as having worked and to give him credit for the help. If you have further questions, update the thread. If you did something else, consider posting that and then use the button to mark it after you post it.

Regards,
Brett