how to import time value from text to labview

[newbieeng]

I search for it and find something on community (here) but the solution seems too complex. All I need is to transfer time data (in Hours:Minute:Second form) saved in a text file to labview. How could I do that? Is there an easy way?

Edit: Link

[GerdW]

Hi Egemen,

read the text and use ScanFromString with format string "%<%H:%M:%S>T.

It's all in the context help...

[mikeporter]

In addition to what Gerd said, if the time is in 12-hour format, change the %H to %I. In addition, if there is an AM or PM appended to the string, you may have to add %p to capture that value.

Mike...

PS: The link in your post seems to be broken.

[P@Anand]

A picture of what has been suggested here.

[newbieeng]

Thank you. But I have a problem on this. I have a text file that is covering time and data so I use read from spreadsheet file to use these data. I convert numer to string and after use scan from string function but it comes out error added to attachment. I added the code to the attachment too.

[GerdW]

Hi newbie,

when you have mixed data you should read your "Excel" data as array of strings and convert your columns independently according to their datatype...

When you load your text like you do right now you will not receive any useful information for those timestamps (as you could easily see with a probe)...

[mikeporter]

Does the first column really have numbers in it? What does the file you are reading look like?

MIke...

[newbieeng]

I attached the text data file below.

[GerdW]

Hi newbie,

did you even tried to program that small snippet on your own after receiving so many suggestions?

[newbieeng]

Thank you GerdW. I tried it and it works. But is there a way to delete this date (01.01.1904) below the time data in timestamp?