Hi, I'm currently running into an issue of converting some Numeric and String data into an array then exporting it to a .csv. The issue arises when I take my data (29.0;1.1;30;STRINGNAME) and it through the [Spreadsheet String to Array.vi]. It will put it into 4 columns, 29.0 1.1 30 0, with the STRINGNAME being converted to a 0. I need the first 3 to be numerical and the last one being a String. Part of the reason I'm doing this is because it needs to be a 2D array going into a [Write Delimited Spreadsheet.vi]. For more specifics if needed, I'm using a case block with several different enumerated states, which is the "string" value i've converted from enum. This state needs to be logged next to the data pulled from a Keysight Electronic Load, which is giving out the Voltage/Current/Power from the Read Visa. The data is being build into a .csv file which essentially needs the keysight values logged next to which state it was in. I have a few blocks that basically dump data every so many samples, so I need to keep track of which line of the array it is at. The [Search and Replace String.vi] is used to get rid of the Line Feed Constant the Keysight puts in line with the data it sends. This is where I'm looking to take this string of data (in the format of [volt;curr;pow;STRING]) to put into a csv file. Any help or thoughts would be appreciated. Still newer to Labview and I'm sure I'm probably overlooking a simple block that does this, and I'm just not recognizing it.

This is the string you want to convert to an array, 29.0;1.1;30;STRINGNAME It is separated by semicolons, are you using that as the delimiter? How are you writing to your CSV file? The following works fine for me. (You should post your VI backsaved for an earlier version.) EDIT: Do you use commas for a decimal separator?

LabVIEW

Labview String and Array help

Solved!

Author

Doesn't seem like a stupid idea, just not one I've yet to experience with yet on labview. I may very well be overcomplicating things on this, and do appreciate the input. Writing everything to text might be a bit easier to deal with lol.

Message 11 of 11

(119 Views)

LabVIEW

Labview String and Array help

Re: Labview String and Array help