json char with too many decimals, need removal

3 次查看（过去 30 天）
Martin
Martin 2021-5-29
评论： Rik 2021-5-31
I got some json str = '{"hund": 0.3253533250000000000000000000000000, "kat": "dfsdfs", "baenkebider": 0.002021203321320000000000000000000000}';
In reality its a longer string with even more figures. I need to remove all those long decimals. 7-8 decimals is enough, so I end up with something like:
str = '{"hund": 0.3253533, "kat": "dfsdfs", "baenkebider": 0.0020212}';
If someone can help with an elegant solution I will appreciate it a lot!
Thanks in advance,
-best
mergh
  3 个评论
显示 1更早的评论
Martin
Martin 2021-5-30
Thanks for answering. join() and isfinite() is however a bit messy with regards to the cell piece.
dpb
dpb 2021-5-30
I knew Stephen or similar would be along...
You'll note I specifically did NOT say it was elegant... :)

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2021-5-30
编辑：Stephen23 2021-5-31
Ran in:
str = '{"hund": 0.3253533250000000000000000000000000, "kat": "dfsdfs", "baenkebider": 0.002021203321320000000000000000000000}';
Method one (truncate to 9 characters):
out = regexprep(str,'\d+\.\d+','${$&(1:9)}')
out = '{"hund": 0.3253533, "kat": "dfsdfs", "baenkebider": 0.0020212}'
Method two (seven fractional digits):
fun = @(s)sprintf('%.7f',sscanf(s,'%f'));
out = regexprep(str,'\d+\.\d+','${fun($&)}')
out = '{"hund": 0.3253533, "kat": "dfsdfs", "baenkebider": 0.0020212}'
  2 个评论
Rik
Rik 2021-5-31
This will of course not work on an arbitrary JSON string, so you need to be careful if you want to do so. You could consider using a custom JSON encoder that allows you to trim trailing 0 in decimal notation.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Mathematics 的更多信息

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by