Remove first 2 characters from string and split string

[dickelsa]

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 · Accepted solution]

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

- Marcus

[jonathandienst]

How about:

     Substring(textField, '\\', 2)

[dickelsa]

Substring should have been SubField()