Thank you so very much for your help.!
If there is a column with location all locations starts wit SL. now i want to remove this SL. but the thing is some of them dont have this so the right and mid comand is actualy cutting the first 3 letter so anything we can do for only selcting SL. and deleting the SL. only from SL.Mumbai and etc.
Latur Here Lat is cutted if right or mid is used
Generally I would advise on deciding what method to use, instead focus on you incoming data and the expected result. From that then evaluate the best option to achieve your requirement.
Your description is a bit vague in this case, as you have not defined if the result to be achieved in script or chart object. To a solution this will make some difference.
One way of doing this as in the attached script
test.qvw 147.0 K