Get continuous data in excel file from Instrument device using USB-RS232

[InternlABVIEW]

Thank you GerdW. My most problems has been solved. You are a legend. 

Currently, I am stuck in getting all 8 channels data into 8 rows all time continuously. And record it. Thanks again 

[InternlABVIEW]

Hi,

I am trying to get my 8 channels data into a array so that I use that data later. I managed to do this far because of help of GerdW. But I am still struggling to get my all data to array. My 8 channels data should come in 8 different rows in arrays with time. Here is my current VI.

[GerdW]

Hi Intern,

can you please attach a downconverted version of your latest VI? (File menu -> Save for previous)

Today I prefer LV2017…

[wiebe@CARYA]

Use Scan From String (or Match Pattern, Match Regular Expressions, etc.) to get the value from the incoming strings.

Get the channel nr from the strings as well. If channel nr is the first channel, start a new line by adding an enter.. Also add the time. All other channels simply add the value.

Alternatively, make an array of values (strings or doubles). Fill it as the data comes in (get the value and channel nr.). If it's full, write a new line, the time and the values.

Have a look at Array To Spreadsheet String. It's helpful for array to string conversion.

[GerdW]

Hi Intern,

please keep your discussion in one thread instead of creating (several) new threads on the same problem!

---

wiebe@CARYA wrote:

Use Scan From String (or Match Pattern, Match Regular Expressions, etc.) to get the value from the incoming strings.

Get the channel nr from the strings as well. If channel nr is the first channel, start a new line by adding an enter.. Also add the time. All other channels simply add the value.

---

We already arrived at this point some days ago…

[InternlABVIEW]

Hi GerdW, 

sorry currently do not have access to labview. The latest version for now is attached as Array testing.VI . I can have access to labview after 10 hours if you required as LV2017. Thanks 

[GerdW]

Hi Intern,

you're not creating any arrays/columns from your channel data!

All you do is parsing a single response string, containing the value of one channel.

In the next iteration you parse the next string, but you forgot to store the previous results somewhere…

It also does not help to use all those "default if unwired" tunnels: you will create a lot of "empty" (aka "invalid") data. Why do you want to filter those invalid results later on when you could avoid them right from beginning?

[InternlABVIEW]

My name is not Andrew 😅.

In my VI, I was trying different arrays/ways to store those received 8 channels to 8 different columns. But I am not where do I start form or how do I get it done. I new in labview and my head is totally blank now. 

[GerdW]

Hi Intern,

---

@InternlABVIEW wrote:

I new in labview

---

That's why you should take all those Training resources offered at the top of the LabVIEW board!

See this as a suggestion/idea:

[InternlABVIEW]

Thank you. I will try again and hopefully can have progress.