How to take data column in a character vector?

Hi everyone,

I have a simple question about how to take data column from a character vector. This is my char vector :

vector = 'tangerang_lemi_raw_20230701.txt 01-Jul-2023 23:46 5049515

tangerang_lemi_raw_20230702.txt 02-Jul-2023 23:46 5049515

tangerang_lemi_raw_20230703.txt 03-Jul-2023 23:46 5049515

tangerang_lemi_raw_20230704.txt 04-Jul-2023 23:46 5049456

tangerang_lemi_raw_20230705.txt 05-Jul-2023 23:46 5141743

tangerang_lemi_raw_20230706.txt 06-Jul-2023 23:46 5052168

tangerang_lemi_raw_20230707.txt 07-Jul-2023 23:46 5049515

tangerang_lemi_raw_20230708.txt 08-Jul-2023 23:46 5049574

tangerang_lemi_raw_20230709.txt 09-Jul-2023 23:46 5049574

tangerang_lemi_raw_20230710.txt 10-Jul-2023 23:46 5049456

tangerang_lemi_raw_20230711.txt 11-Jul-2023 23:46 5049515

tangerang_lemi_raw_20230712.txt 12-Jul-2023 23:46 3752636

tangerang_lemi_raw_20230713.txt 13-Jul-2023 23:46 4596690

tangerang_lemi_raw_20230714.txt 14-Jul-2023 23:46 5049397

tangerang_lemi_raw_20230715.txt 15-Jul-2023 23:46 5049397

tangerang_lemi_raw_20230716.txt 16-Jul-2023 23:46 5049397

tangerang_lemi_raw_20230717.txt 17-Jul-2023 23:46 1242776

tangerang_lemi_raw_20230718.txt 18-Jul-2023 23:46 1306201

tangerang_lemi_raw_20230719.txt 19-Jul-2023 23:46 5080635

tangerang_lemi_raw_20230720.txt 20-Jul-2023 23:46 5047981

tangerang_lemi_raw_20230721.txt 21-Jul-2023 23:46 5047981

tangerang_lemi_raw_20230722.txt 22-Jul-2023 23:46 5047981

tangerang_lemi_raw_20230723.txt 23-Jul-2023 23:46 5047981

tangerang_lemi_raw_20230724.txt 24-Jul-2023 23:46 5047981

tangerang_lemi_raw_20230725.txt 25-Jul-2023 23:46 5048099

tangerang_lemi_raw_20230726.txt 26-Jul-2023 23:46 5048099

tangerang_lemi_raw_20230727.txt 27-Jul-2023 07:31 1596363'

I just want to take the second column, which is a datetime data :

01-Jul-2023 23:46; 02-Jul-2023 23:46; 03-Jul-2023 23:46.....

I would be so grateful if anyone could help me to do that....

Thank you so much, everyone...

Answer 1

[Voss]

vector = [ ...
     'tangerang_lemi_raw_20230701.txt                    01-Jul-2023 23:46             5049515'; ...
     'tangerang_lemi_raw_20230702.txt                    02-Jul-2023 23:46             5049515'; ...
     'tangerang_lemi_raw_20230703.txt                    03-Jul-2023 23:46             5049515'; ...
     'tangerang_lemi_raw_20230704.txt                    04-Jul-2023 23:46             5049456'; ...
     'tangerang_lemi_raw_20230705.txt                    05-Jul-2023 23:46             5141743'; ...
     'tangerang_lemi_raw_20230706.txt                    06-Jul-2023 23:46             5052168'; ...
     'tangerang_lemi_raw_20230707.txt                    07-Jul-2023 23:46             5049515'; ...
     'tangerang_lemi_raw_20230708.txt                    08-Jul-2023 23:46             5049574'; ...
     'tangerang_lemi_raw_20230709.txt                    09-Jul-2023 23:46             5049574'; ...
     'tangerang_lemi_raw_20230710.txt                    10-Jul-2023 23:46             5049456'; ...
     'tangerang_lemi_raw_20230711.txt                    11-Jul-2023 23:46             5049515'; ...
     'tangerang_lemi_raw_20230712.txt                    12-Jul-2023 23:46             3752636'; ...
     'tangerang_lemi_raw_20230713.txt                    13-Jul-2023 23:46             4596690'; ...
     'tangerang_lemi_raw_20230714.txt                    14-Jul-2023 23:46             5049397'; ...
     'tangerang_lemi_raw_20230715.txt                    15-Jul-2023 23:46             5049397'; ...
     'tangerang_lemi_raw_20230716.txt                    16-Jul-2023 23:46             5049397'; ...
     'tangerang_lemi_raw_20230717.txt                    17-Jul-2023 23:46             1242776'; ...
     'tangerang_lemi_raw_20230718.txt                    18-Jul-2023 23:46             1306201'; ...
     'tangerang_lemi_raw_20230719.txt                    19-Jul-2023 23:46             5080635'; ...
     'tangerang_lemi_raw_20230720.txt                    20-Jul-2023 23:46             5047981'; ...
     'tangerang_lemi_raw_20230721.txt                    21-Jul-2023 23:46             5047981'; ...
     'tangerang_lemi_raw_20230722.txt                    22-Jul-2023 23:46             5047981'; ...
     'tangerang_lemi_raw_20230723.txt                    23-Jul-2023 23:46             5047981'; ...
     'tangerang_lemi_raw_20230724.txt                    24-Jul-2023 23:46             5047981'; ...
     'tangerang_lemi_raw_20230725.txt                    25-Jul-2023 23:46             5048099'; ...
     'tangerang_lemi_raw_20230726.txt                    26-Jul-2023 23:46             5048099'; ...
     'tangerang_lemi_raw_20230727.txt                    27-Jul-2023 07:31             1596363']

