I have data collected from octave analysis that is displayed in a result table before being sent to excel for further calculations and reporting. Using the GetOctaveInfo.vi I end up with a lot of data I don't need. Ideally all I want is the frequency (Hz) in one column and the decibel (dB) reading in the next. I've attached pictures of the result table and how it is formatted in excel. Is there a way to remove the extra data? Note that the size of the result table could change.
I'm sorry, it's not really a vi, its a cluster native to the sound and vibration toolset. It's a cluster of defining properties concerning the octave spectrum. The actual table is built from the SVT Build Result Table.vi. I'm not sure how to remove the unwanted data attached when the table is populated. I attached a picture of one of the sub routines, hopefully it better explains the setup.
A simpler solution is to split the string at the space. This would avoid the penalty of the double conversion: once to a number, and then back to a string.
