Checking for a sequence in string

[Nghtcrwlr]

Hi all

I have a string input which consists of numbers. 5 numbers seperated by semmicolon represents one set. The numbers could be 2 digit,3 digit or 4 digit.

 And there could be 1,2 ,3 or 4 sets . How can i check whether any of the set in the input contains a 0; 0; 0; 0; 0.000; ??

I tried using Match First string and Match True /False String. But Match True/False string examines only the beginning of string.

Can anyone suggest some ideas hw to proceed? 

[GerdW · Accepted solution]

Hi Nightcrwlr,

why don't you use SpreadsheetStringToArray and just check the number of elements in the array to separate your "sets"?

After separating the sets (ArraySubset) you could just compare each set for zero...

[Nghtcrwlr]

Hi GerdW

That was a gud suggestion. :D. Thanks a lot

At the moment i do have only inputs with maximum 4 sets. So i made  4 different cases  to check each set.

i.e  Case 1 have 1 check , Case 2 have 2 checks and so on.

Anyways found a solution. Thanks