How can I extract an array of numbers from a text-formatted cell array of strings.
I have read some data from a spreadsheet. The values are times, but formatted with s, m or h as a suffix to indicate seconds, minutes or hours. see example below,
I’d like to convert all of them to seconds, with NaN for the blank ones.
Is there an elegant way to do this?
Like this:
{’20s’ }
{’15m’ }
{0×0 char }
{’24s’ }
{0×0 char }
{’44s’ }
{‘3h’ }
{’40m’ }
{’20s’ }
{0×0 char }
{’14s’ }I have read some data from a spreadsheet. The values are times, but formatted with s, m or h as a suffix to indicate seconds, minutes or hours. see example below,
I’d like to convert all of them to seconds, with NaN for the blank ones.
Is there an elegant way to do this?
Like this:
{’20s’ }
{’15m’ }
{0×0 char }
{’24s’ }
{0×0 char }
{’44s’ }
{‘3h’ }
{’40m’ }
{’20s’ }
{0×0 char }
{’14s’ } I have read some data from a spreadsheet. The values are times, but formatted with s, m or h as a suffix to indicate seconds, minutes or hours. see example below,
I’d like to convert all of them to seconds, with NaN for the blank ones.
Is there an elegant way to do this?
Like this:
{’20s’ }
{’15m’ }
{0×0 char }
{’24s’ }
{0×0 char }
{’44s’ }
{‘3h’ }
{’40m’ }
{’20s’ }
{0×0 char }
{’14s’ } cell array, format MATLAB Answers — New Questions