Discussion Board for collaboration on QlikView Scripting.
I am loading data from a table and would like to remove the two last characters of the field PRV_CODE. (#0)
These characters is allways in the end of the value, but the length of the PRV_CODE can vary.
Go to Solution.
Use below in your script instead of PRV_CODE
Replace(PRV_CODE,'#0','') as PRV_CODE
if its '#0' always. You can use the Replace function to replace the '#0' with a '' (blank).
you can use
Use Purge Char fuction
Thanks for all answers.The code worked fine :-)