Sublime Forum

JSON file open problem

#1

really wierd but when I open a json file I get a bunch of columns of data instead of normal text data… other editors opent he file fine… eg

7273 223b 4e3b 733a 343a 2272 6174 6522
3b73 3a35 3a22 3735 2e30 3022 3b7d 7d69
3a32 3833 3b61 3a32 3a7b 733a 323a 2266
6222 3b4f 3a31 383a 2246 7265 7368 426f
6f6b 735f 5072 6f6a 6563 7422 3a31 303a
7b73 3a31 353a 2200 2a00 5f65 6c65 6d65
6e74 4e61 6d65 223b 733a 373a 2270 726f
6a65 6374 223b 733a 393a 2270 726f 6a65
6374 4964 223b 733a 333a 2232 3833 223b
733a 343a 226e 616d 6522 3b73 3a31 363a
2241 7269 656c 4573 7475 6c69 6e2e 636f
6d22 3b73 3a31 303a 2262 696c 6c4d 6574
686f 6422 3b73 3a39 3a22 7461 736b 2d72
6174 6522 3b73 3a38 3a22 636c 6965 6e74
4964 223b 733a 333a 2231 3238 223b 733a
343a 2272 6174 6522 3b73 3a30 3a22 223b
733a 3131 3a22 6465 7363 7269 7074 696f
6e22 3b73 3a30 3a22 223b 733a 353a 2273
7461 6666 223b 613a 323a 7b69 3a30 3b73
3a32 303a 220a 2020 2020 2020 2020 2020
0a20 2020 2020 2020 2022 3b69 3a31 3b73
3a31 3a22 3122 3b7d 733a 353a 2274 6173
6b73 223b 613a 363a 7b69 3a30 3b61 3a32
3a7b 733a 373a 2274 6173 6b5f 6964 223b
733a 333a 2237 3037 223b 733a 343a 2272
6174 6522 3b73 3a35 3a22 3935 2e30 3022
3b7d 693a 313b 613a 323a 7b73 3a37 3a22
7461 736b 5f69 6422 3b73 3a33 3a22 3730

any ideas?

0 Likes

#2

It’s opening it in hexidecimal encoding. I forget how Sublime detects when to open it a file with this encoding, but you can manually change the encoding by going to File > Reopen With Encoding.

0 Likes

#3

Try uploading it to json-csv.com and you will be download it as a CSV spreadsheet.

0 Likes