Reading text files with mixed data types.

[RT56]

I have been able to read an ASCII text file having mixed types of numbers (integer, real) and strings.  I cannot, however, read a time stamp that's in calendar and clock for mat (dd/mm/yy hh:mm:ss).  Given the line

12 34 03/26/11 01:23:45 56 78 90

I'd like to read the time directly, but so far all I can do is read the date/time as strings.  If reading it as a string is the best I can do, how I convert it to an internal time value?

[RavensFan]

Use the Scan from String function.  Use a format code that corresponds to the time format of your text.

[ABCPrograms]

if you post your file in here we could give you an example on how to do that.

Based on the information already given, this is what I have come up with 😉

Apologies if it doesn't really match with what you're looking for, but it's the best I could do with your info

[RavensFan · Accepted solution]

No need to break apart the time/date string into two different things.  Do it in one shot.

 

[ABCPrograms]

---

@Ravens Fan wrote:

No need to break apart the time/date string into two different things.  Do it in one shot.

---

That should work, but for some "strange" reason, it never does with me.  Must be something about me I guess 😉

[RT56]

Bjorn and Mike,

Thanks again for the help and ideas.  Attached is my solution, which, so far, seems to work.  Unfortunately, this should have been the easy part of the program.

Best regards,

Robin