Caius Posted July 3, 2008 Report Share Posted July 3, 2008 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. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.