topic Re: Show string after second or more appearance of specific char in QlikView

Show string after second or more appearance of specific char

Inessan86 — Sat, 16 Nov 2024 00:05:39 GMT

Hi All,

I have two columns; one holds the codes for changed fields, the second keeps string of the values for each changed field:

Field1: ,25,52,12,

Field2: ~abc~def~gh~

I want to see what is the value for field 52 (def).

I used the following function to retrieve the number of commas up to 52: SubStringCount(TextBetween([Field1],',','52'),',') as CommasCounter (in this case 2)

and now I need to get the value in Field2 after 2 appearances of ~ symbol.

Any idea of how doing that?

Inessa

Re: Show string after second or more appearance of specific char

tresB — Mon, 24 Aug 2020 13:01:33 GMT

You can use the same textbetween() with additional parameter for count, like:

Textbetween(Field2, '~', '~', 2)

Re: Show string after second or more appearance of specific char

Kushal_Chawda — Mon, 24 Aug 2020 13:11:03 GMT

if you need full string after 2 appearances then try below

=mid(Field2,index(Field2,'~',2)+1)

Re: Show string after second or more appearance of specific char

sunny_talwar — Mon, 24 Aug 2020 14:39:04 GMT

Is there a reason not to use SubField() function for this

SubField([Field1], ',', 2) & '(' & SubField([Field2], '~', 2) & ')'

Re: Show string after second or more appearance of specific char

Brett_Bleess — Tue, 08 Sep 2020 15:58:08 GMT

@Inessan86 You have received 3 possible options on your post, we would greatly appreciate it if you would return to the thread and close it out by using the Accept as Solution button on the post(s) that helped you solve the use case. If you did something different based upon the posts, you may post what you did instead and then mark that post using the button, but I would encourage to use the Like feature on the post(s) that helped in that case too.

Regards,
Brett

Re: Show string after second or more appearance of specific char

Inessan86 — Thu, 10 Sep 2020 08:32:12 GMT

I used SubField(Field2, '~', SubStringCount(TextBetween(Field1,'',52),',')) and it worked for me.

Thank you for your reply, guys!