On Thu, Nov 10, 2011 at 5:42 PM, Jim Lucas <lists@xxxxxxxxx> wrote:
> On 11/10/2011 6:45 AM, Bastien Koert wrote:
>> Morning all,
>>
>> I've been having some fun with converting a text data file import into
>> a json object for storage.
>>
>> I have a text file that is pipe delimited coming in via an upload. The
>> first row is the headers and the second row is the data.
>>
>> Using this code:
>>
>> $data = file("inline_Nov_8_2011.txt");
>>
>> if(count($data)==2){
>>
>> $keys = explode("|", $data[0]);
>> $fields = explode("|", $data[1]);
>>
>> $combine = array_combine($keys, $fields);
>>
>> $json = json_encode($combine);
>> }
>>
>> After the combine, I get an array that looks like this
>>
>> Array
>> (
>> ['Legal Last Name '] => Andros
>> ['Legal Middle Initial '] =>
>> ['Legal First Name '] => Marisa
>> ['Maiden/Other Name '] =>
>> ['Social Insurance No. '] => 123456789
>> ['Date of Birth '] => 2/1/1988
>> ['Gender '] => Female
>> )
>>
>> But the json encoded value looks like this (there are way more
>> elements but this should be enough to represent what I need to do).
>>
>> {null:"Andros",null:"",null:"Marisa",null:"",null:"123456789",null:"2\/1\/1988",null:"Female"}
>>
>> I have been googling for info about allowed values for the json keys,
>> but can't seem to find a clear doc on what is allowed and what isn't.
>> I have tried unquoted keys, replaced the spaced with underscores but
>> nothing I do seems to help.
>>
>> When I echo out the json encoded data, the keys are all nulls.
>>
>> Can someone point me in the correct direction? It may be that I need
>> to manually create the key names as an array first, which I was hoping
>> to avoid since the file format coming from the client is still in some
>> flux.
>>
>
> Looking at your input array example, I see that you have trailing spaces in your
> keys. Looking at the working example of DiRaven, the only difference that I see
> with his example is that the input key values do not have a trailing spaces.
> json is probably having an issue with that trailing spaces.
>
That might be a possibility, but I suspect that the single quotes
around the keys might be a problem. I haven't tried it though.
Matijn
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
