Repeat Based on number of array elements

Hi again,

I’m kind of new to designer sorry if this is super basic… i feel as if it is super basic.

I’m currently having a txt file and there is a logic that i have but don’t know how to implement into the repeat step.

My logic is to stop the repeat if the second array element is null or " " .

myArray2[1] == " " ;

or myArray2[1] == null;

This is the sample txt data

“29/04/1”,“asd”,“22222222-850”,“2222222222”," 454.30"," “,” “,” 454.30",“668864-850”," 454.30"
“29/04/11”,“asd”,“668872-850”,“22222222222222”," 209.75"," “,” “,” 209.75",“668872-850”," 209.75"
“Hahaha”,“April '11.”
“Hahahha”
“19/04/11”,“2222-001”,“”,“”," 4509.50"
“19/04/11”,“716161-004”,“”,“”," -13292.14"
“29/01/11”,“326379-005”,“”,“”," 8552.95"
“29/04/11”,“1111-005”,“”,“”," -71088.62"
“123456789”

Based on the above txt file.

I have a script that splits each line into an array based on the " "
The repeat function logic should stop if the array doesnt have a second element inside it.

You can simply check if the array length is greater than 1:

Attached is a sample data mapping config that demonstrates this.PartialLoop.OL-datamapper (4.4 KB)