vector = 27×88 char array
    'tangerang_lemi_raw_20230701.txt                    01-Jul-2023 23:46             5049515'
    'tangerang_lemi_raw_20230702.txt                    02-Jul-2023 23:46             5049515'
    'tangerang_lemi_raw_20230703.txt                    03-Jul-2023 23:46             5049515'
    'tangerang_lemi_raw_20230704.txt                    04-Jul-2023 23:46             5049456'
    'tangerang_lemi_raw_20230705.txt                    05-Jul-2023 23:46             5141743'
    'tangerang_lemi_raw_20230706.txt                    06-Jul-2023 23:46             5052168'
    'tangerang_lemi_raw_20230707.txt                    07-Jul-2023 23:46             5049515'
    'tangerang_lemi_raw_20230708.txt                    08-Jul-2023 23:46             5049574'
    'tangerang_lemi_raw_20230709.txt                    09-Jul-2023 23:46             5049574'
    'tangerang_lemi_raw_20230710.txt                    10-Jul-2023 23:46             5049456'
    'tangerang_lemi_raw_20230711.txt                    11-Jul-2023 23:46             5049515'
    'tangerang_lemi_raw_20230712.txt                    12-Jul-2023 23:46             3752636'
    'tangerang_lemi_raw_20230713.txt                    13-Jul-2023 23:46             4596690'
    'tangerang_lemi_raw_20230714.txt                    14-Jul-2023 23:46             5049397'
    'tangerang_lemi_raw_20230715.txt                    15-Jul-2023 23:46             5049397'
    'tangerang_lemi_raw_20230716.txt                    16-Jul-2023 23:46             5049397'
    'tangerang_lemi_raw_20230717.txt                    17-Jul-2023 23:46             1242776'
    'tangerang_lemi_raw_20230718.txt                    18-Jul-2023 23:46             1306201'
    'tangerang_lemi_raw_20230719.txt                    19-Jul-2023 23:46             5080635'
    'tangerang_lemi_raw_20230720.txt                    20-Jul-2023 23:46             5047981'
    'tangerang_lemi_raw_20230721.txt                    21-Jul-2023 23:46             5047981'
    'tangerang_lemi_raw_20230722.txt                    22-Jul-2023 23:46             5047981'
    'tangerang_lemi_raw_20230723.txt                    23-Jul-2023 23:46             5047981'
    'tangerang_lemi_raw_20230724.txt                    24-Jul-2023 23:46             5047981'
    'tangerang_lemi_raw_20230725.txt                    25-Jul-2023 23:46             5048099'
    'tangerang_lemi_raw_20230726.txt                    26-Jul-2023 23:46             5048099'
    'tangerang_lemi_raw_20230727.txt                    27-Jul-2023 07:31             1596363'

One way to extract the date column:

dates = regexpi(reshape(vector.',1,[]),'\d{2}-[a-z]{3}-\d{4} \d{2}:\d{2}','match');
dates = dates(:)

dates = 27×1 cell array
    {'01-Jul-2023 23:46'}
    {'02-Jul-2023 23:46'}
    {'03-Jul-2023 23:46'}
    {'04-Jul-2023 23:46'}
    {'05-Jul-2023 23:46'}
    {'06-Jul-2023 23:46'}
    {'07-Jul-2023 23:46'}
    {'08-Jul-2023 23:46'}
    {'09-Jul-2023 23:46'}
    {'10-Jul-2023 23:46'}
    {'11-Jul-2023 23:46'}
    {'12-Jul-2023 23:46'}
    {'13-Jul-2023 23:46'}
    {'14-Jul-2023 23:46'}
    {'15-Jul-2023 23:46'}
    {'16-Jul-2023 23:46'}
    {'17-Jul-2023 23:46'}
    {'18-Jul-2023 23:46'}
    {'19-Jul-2023 23:46'}
    {'20-Jul-2023 23:46'}
    {'21-Jul-2023 23:46'}
    {'22-Jul-2023 23:46'}
    {'23-Jul-2023 23:46'}
    {'24-Jul-2023 23:46'}
    {'25-Jul-2023 23:46'}
    {'26-Jul-2023 23:46'}
    {'27-Jul-2023 07:31'}

It may be convenient to convert those to datetimes:

dates = datetime(dates)

dates = 27×1 datetime array
   01-Jul-2023 23:46:00
   02-Jul-2023 23:46:00
   03-Jul-2023 23:46:00
   04-Jul-2023 23:46:00
   05-Jul-2023 23:46:00
   06-Jul-2023 23:46:00
   07-Jul-2023 23:46:00
   08-Jul-2023 23:46:00
   09-Jul-2023 23:46:00
   10-Jul-2023 23:46:00
   11-Jul-2023 23:46:00
   12-Jul-2023 23:46:00
   13-Jul-2023 23:46:00
   14-Jul-2023 23:46:00
   15-Jul-2023 23:46:00
   16-Jul-2023 23:46:00
   17-Jul-2023 23:46:00
   18-Jul-2023 23:46:00
   19-Jul-2023 23:46:00
   20-Jul-2023 23:46:00
   21-Jul-2023 23:46:00
   22-Jul-2023 23:46:00
   23-Jul-2023 23:46:00
   24-Jul-2023 23:46:00
   25-Jul-2023 23:46:00
   26-Jul-2023 23:46:00
   27-Jul-2023 07:31:00

[Voss]

@Tyann Hardyn: Did this answer work for you?