Parsing long json string in batch

Question

I have a problem, what I'm trying to do is just parse some values from JSON using batch...

I'm obtaining a JSON file by calling:

curl -G http://xxxxxx.xx/xx/xx

That calling returns a string which is 25 000 characters long, the valuse are "key":"value" separated by ,. I was trying to separate it by using for with delimeters but it doesn't work because that string is too long for storage in memory...

I really don't know how can I do that and if it's possible... Anybody any ideas?

Thanks

EDIT: json file looks like: json pastebin but it`s without whitespaces....

Please show your json file, you can upload a part to eg. pastebin. — Endoro
– Endoro, Commented Jul 19, 2013 at 14:59

jeb · Accepted Answer · 2013-07-19 15:25:51Z

1

Normally any line in a batch file can't exceed 8192 characters.
Only FOR /F can read any line from a file, but still you can't assign parameters longer than 8191bytes.

But if you split it in a way, so that each single parameter is smaller, then it works.
Even if you know that the thrid parameter is longer, then you simply can ignore it.

FOR /F "token=1-10 delims=," %%a in (longFile.txt) do (
  echo %%a
  echo %%b

  echo %%d
)

answered Jul 19, 2013 at 15:25

jeb

83.2k20 gold badges181 silver badges237 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

dbenham Over a year ago

+1, Very cool. I had no idea this was possible. Though I'm not sure it will help the OP. The values may not always be in the same order. And FOR /F cannot parse more than 32 values in one pass. If there are more than 32 values and the length after 31 is more than 8192, then it seems this is doomed to failure.

Dusan Plavak Over a year ago

Ok it looks like it can work, but the problem is, that in the response are not lines... everything is in one line so I need something what will say that what are delims for a newline

jeb Over a year ago

You could try to use { or } as a delim, but batch isn't the right language for this

Collectives™ on Stack Overflow

Parsing long json string in batch

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related