String.Keep (reverse of String.Remove)

Hi, is it possible to keep first characters of a string?

It the reverse of String.Remove

In put = CN_Blok-1_Voorgevel )
Out put = CN_Blok-1

Is your desired string always the same length? If so you could do something like so:

4 Likes

@s.bosch you could also consider extracting a substring
substring

1 Like

for people who like excel’s LEFT/RIGHT/MID string functions:

I’m sure there is a more elegant way to do this, but it seems more straightforward than counting characters or manipulating strings.