04-23-2014 03:44 PM
No, but the files I attached earlier have no gaps. So maybe could just start with that.
04-23-2014 05:18 PM
What's your LabVIEW version?
04-23-2014 05:21 PM
2011
04-23-2014 05:37 PM - edited 04-23-2014 05:39 PM
Try this, just a quick attempt at parsing the files and correlate the data.
It seems the data is mostly not correlated. There only seems to be some correlation between ~40 and 60 hours, so you might want to investigate that data subset (not shown).
I included the data as string diagram constants. Just read the files as a string to get the raw string to be processed the same.
04-24-2014 05:43 AM
When I read the spreadsheet in, it says the scan from string is is wired to an unexpected input format. So I changed the format of the read from spreadsheet to match the scan function, which has no errors but also does not show any graphs or data arrays.
Thanks
04-24-2014 08:09 AM - edited 04-24-2014 08:10 AM
I never said to use "read from spreadsheet file". It will not work directly because the various fields require different formats. SImply read is as a plain string using read from text file, for example, then feed that string into the existing machinery. (there are othere ways, for exampe you could read it as lines into an array, skippng the spreadsheet string to array function).
If you make modifications that break the code, please attach the new code so we can troubelshoot.
04-24-2014 10:21 AM
The file that needs reading is in csv format. Would the 'read from text file' work?
04-24-2014 10:55 AM - edited 04-24-2014 10:55 AM
Yes. Why don't you simply try? You need to make some attempts to understand my code. As you can easily see, it already assumes commas as field seperators. Nothing else to do.
(It is faster to simply try it that to ask here. :D)
04-24-2014 01:12 PM - edited 04-24-2014 01:13 PM
I got this error, is there something I have done wrong here?
Scan failed. The input string does not contain data in the expected format.
04-24-2014 01:18 PM - edited 04-24-2014 01:20 PM
Then don't attach the VI, attach the datafile!
In any case, you are using the "spreadsheet string to array" completely wrong and not as I instructed.
Just wire the string from the read operation in place of my string diagram constants. Don't add meaningless code!