how to convert string quarterly dates into numerical values?

5 vues (au cours des 30 derniers jours)
Yelena
Yelena le 10 Jan 2015
Commenté : dpb le 10 Jan 2015
I have a column vector with quarterly dates ('Q1-2011', 'Q2-2011', etc.). I need to convert all entries in this column vector into strings so that I can create a time-series plot. Any ideas how to do it? I tried this program:
DateString = DataRussiaFinal1114(:,1);
formatIn = 'QQ-YY';
dates = datenum(DateString,formatIn);
But datenum gives an error: The input to DATENUM was not an array of strings.
  1 commentaire
dpb
dpb le 10 Jan 2015
What does
whos DateString
return? Either
>> datenum(['Q1-2011'; 'Q2-2011'],'QQ-YY')
ans =
734504
734594
or
>> datenum({'Q1-2011'; 'Q2-2011'},'QQ-YY')
ans =
734504
734594
>>
as character array or cellstr array work so must be some other storage issue that we can't see by description only...must see actual data.

Connectez-vous pour commenter.

Réponses (0)

Catégories

En savoir plus sur Dates and Time dans Help Center et File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by