Data Sorting

[Vinaygowda]

Hello All,

I finding difficulties in sort out the required data in bulk data as marked in the attachment

• as shown in the picture is data getting from testing machine through RS232 using LabVIEW DAQ and VISA
• Now data is getting successfully using VISA and writing to the excel
• Challenge is I getting list of data as show in attached and I only need marked data in red has to sit in the specified excel cell i.e 179.5000

so guys please help for this problem

sorry for my English

looking forward for your support

have nice day

regards

vinay

[GerdW · Accepted solution]

Hi Vinay,

use SpreadsheetStringToArray with a '|' as separator.

Then search the first row containing 'DATA', then pick the 7th element from that row…

[Vinaygowda]

Thank U GerdW I got it now

have a nice day

regards

vinay