how to select particular portion from the spread sheet?

[AnkitRamani]

Hello,

I have 8 color sensor and form that I am getting the informatin as shown  below,

/s0=0 s1=2 s2=4

/////////////////////Sensor 6////////////////////// /////////////
/Sensor_6_rot ?74.08
/Sensor_6_blau ?18.13
/Sensor_6_gruen ?0.00
/s0=1 s1=2 s2=4
/////////////////////Sensor 7////////////////////// /////////////
/Sensor_7_rot ?68.92
/Sensor_7_blau ?12.19
/Sensor_7_gruen ?13.63
/s0=0 s1=0 s2=0
/////////////////////Sensor 0////////////////////// /////////////
/Sensor_0_rot ?63.72
/Sensor_0_blau ?14.06
/Sensor_0_gruen ?13.14
/s0=1 s1=0 s2=0
/////////////////////Sensor 1////////////////////// /////////////
/Sensor_1_rot ?55.20
/Sensor_1_blau ?33.52
/Sensor_1_gruen ?19.53
/s0=0 s1=2 s2=0
/////////////////////Sensor 2////////////////////// /////////////
/Sensor_2_rot ?70.65
/Sensor_2_blau ?16.57
/Sensor_2_gruen ?12.30
/s0=1 s1=2 s2=0
/////////////////////Sensor 3////////////////////// /////////////
/Sensor_3_rot ?67.94
/Sensor_3_blau ?14.50
/Sensor_3_gruen ?12.23
/s0=0 s1=0 s2=4
/////////////////////Sensor 4////////////////////// /////////////
/Sensor_4_rot ?59.74
/Sensor_4_blau ?10.83
/Sensor_4_gruen ?0.00
/s0=1 s1=0 s2=4
/////////////////////Sensor 5////////////////////// /////////////
/Sensor_5_rot ?61.77
/Sensor_5_blau ?22.86

Sensor_5_gruen ?12.90

i wanted to ask how can I select for example sensor 1 and all its data seperatly and same for the other sensor.

because I want to compare the all rot Blau and guen value to detect the color.

please guide me.

Thank youv very much in advance.

Regards,

Akki.

[GerdW]

Hi akki,

search lines containing "Sensor_x" to get data for sensor "x". Then parse the RGB values from these lines…

[AnkitRamani]

thank you very much for your reply.

I tryied this vi as in attachment.

but still I am facing problem.

it give me befor value and after value from the spred sheet.

but in my case I want to get value for perticular sensor.

I am using 8 color sensor MCS3AS. I am communicate using VISA.

[GerdW]

Hi Akki,

why don't you parse your string array directly?

That's a very basic and straight-forward solution. You can refine this to fit your needs...

[AnkitRamani]

Thank you very much for your answer.

this solution is very nice.

could you suggest me that in attached vi How can i reduce the complexity, means how can I modify it in more morden way.

thank you very much once again for you time and help.

[GerdW · Accepted solution]

Hi Akki,

could you suggest me

You can:

- remove question marks from your input string to simplify parsing the string later on

- use the sensor number as a parameter instead of purely string constants

-