How to take data column in a character vector?
2 次查看(过去 30 天)
显示 更早的评论
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...
0 个评论
回答(1 个)
Voss
2023-7-27
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']
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(:)
It may be convenient to convert those to datetimes:
dates = datetime(dates)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Preprocessing 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!