# How can I to convert a cell to a double without losing the leading zeros?

7 views (last 30 days)
pink flower on 20 Sep 2020
Commented: Star Strider on 20 Sep 2020
I have a loop where I am trying to extract the numbers and convert them to double. However, when the numbers are "0000", the result is just "0". How can I do this?
for x = 1:length(ix20);
namex = files(i).name;
sss=regexp(namex, '(?:\d{4})\>','match');
format longg;
hm(x)=str2double(sss);
end

David Hill on 20 Sep 2020
I don't understand what you are trying to do. Please explain with an example (input and expected output). The double of '0000' is 0.
pink flower on 20 Sep 2020
This is an hour and minute data. I need to put them in an array, so I'm trying to do this cell to double transformation.

Star Strider on 20 Sep 2020
Thank you for quoting my code from Extracting numbers from mixed string !
It is not possible to retain leading zeros in a numeric representation, such as double. To retain leading zeros, they must be kept as character arrays (single quotes) or string variables (double quotes).
I would appreciate it if you would Accept my Answer that uses the regexp call you quoted!
.

pink flower on 20 Sep 2020
This is an hour and minute data. I need to put them in an array, so I'm trying to do this cell to double transformation. Can I do this without losing 0000?
Star Strider on 20 Sep 2020
The leading zeros would disappear if your converted them to numeric values.
If you want to convert them to datetime arrays, that would be straightforward:
out = compose("%04d", 0:5:20).'
DT = datetime(out, 'InputFormat',"HHmm", 'Format','HH:mm')
producing:
out =
5×1 string array
"0000"
"0005"
"0010"
"0015"
"0020"
DT =
5×1 datetime array
00:00
00:05
00:10
00:15
00:20
The ‘DT’ vector would then be saved as a datetime array (call it anything you wish), with the leading zeros intact, and converted to hours and minutes as well. (The 'InputFormat' string specifies how the input is parsed, and the 'Format' string specifies how it is displayed.)

Cris LaPierre on 20 Sep 2020
Edited: Cris LaPierre on 20 Sep 2020
I believe you would have to keep it a string in order to pad with zeros up front. See this post.