Convert JSON in print format to valid JSON

Question

I have a text file that is formatted like JSON, but in a print/view friendly format and I want to convert that string to valid JSON. Basically, I want to read the file using PHP5 and call json_decode to deserialize the string. But, json_decode is not able to parse the "print-friendly" json string.

I am getting error 4 Invalid or malformed JSON.

It looks like someone else had a similar issue as me: PHP json_decode() returns NULL with valid JSON?

I am using notepad++ to write the json file.

So, how can I convert

FROM:

{
    "data": [
        {
            "thumbImg": "thumbImg",
            "street": "street",
            "city": "Fort Worth",
            "state": "Texas",
            "zip": "76192-0001",
            "url": "url"
        }
    ]
}

TO:

{"data":[{"thumbImg": "thumbImg", "street": "street", "city": "Fort Worth", "state": "Texas", "zip": "76192-0001", "url": "url"}]

I even tried doing the following:

<?php
$filename = "links.json";
$file = fopen($filename, "r");
    
$lines = file($filename);
    
$data = "";
;
foreach ($lines as $line_num => $line) {
    $formatted = trim($line);
    $formatted = str_replace("\r", "", $formatted);
    $formatted = str_replace("\n", "", $formatted);
    $data .= $formatted;        
}

$json = json_decode($data, true);
?>

I did a var_dump of the resulting json string and http://jsonlint.com/ marked it as valid json; however, json_decode is not able to deserialize the json string for some reason.

Thank you!

SOLUTION I set the encoding of the text file to UTF-8 without BOM and it works fine now. thank you all!

It works when I read from a text file (without mucking about with reformatting the text). It sounds like you have started with "I'm having problems reading a file" but you ended up asking "How can I reformat this file?", which is several steps down the line from the actual problem and has resulted in a question that isn't helpful to anyone. — Quentin, Sep 26 '10 at 07:25
`json_decode` works perfectly for me: http://codepad.org/wcNFa2F5 You should try `file_get_contents` to read the file: http://php.net/manual/en/function.file-get-contents.php — Felix Kling, Sep 26 '10 at 07:26
Have you tried `file_get_contents()` instead? Also when you read using `file()` there is no need to call `fopen()`. — BoltClock, Sep 26 '10 at 07:27
Ah, the byte-order mark must have been the cause of the parsing error. — BoltClock, Sep 26 '10 at 07:56

score 5 · Accepted Answer · answered Sep 26 '10 at 07:27

5

<?php
$filename = "links.json";
$file = file_get_contents($filename);    

$json = json_decode($file, true);
?>

References:
- file_get_contents()
- json_decode()

answered Sep 26 '10 at 07:27

Peter Ajtai

56,972
13
121
140

Thank you. It turns out the file-encoding of my text file was off. I changed the encoding of the source file to UTF-8 without BOM and it works great now! thank you all for the great support! – Abe Sep 26 '10 at 07:53

Convert JSON in print format to valid JSON

1 Answers1