Extracting data to plot time series with different colour for different days

I want to plot a time series plot of pressure data for different days, like the one I have attached below.

I am using the following files to read the data. In the dataset, before LTST, there is the sol no also attached, which I am not able to extract. I am not being able to extract both seperately. I was able to extract LMST and sol using extractAfter and extractBefore functions as there is a 'M' seperating them. Any suggestions on how to extract LTST and sol?

[KSSV]

USe readtable to read the csv file.

[Anirban Mandal]

I did that already. I used readtable to extract the column and used table2array to convert it. Then I used strfind to find the space between them and seperate them. But, it was giving me error. I am attaching the code. The problem is that table2arrray is converting it to a cell array and that's why the last two lines are giving me errors.

clear
clc

x=readtable('WE__0567___________CAL_PS__________________P01.csv');
timeinfo=table2array(x(:,3));
spaceidx=strfind(timeinfo, ' ');
sol=timeinfo(1:spaceidx-1);
ltst=timeinfo(spaceidx+1:end);

Answer 1

[Saffan]

Hi Anirban,

You can use the “split” function to extract “sol” values from LTST column using space as a delimiter.

Here is a code snippet to demonstrate that:

x = readtable('WE__0569___________CAL_PS__________________P01.csv');
timeinfo = table2array(x(:,3));

% Split timeinfo into SOL and LTST columns
splitCol = split(timeinfo, " ");

ltst = splitCol(:,2);
sol = str2double(splitCol(:,1));

Refer to this link for more information on splitting strings using delimiters:

Split strings at delimiters - MATLAB split (mathworks.com)

[Anirban Mandal]

Thanks. It will help.