Problem removing characters from a string

[bguiliano]

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

[StarinieriG]

Hi,

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

[bguiliano]

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

[sunny_talwar]

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

[bguiliano]

 

this is before adding the mid(countyname,8)

after 

[sunny_talwar]

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

[bguiliano]

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

[sunny_talwar]

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

[Brett_Bleess]

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