Format time in csv file

[HCMUI]

Hi everyone.

I have a csv file with first Column is time stamp. but i can't read in labview because Labview don't support.

The information as the attachment. Please help me read value in the first Column to time as red area on Fx.

Thanks and Best Regards

[crossrulz]

Can you attach the actual CSV file?  Also, post a sample of the code you have for trying to read this time stamp.

[HCMUI]

Dear Crossrulz.

Please refer csv file (in the *.zip file)  and VI to read time as attachments.

Thank you.

[crossrulz]

Try scanning your string like this.  There's a bug where the Scan From String doesn't like to pick up the fractional seconds in a specificly formatted timestamp string.  So I had to scan it separately and add.

[RavensFan]

What program created the CSV file?  Was it LabVIEW, Excel, something else?

[HCMUI]

Dear Crossrulz

Thanks for your reply. But string result is diffirent real value.

For example, when input string is: 6:12.3, output is: 7:06:12.300 but real value is 12:06:12 AM (as information on #1)

Dear RavensFan.

The *.csv file created by Labview, can you help me about it?

Thanks all.

[RavensFan]

Then have LabVIEW that creates a format for the time that works for you.  Right now you are only output minutes and seconds, it appears.  That is all that is in your file.

if 6:12.3 is supposed to be 7:06:12.3, what did you do with the hour?  You didn't write it out to the file.

Show the VI you used to create the CSV file.  Until you get that correct, there is no way you are going to get Excel or another LabVIEW VI to be able to read the file the way you want it to.