title: Inserting JSON array into Sqlite iPhone
body: <p>I'm getting JSON data like following in a NS array:</p>
  
  <p>It seems this is not valid JSON</p>
  
  <pre><code>jsonArray:
  {
      d = "[{\"Training_Code\":\"1234      \",\"Training_Duration\":\"2hrs      \",\"Training_Startdate\":\"14/02/2013 15:00:00\",\"Training_Enddate\":\"14/02/2013 17:00:00\",\"Trainer_ID\":1,\"Training_Location\":\"B-Wing Training room-4\",\"Comments\":\"C# training\",\"Keyword\":\"C#1234\",\"NumberofDays\":1},{\"Training_Code\":\"4321      \",\"Training_Duration\":\"16        \",\"Training_Startdate\":\"17/02/2013 10:30:00\",\"Training_Enddate\":\"17/02/2013 17:30:00\",\"Trainer_ID\":2,\"Training_Location\":\"A-Wing Training Room-6\",\"Comments\":\"Objective-C\",\"Keyword\":\"Obj-C4321\",\"NumberofDays\":2}]";
  }
  </code></pre>
  
  <p>I want to change this to valid json like this:</p>
  
  <pre><code>[
  {
      "Training_Code": "1234",
      "Training_Duration": "2hrs",
      "Training_Startdate": "14/02/201315: 00: 00",
      "Training_Enddate": "14/02/201317: 00: 00",
      "Trainer_ID": 1,
      "Training_Location": "B-WingTrainingroom-4",
      "Comments": "C#training",
      "Keyword": "C#1234",
      "NumberofDays": 1
  },
  {
      "Training_Code": "4321",
      "Training_Duration": "16",
      "Training_Startdate": "17/02/201310: 30: 00",
      "Training_Enddate": "17/02/201317: 30: 00",
      "Trainer_ID": 2,
      "Training_Location": "A-WingTrainingRoom-6",
      "Comments": "Objective-C",
      "Keyword": "Obj-C4321",
      "NumberofDays": 2
  }
  </code></pre>
  
  <p>]</p>
  
  <p>Note: I do not know, from where this "d" is comming...Plaese suggest keeping this in mind.</p>
  
  <p>How can I  change to valid json and insert this in my Sqlite DB? Thanks.</p>