How to use regex to obtain double values?
43 ビュー (過去 30 日間)
表示 古いコメント
Struggling in MATLAB
2022 年 7 月 29 日
コメント済み: Struggling in MATLAB
2022 年 7 月 29 日
I have an array of strings which contains some units. I have attahced the array.
unq = ["10 lux";"10lux";"15";"15.0";"15.5 Lux";"15luX";"15lux";"20lux";"36lux";"42lux";"9lux"]
They are put in different format on different days. So, I get 11 unique entries. I used the following code only to keep the numeric part.
trimData = strtrim(unq);
regexData = regexp(trimData,'\d*','Match');
cleanedData = cell(numel(unq),1);
for kk = 1:numel(unq)
if length(regexData{kk}) >= 1
cleanedData{kk} = regexData{kk}(1);
end
end
cleanedData = str2double(string(cleanedData));
I got
cleanedData = [10;10;15;15;15;15;15;20;36;42;9]
I am not getting 15.5 in the resulting array. How do get the numbers in which the digits after decimal place is not '0'? How do I write a regular expression for that?
0 件のコメント
採用された回答
Walter Roberson
2022 年 7 月 29 日
編集済み: Walter Roberson
2022 年 7 月 29 日
Extending to the possibility of fraction values that start with decimal point (with no leading zero), and extending to support negative values
But not extending to exponential format:
unq = ["10 lux";"-10lux";"15";"15.0";"15.5 Lux";"15luX";"15lux";"20lux";"36lux";"42lux";".9lux"]
regexData = regexp(unq, '(-?\d+(\.\d*)?)|(-?\.\d+)', 'match', 'once')
その他の回答 (0 件)
参考
カテゴリ
Find more on Data Type Conversion in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!