Split line based on index

I need to split the text based on the the index

For example below is the text :
10 ABCD … END
… AUR
… AUR
20 DEFG … END
… AUR
30 GHIJ… END
40 ABCD … END
… AUR
… AUR
50 ZZZZ … END



END

can I split the text based on the arithmetic progression of indexes like 10,20,30 and end with END | AUR

like list of matches {,,,}
{[10 ABCD … END
… AUR
… AUR],
[20 DEFG … END
… AUR],
[30 GHIJ… END],
[40 ABCD … END
… AUR
… AUR]}}

I dont the last one ending with ZZZZ

Please guide\help

for better understanding in pattern

The pattern is like it always starts with index second column is code and 4 columns end with value either AND
but one index can have multiple lines of value
that will end with AUR

i can get the first line of index but not next lines
if i write regex ends with AND|AUR it stops at the very last occurrence of either
but i need index wise data

for more details index wise wise data can have dates or keywords like Not found , or NA and ends with AND
and further lines of index will not code values like ABCD , DEFG … but dates or Not found , or NA and ends with AUR

Yes you can use substring(0,variable.indexof(" ")) like this you can extract data

its not working showing error for variable and indexof function

The pattern is like it always starts with index second column is code and 4 columns end with value either AND
but one index can have multiple lines of value
that will end with AUR

i can get the first line of index but not next lines
if i write regex ends with AND|AUR it stops at the very last occurrence of either
but i need index wise data

for more details index wise wise data can have dates or keywords like Not found , or NA and ends with AND
and further lines of index will not code values like ABCD , DEFG … but dates or Not found , or NA and ends with AUR

1 Like

10 ABCDEF this, is the description,100AUR 15.03.2019 5 AUR 216,56 2.080,36 AND
Agreed 90,00 % 326,48 - AND
Gross AND For code 1.664,67 AND
15.03.2019 1 AUR
31.03.2019 4 AUR
NOT FOUND 1 AUR

20 DEFGHI this, is the description, (72 aur) NA 10 AUR 458,12 1.080,34 AND
Agreed 90,00 % 216,45 - AND
Gross AND For code 46,56,78,64 AND

30 EDFTHI this, is the description, NA 5 AUR 67,67,89,23 AND

40 EDFTHI this, is the description, NOT FOUND 5 AUR 67,67,89,23 AND

50 ZZZZZZZZZZZ ZZZZZZZZZZZ available 1 AUR 12,34,56,78 AND

Split2.xaml (6.7 KB)

regards
Chethan P