topic Remove first 2 characters from string and split string in QlikView

Remove first 2 characters from string and split string

dickelsa — Tue, 04 Aug 2015 13:05:01 GMT

Hi guys,

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:

\\Financial\profit-and-loss-account\net sales\

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 '\\'.

Thanks!

Dick

marcus_sommer — Tue, 04 Aug 2015 13:07:23 GMT

You could use the function replace(string, '\\', '') or mid(string, 3).

- Marcus

jonathandienst — Tue, 04 Aug 2015 13:11:11 GMT

How about:

Substring(textField, '\\', 2)

dickelsa — Tue, 04 Aug 2015 13:14:15 GMT

Substring should have been SubField()