How to replace space with zero in a table?
    1 Ansicht (letzte 30 Tage)
  
       Ältere Kommentare anzeigen
    
    Sonima
      
 am 22 Jan. 2019
  
    
    
    
    
    Beantwortet: Peter Perkins
    
 am 23 Jan. 2019
            Hi!
I want to replace space with zero in the H4.Time without loop.
K>> head(H4)
ans =
  8×7 table
      Date       Time     Open     High      Low     Close    Volume
    ________    ______    _____    _____    _____    _____    ______
    20010102    200000     64.3    64.35    64.25    64.35     184  
    20010103         0     64.3    64.75     64.3    64.59     924  
    20010103     40000     64.6     64.7    64.39    64.52     932  
    20010103     80000    64.51    64.73    64.48    64.58     892
Any suggestion without loop to fix it?
Thanks.
1 Kommentar
  Walter Roberson
      
      
 am 22 Jan. 2019
				Are the entries char or are they numeric? If they were originally numeric that got converted to fixed width then why not just 0 pad at the time?
Time = num2str([200000;0;40000;80000], '%06d')
Akzeptierte Antwort
Weitere Antworten (1)
  Peter Perkins
    
 am 23 Jan. 2019
        Sia, you may find that using the datetime datatype for Date, and the duration data type for Time, makes your life easier. Storing numbers as text is not likely to very convenient.
0 Kommentare
Siehe auch
Kategorien
				Mehr zu Data Type Conversion finden Sie in Help Center und File Exchange
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!


