Wrong JSON conversion?

[aborruso]

Hi,
if I run

echo "CUP=H64H15000820002,CODICE_LOCALE_PROGETTO=2191E" | mlr --ojson cat

I have

{ "CUP": "H64H15000820002", "CODICE_LOCALE_PROGETTO": 2191E }

But I should have "2191E" with double quotes, because it's a string and not a number. Am I wrong?

Thank you

[johnkerl]

I get

$ echo "CUP=H64H15000820002,CODICE_LOCALE_PROGETTO=2191E" | mlr --ojson cat
{ "CUP": "H64H15000820002", "CODICE_LOCALE_PROGETTO": "2191E" }

$ mlr --version
Miller v5.4.0-dev

and

$ echo "CUP=H64H15000820002,CODICE_LOCALE_PROGETTO=2191E" | ./miller-releases/miller-5.4.0/c/mlr --ojson cat
{ "CUP": "H64H15000820002", "CODICE_LOCALE_PROGETTO": "2191E" }

$ ./miller-releases/miller-5.4.0/c/mlr --version
Miller v5.4.0

[aborruso]

Hi @johnkerl,
I'm using debian (WSL in Windows10) and Miller v5.4.0-dev, but I have wrong result :(

[johnkerl]

Weird.

[johnkerl]

mlr --ojson --jvquoteall cat is a workaround here ...

[aborruso]

hi @johnkerl thank you I know, but in this way I will have also "fieldNumber": "1254" and I would like to have "fieldNumber": 1254

[johnkerl]

:(

[johnkerl]

Appears to be related to #178

[aborruso]

Appears to be related to #178

Ok, but the strange thing is that you have no error, as if the problem depended on the platform in which it was compiled

[aborruso]

@johnkerl a note: I have the same wrong result using the last compiled release for Linux https://github.com/johnkerl/miller/releases/download/5.4.0/mlr.linux.x86_64

With windows compiled version (mlr.exe) I have the right result

[aborruso]

Hi @johnkerl ,
in these days I'm working on this kind of input

tenders 3345
tenderers 6818
suppliers 3439
tendersZero 226
ID 01199250158

Is there a way to create a correct JSON as

{ "tenders": 3345, "tenderers": 6818, "suppliers": 3439, "tendersZero": 226, "ID": "01199250158" }

and not

{ "tenders": 3345, "tenderers": 6818, "suppliers": 3439, "tendersZero": 226, "ID": 01199250158 }

The last field is a string.

Thank you

[johnkerl]

This will be addressed by the Go port.

[johnkerl]

Fixed in Miller 6.