07-29-2015 12:11 PM - edited 07-29-2015 12:18 PM
Hey hows it going everyone,
I seem to be having a problem with the X-Y plot function. I am passing data from a file to be plotted by the function, in which it does so properly but,
I get basically a line of non-existing data on the graph that obviously shouldn't be there. I start collecting data at 1GHZ but that is not where the data starts.
I have looked ploted the graph from two different perspectives and it seems as though it is a single data point being created at the beginning of the plot that is causing this problem, how do i get rid of it and correct my problem?
07-29-2015 12:16 PM
This is the actual file I'm reading from.
07-29-2015 12:42 PM
Either strip your header information from your txt file or start your reading at an offset past your header.
Each line of header is giving you unwanted data.
07-29-2015 01:46 PM
Thank you I ad done that before but my offset was wrong, some crazy number like 281, I for whatever reason never had the bright idea to use a control to easily go through the offset values thanks.
07-29-2015 02:22 PM
Hey Sorry to bother again, is there anyway to offset by rows, the problem is fixed with the offset change but part of the file is the date, so July 27th etc well as months change the offset will change. Or is there a way to eliminate the header as far as what the read from spread sheet function outputs?
07-29-2015 02:30 PM
Can't do it with the Read from Spreadsheet function.
Try reading from the File as ASCII Text and then postprocessing the text using a Match Pattern or Match Regular Expression.
From there, you can use the Spreadsheet String to Array to get plottable data.