This file format i want to extract time and Value. What should I do??

date              time                       value
3/24/2022 11:35:02.882 AM	5.3259E-3	J
3/24/2022 11:35:02.781 AM	5.7541E-3	J
3/24/2022 11:35:02.682 AM	6.4423E-3	J
3/24/2022 11:35:02.580 AM	5.8835E-3	J
3/24/2022 11:35:02.482 AM	5.8464E-3	J
3/24/2022 11:35:02.379 AM	4.6127E-3	J
3/24/2022 11:35:02.281 AM	5.3186E-3	J
3/24/2022 11:35:02.180 AM	6.6594E-3	J
3/24/2022 11:35:02.084 AM	5.7444E-3	J
3/24/2022 11:35:01.977 AM	5.2880E-3	J
3/24/2022 11:35:01.883 AM	6.2769E-3	J
3/24/2022 11:35:01.776 AM	5.9235E-3	J
3/24/2022 11:35:01.685 AM	6.0936E-3	J
3/24/2022 11:35:01.576 AM	6.2709E-3	J
3/24/2022 11:35:01.486 AM	5.9826E-3	J
3/24/2022 11:35:01.376 AM	5.6830E-3	J
3/24/2022 11:35:01.283 AM	5.0717E-3	J
3/24/2022 11:35:01.178 AM	5.0543E-3	J
3/24/2022 11:35:01.086 AM	7.0480E-3	J
3/24/2022 11:35:00.977 AM	5.6264E-3	J

Answer 1

[Akira Agata]

How about the following?

% Read and arange the data
url = 'https://jp.mathworks.com/matlabcentral/answers/uploaded_files/976045/textfile.txt';
TT = readtimetable(url,'Delimiter','\t');
TT.Properties.VariableNames = {'Value','Type'};

% Show the result
TT

TT = 599×2 timetable
               Time                 Value      Type 
    __________________________    _________    _____

    03/24/2022 11:35:02.882 AM    0.0053259    {'J'}
    03/24/2022 11:35:02.781 AM    0.0057541    {'J'}
    03/24/2022 11:35:02.682 AM    0.0064423    {'J'}
    03/24/2022 11:35:02.580 AM    0.0058835    {'J'}
    03/24/2022 11:35:02.482 AM    0.0058464    {'J'}
    03/24/2022 11:35:02.379 AM    0.0046127    {'J'}
    03/24/2022 11:35:02.281 AM    0.0053186    {'J'}
    03/24/2022 11:35:02.180 AM    0.0066594    {'J'}
    03/24/2022 11:35:02.084 AM    0.0057444    {'J'}
    03/24/2022 11:35:01.977 AM     0.005288    {'J'}
    03/24/2022 11:35:01.883 AM    0.0062769    {'J'}
    03/24/2022 11:35:01.776 AM    0.0059235    {'J'}
    03/24/2022 11:35:01.685 AM    0.0060936    {'J'}
    03/24/2022 11:35:01.576 AM    0.0062709    {'J'}
    03/24/2022 11:35:01.486 AM    0.0059826    {'J'}
    03/24/2022 11:35:01.376 AM     0.005683    {'J'}

[Subhadip Paul]

thank you Akira, but i want to extract the time values to millisecond order and corresponding value.

Answer 2

[Stephen23]

tbl = readtable('textfile.txt','delimiter','\t')

tbl = 599×3 table
               Var1                 Var2       Var3 
    __________________________    _________    _____

    03/24/2022 11:35:02.882 AM    0.0053259    {'J'}
    03/24/2022 11:35:02.781 AM    0.0057541    {'J'}
    03/24/2022 11:35:02.682 AM    0.0064423    {'J'}
    03/24/2022 11:35:02.580 AM    0.0058835    {'J'}
    03/24/2022 11:35:02.482 AM    0.0058464    {'J'}
    03/24/2022 11:35:02.379 AM    0.0046127    {'J'}
    03/24/2022 11:35:02.281 AM    0.0053186    {'J'}
    03/24/2022 11:35:02.180 AM    0.0066594    {'J'}
    03/24/2022 11:35:02.084 AM    0.0057444    {'J'}
    03/24/2022 11:35:01.977 AM     0.005288    {'J'}
    03/24/2022 11:35:01.883 AM    0.0062769    {'J'}
    03/24/2022 11:35:01.776 AM    0.0059235    {'J'}
    03/24/2022 11:35:01.685 AM    0.0060936    {'J'}
    03/24/2022 11:35:01.576 AM    0.0062709    {'J'}
    03/24/2022 11:35:01.486 AM    0.0059826    {'J'}
    03/24/2022 11:35:01.376 AM     0.005683    {'J'}

