Jump to content

Reading text out of *.csv


Recommended Posts

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.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.