Discussion Board for collaboration on QlikView Scripting.
I have an issue:
For a client i need to create a report from our programm, which links some accountcodes to specific places. These links are shown as:
To create a hierarchy, i need to split these strings in order to declare parent/chield fields.
First, i need to remove the '\\' at the beginning of each string,
next i need to split the data.
To split the data, i know i have to use SubString() function, that is not a problem
I just want to know if there is a code to remove the first '\\'.
Go to Solution.
You could use the function replace(string, '\\', '') or mid(string, 3).
Substring(textField, '\\', 2)
Substring should have been SubField()