tod = timeofday(tbl.Var1)

tod = 599×1 duration array
   11:35:02
   11:35:02
   11:35:02
   11:35:02
   11:35:02
   11:35:02
   11:35:02
   11:35:02
   11:35:02
   11:35:01
   11:35:01
   11:35:01
   11:35:01
   11:35:01
   11:35:01
   11:35:01
   11:35:01
   11:35:01
   11:35:01
   11:35:00
   11:35:00
   11:35:00
   11:35:00
   11:35:00
   11:35:00
   11:35:00
   11:35:00
   11:35:00
   11:35:00
   11:34:59

val = tbl.Var2

val = 599×1

0.0053 0.0058 0.0064 0.0059 0.0058 0.0046 0.0053 0.0067 0.0057 0.0053

[Subhadip Paul]

thank you very much

but i want time values to milisecond order

HH:MM:SS.FFF

this should be the order

[Stephen23]

"but i want time values to milisecond order HH:MM:SS.FFF this should be the order"

Of course you can easily change the DURATION format (note that this does not change the stored values):

https://www.mathworks.com/help/matlab/ref/duration.html#mw_7dddd595-1be8-452b-8270-5589013aa7d4

tbl = readtable('textfile.txt','delimiter','\t')

tbl = 599×3 table
               Var1                 Var2       Var3 
    __________________________    _________    _____

    03/24/2022 11:35:02.882 AM    0.0053259    {'J'}
    03/24/2022 11:35:02.781 AM    0.0057541    {'J'}
    03/24/2022 11:35:02.682 AM    0.0064423    {'J'}
    03/24/2022 11:35:02.580 AM    0.0058835    {'J'}
    03/24/2022 11:35:02.482 AM    0.0058464    {'J'}
    03/24/2022 11:35:02.379 AM    0.0046127    {'J'}
    03/24/2022 11:35:02.281 AM    0.0053186    {'J'}
    03/24/2022 11:35:02.180 AM    0.0066594    {'J'}
    03/24/2022 11:35:02.084 AM    0.0057444    {'J'}
    03/24/2022 11:35:01.977 AM     0.005288    {'J'}
    03/24/2022 11:35:01.883 AM    0.0062769    {'J'}
    03/24/2022 11:35:01.776 AM    0.0059235    {'J'}
    03/24/2022 11:35:01.685 AM    0.0060936    {'J'}
    03/24/2022 11:35:01.576 AM    0.0062709    {'J'}
    03/24/2022 11:35:01.486 AM    0.0059826    {'J'}
    03/24/2022 11:35:01.376 AM     0.005683    {'J'}

tod = timeofday(tbl.Var1);
tod.Format = 'hh:mm:ss.SSS' % <------- did you try changing the format?

tod = 599×1 duration array
   11:35:02.882
   11:35:02.781
   11:35:02.682
   11:35:02.580
   11:35:02.482
   11:35:02.379
   11:35:02.281
   11:35:02.180
   11:35:02.084
   11:35:01.977
   11:35:01.883
   11:35:01.776
   11:35:01.685
   11:35:01.576
   11:35:01.486
   11:35:01.376
   11:35:01.283
   11:35:01.178
   11:35:01.086
   11:35:00.977
   11:35:00.885
   11:35:00.777
   11:35:00.684
   11:35:00.577
   11:35:00.486
   11:35:00.377
   11:35:00.285
   11:35:00.177
   11:35:00.085
   11:34:59.977

[Subhadip Paul]

Thank you stephen.

yes, i am really looking for it.