Clear Filters
Clear Filters

1000 separator and decimal separator are both commas

3 views (last 30 days)
I am working with data that has some numbers that have two commas as separators and thus when I replace them with dots, matlab throws me an error.
Is it possible to remove only the 1000 separator comma in these numbers?
s = {'801,24','-594,041','97,263';'799,187','-592,496','97,413';'1,201,618','-458,342','98,11';'1,200,226','-457,107','98,187'}

Accepted Answer

Walter Roberson
Walter Roberson on 19 Apr 2021
str2double(regexprep(s, {',(?=.*,)', ','}, {'', '.'}))

More Answers (0)

Categories

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!