Discussion Board for collaboration on QlikView Scripting.
I want to remove some text from the beginning of a field by expression / script. The seperater is '#', but it is not always at the same mid point of the field. Could anyone help. Please see below ....
56789;# John Smith
I want to show .....
Any thoughts welcome
Go to Solution.
SubField(YourField, '#', 2) as Name
trim(SubField(field, '#', 2)) as newfield