How do I remove leading digits in a .CSV

So I have a huge amount of data to process (in .csv form) and a product of the collection the time stamps come in the form of:

001 00:05:04:058299394

Matlab is not seeing this as a time or anything due to the 001 (day) mark on the front side of the stamp.

Is there a script or code that exists to remove this and get rid of the error that matlab is throwing.

Answer 1

[dpb]

If you have recent release which includes the datetime class, then read it as a date with the D format descriptor. "DDD" is the day-of-year field descriptor for 3-digit DOY. See

<datetime-properties Format> and links therefrom...

If not, post back with a short sample of the data file...

Answer 2

[Azzi Abdelmalek]

s='001 00:05:04:058299394'
a=regexp(s,'(?<=\s+)\S+','match')

[Matthew Engquist]

so that works perfect! How would I do this for a column of data?

Here is what I am looking at:

001 00:10:26.298066
001 00:10:26.303391
001 00:10:26.308716
001 00:10:26.314041
001 00:10:26.319365
001 00:10:26.324690
001 00:10:26.330015
001 00:10:26.335340
001 00:10:26.340665
001 00:10:26.345990
001 00:10:26.351315
001 00:10:26.356640
001 00:10:26.361965
001 00:10:26.367289
001 00:10:26.372614
001 00:10:26.377939
001 00:10:26.383264
001 00:10:26.388589
001 00:10:26.393914

[Azzi Abdelmalek]

v={'001 00:10:26.298066'
'001 00:10:26.303391'
'001 00:10:26.308716'
'001 00:10:26.314041'}
a= regexp(v,'(?<=\s+)\S+','match');
out=[a{:}]'