07-01-2010 10:20 AM
8.6
07-01-2010 10:25 AM
That would work great however I need it in the format that I displayed in the first picture I attached.
07-01-2010 10:44 AM
Done Like this
07-01-2010 10:54 AM
Thats right on track of what I need. The only thing is that its cutting the time from some of the data points. If you notice in the Test File, there is a time followed by a collected data point, then on the same line another time (fractions of a second later) followed by another time until all the channels have collected a data point then it returns to a new line. So what happens is, when the second channel collects a data point, the first channel stays at the same value until the rest of the channels have collected data. Once channel 1 gets its new data point, then the value changes while the rest stay the same. If you notice in my string file, the data point stays the same until that specific channel gets a new value.
07-01-2010 12:25 PM
Well I have given you a way to take things apart and make the string array. You should be able to take that and put it into a loop to do the rest of the processing or atleast give it a try. I can and will be happy to help you refine what ever you come up with but I would like to see you try first.
07-01-2010 12:28 PM
Your file format is nothing like what you showed in the original figure or what you said! You said you the date was in the first column, time in the second, and the collected data in the following columns. You said nothing about the date and time columns repeating, and that's not even shown in the figure in your original post. You also said you were using 4 spaces as your delimiters, but your uploaded text file shows commas. In the future please upload the file in the first place so we can see what you're actually parsing instead of guessing and wasting time.
While aestat's code can be improved to not require the Build Array (which creates memory thrashing), he's correct that you basically have what you need.
07-01-2010 12:48 PM
Apparently you still don't understand the concept that is going on here. If you take another look at the text file that I did upload, that is the original file that I get from a data aquisition unit. I don't know where you see times repeating because they dont. Again, the text file has nothing to do with the original issue I posted. I mentioned that I have a string file, columns seperated by 4 spaces. I need this string to be an array (with a 4 space delimiter from the string file!)
If you read my other posts, I said that the original text file, regardless of the format, was parsed to the string file that i first posted. If you feel that I am wasting time then its simple, dont post!
As far as aestat's code, I appreciate what he sent. I've been trying to manipulate it to work for what i need. And it's not what I need.
Thanks
07-01-2010 01:12 PM
You have posted exactly one file and that is clearly comma separated with times in multiple columns. If you converted the file to that string and then want to extract some columns, you are doing an unnecessary step since what you asked for was the timestamp information and the numerics. What you have been provided with is the direct method to do that. Do NOT refer to what you have in the first post as a file. It is a string indicator.
07-06-2010 02:59 PM
07-16-2010 02:58 PM - edited 07-16-2010 02:59 PM
smercurio_fc Wrote:
While aestat's code can be improved to not require the Build Array (which creates memory thrashing), he's correct that you basically have what you need.
How would you have done this? I would love to learn how. This is the only way that I know how to do this.