topic Re: Remove last substring from a string in QlikView

Remove last substring from a string

patriciabb — Sat, 16 Nov 2024 19:32:51 GMT

Hi there, I have a field (called GROUP) containing multiple strings like this one:

Group1/Group2/Group3/Group4/Group5

and so on.

I don't always have the same number of substrings (divided by the '/'), sometimes there are more than 5 and sometimes less than 5.

I'd like to remove from these strings the last subfield, intependently of the number of substrings.

Has anyone any clue about how could I get this done?

Re: Remove last substring from a string

Anonymous — Mon, 02 Dec 2019 16:17:57 GMT

use the formla: =SubField('Group1/Group2/Group3/Group4/Group5','/',-1)
it retreives the last subfield after the defined character from right (defining -1)

instead of hardcoded text use your data field

Re: Remove last substring from a string

atoz1158 — Mon, 02 Dec 2019 16:19:04 GMT

As long as you have at least two substrings this should work for you

Left(GROUP ,Index(GROUP,'/',SubStringCount(GROUP,'/'))-1)

Regards

Adrian

Re: Remove last substring from a string

patriciabb — Mon, 02 Dec 2019 16:24:05 GMT

Thanks, but that's not what I'm looking for, I wanted to keep the rest of the string, not the last one.

Re: Remove last substring from a string

patriciabb — Mon, 02 Dec 2019 16:25:07 GMT

Thank you, it worked perfectly!

I was assuming it had to do with the Index function.