Quality - Prevention - Nutrition - Control _100g fields values as digits only

[ArchiMageAlex]

Describe the bug
There are some values with _100g postfix contains underscores at start of value, that prevents of normal filtering and searching

Expected behavior
Values must be controlled at insert time or dynamically converted to numeric values with known issues like this.

Number of products impacted
dozens

[ArchiMageAlex]

I run check with my converter. There are errors in data:

Value of field fiber_100g, product code=0028400231053 contains underscore: _6.7
Value of field selenium_100g, product code=0032971251990 contains underscore: _0.000002
Value of field copper_100g, product code=0042400149927 contains underscore: _6.896552
Value of field fiber_100g, product code=0071828003108 contains underscore: _20
Value of field vitamin_a_100g, product code=0072392312726 contains underscore: _0.0003396
Value of field fiber_100g, product code=0614360000107 contains underscore: _1
Value of field proteins_100g, product code=04029816 contains underscore: _500
Value of field sugars_100g, product code=3161712000928 contains underscore: _0.1
Value of field fiber_100g, product code=7501024577057 contains underscore: _6.67
Value of field fiber_100g, product code=7501024577262 contains underscore: _1
Value of field fiber_100g, product code=7501024577286 contains underscore: _6.67
Value of field fiber_100g, product code=7501055904914 contains underscore: _0.417
Value of field fiber_100g, product code=7501055905072 contains underscore: _0.417
Value of field fiber_100g, product code=7501055905850 contains underscore: _0.4
Value of field fiber_100g, product code=7501055905942 contains underscore: _0.4
Value of field fiber_100g, product code=7501055905997 contains underscore: _0.417
Value of field sugars_100g, product code=7501069210759 contains underscore: _1
Value of field iron_100g, product code=8850649009290 contains underscore: _0.00026

[stephanegigandet]

That's interesting. It looks like someone tried to enter negative values:
https://fr.openfoodfacts.org/api/v0/produit/7501055905997/frutal-delactosado-sabor-fresa-alpura

[teolemon]

How widespread is the issue @ArchiMageAlex ?

[github-actions]

This issue has been open 90 days with no activity. Can you give it a little love by linking it to a parent issue, adding relevant labels and projets, creating a mockup if applicable, adding code pointers from https://github.com/openfoodfacts/openfoodfacts-server/blob/main/.github/labeler.yml, giving it a priority, editing the original issue to have a more comprehensive description… Thank you very much for your contribution to 🍊 Open Food Facts