12-21-2008 09:35 PM
HI, I am trying to get the logic for data seperation from the table control. My table control looks like as explained below (Bold text is the table control data)
listing This is the first element in my table
|
b 100 90 80 70 60 50 40 30 20 10 This single row should be seperated from the table
0 0 0 0 0 0 0 ................0 This data can be any number of lines and is irrespective of a0 , a1 .....
0.1 0.2 0.3..................................0.8Stop
a 1 c 100 90 80 70 60 50 40 30 20 10 0 0 0 .....................................0 0.1 0.2 0.3....................................0.18Stop Stop is end of a1
like thisi want to seperate b,c data and data in between a0, stop and a1,stop and so on
I am trying with arrays as one logic.
i have also tried with string functions also but i have not fulfilled my requirement.
Can any body please help me in this regard.
Regards,
Padmavathi.B
12-21-2008 10:28 PM - edited 12-21-2008 10:29 PM
That's not totally clear. Are those values in different columns, or is all your data in the first column? In other words, does it look like this:
or this:
To look for the Stop you just need to index out the first column (using Index Array) and then search the array using Search 1D Array.