Converting JSONL to Array with PHP

Question

I have this piece of code to get the file from AWS S3 using aws/aws-sdk-php-laravel package.

try {
    $s3Client = AWS::createClient('s3');
    $result = $s3Client->getObject([
        'Bucket'    => static::$s3Bucket,
        'Key'       => $fileName
    ]);

    return $result['Body']->getContents();
} catch (S3Exception $e) {
    return;
}

it working fine, but when I tried to using explode(PHP_EOL, $result['Body']->getContents()); it's only showing 1 array, and inside that array there will be the result from the jsonl file, so how to extract the json data from jsonl file?

please show use the output of var_export($result['Body']->getContents());. so that we can come to know how actual data look like and why you are facing issue — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Nov 19, 2019 at 7:00
It's possible that the platform uses a different line encoding - try explode("\n", — Nigel Ren
– Nigel Ren, Commented Nov 19, 2019 at 7:01
Thanks @NigelRen, silly me forcing to use the PHP_EOL instead "\n", now its working fine — Khrisna Gunanasurya
– Khrisna Gunanasurya, Commented Nov 19, 2019 at 7:05
Hi @AnantSingh---AlivetoDie thanks for your comment, I just put the wrong delimiter right there — Khrisna Gunanasurya
– Khrisna Gunanasurya, Commented Nov 19, 2019 at 7:06

Nigel Ren · Accepted Answer · 2019-11-19 07:08:40Z

1

The problem is that when you use PHP_EOL, you are using the line break for your specific platform. This may be different than the file encoding.

In the spec of JSONL...

Line Separator is '\n'

So if your platform uses \r\n for end of lines (PHP_EOL) then it won't split the lines.

The solution is to always use \n for JSONL files...

explode("\n", $result['Body']->getContents());

answered Nov 19, 2019 at 7:08

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

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

Collectives™ on Stack Overflow

Converting JSONL to Array with PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related