How to get the first x chars of a string

[jupixy]

Hi all.

Big problem here. My source text:

header1;header2;header3;…
2020;Schmidt;Heiner;0;0;23.12.2019;TEST;0;0;0;24.12.2020;"Dies “das”! kjlojl
2020;Mustermann;Max;0;0;23.12.2019;TEST;0;0;0;24.12.2020;"Dies “das”! kjlojl

Now I set a custom state (list of texts) and I want to fill it with (result should be):

Schmidt, Heiner
Mustermann, Max

(item #2 + item #3).
After that I want to display the result in a repeating group.

Here’s my current code:

And the result i’ll get until now is:

Please help

Thanks a lot,

jupxi

[Jici]

If I understand, you first split by is new line? second is for item in each line?

I think you should: :split by (newline):format as text. In format as text, Top box: This text:split by( item #2 , This text::split by( item #3 (so two dynamical expression separated by a comma entered manually)

In the bottom box, new line

[jupixy]

hi Juci,

thanks,

Now I get this list as a result:

As you can see, there are 2 elements that are similar (doublette): 0, 0

Now I created a text element and I want to show the item count of similar elements and I did this:

But the result of this formula is “5”, not “1”

[jupixy]

Okay… I think I did it: