Hi guys,
I have a piece of software that outputs a *.csv file.
One column of data is of the form "Wednesday 2nd July 2008 12:05:00"
The software has a very basic user interface and I cannot change the time/date stamp. Furthermore, the time/date stamp is only recognised as text after it saves, and not as a stamp that I can change (in Excel for example).
I have been trying to write a program that can read this text (date/time) and remove the "Wednesday 2nd July 2008" segment.
My thinking was along the lines of.... Read spreadsheet (*.csv file), isolate the column with the text then remove everything before the time, thus cropping the data.
At the moment I can read the data into an array (of numbers) or into a table (of numbers), but I cannot disply the text, hence do anything with the text.
Can anyone suggest a method of producing the *.csv values but not simply numerically?
Thanks
EDIT: I just noticed I told the "Read from Spreadsheet" vi to read Double, not String. Problem solved.