Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dickelsa
Creator
Creator

Remove first 2 characters from string and split string

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

1 Solution

Accepted Solutions
marcus_sommer

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

- Marcus

View solution in original post

3 Replies
marcus_sommer

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

- Marcus

jonathandienst
Partner - Champion III
Partner - Champion III

How about:

     Substring(textField, '\\', 2)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
dickelsa
Creator
Creator
Author

Substring should have been SubField()