Package org.json

Class CDL


  • public class CDL
    extends java.lang.Object
    This provides static methods to convert comma delimited text into a JSONArray, and to covert a JSONArray into comma delimited text. Comma delimited text is a very popular format for data interchange. It is understood by most database, spreadsheet, and organizer programs.

    Each row of text represents a row in a table or a data record. Each row ends with a NEWLINE character. Each row contains one or more values. Values are separated by commas. A value can contain any character except for comma, unless is is wrapped in single quotes or double quotes.

    The first row usually contains the names of the columns.

    A comma delimited list can be converted into a JSONArray of JSONObjects. The names for the elements in the JSONObjects can be taken from the names in the first row.

    Since:
    Ptolemy II 10.0
    Version:
    $Id$, 2009-09-11
    Author:
    JSON.org
    • Constructor Summary

      Constructors 
      Constructor Description
      CDL()  
    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static JSONArray rowToJSONArray​(JSONTokener x)
      Produce a JSONArray of strings from a row of comma delimited values.
      static JSONObject rowToJSONObject​(JSONArray names, JSONTokener x)
      Produce a JSONObject from a row of comma delimited text, using a parallel JSONArray of strings to provides the names of the elements.
      static java.lang.String rowToString​(JSONArray ja)
      Produce a comma delimited text row from a JSONArray.
      static JSONArray toJSONArray​(java.lang.String string)
      Produce a JSONArray of JSONObjects from a comma delimited text string, using the first row as a source of names.
      static JSONArray toJSONArray​(JSONArray names, java.lang.String string)
      Produce a JSONArray of JSONObjects from a comma delimited text string using a supplied JSONArray as the source of element names.
      static JSONArray toJSONArray​(JSONArray names, JSONTokener x)
      Produce a JSONArray of JSONObjects from a comma delimited text string using a supplied JSONArray as the source of element names.
      static JSONArray toJSONArray​(JSONTokener x)
      Produce a JSONArray of JSONObjects from a comma delimited text string, using the first row as a source of names.
      static java.lang.String toString​(JSONArray ja)
      Produce a comma delimited text from a JSONArray of JSONObjects.
      static java.lang.String toString​(JSONArray names, JSONArray ja)
      Produce a comma delimited text from a JSONArray of JSONObjects using a provided list of names.
      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • Constructor Detail

      • CDL

        public CDL()
    • Method Detail

      • rowToJSONArray

        public static JSONArray rowToJSONArray​(JSONTokener x)
                                        throws JSONException
        Produce a JSONArray of strings from a row of comma delimited values.
        Parameters:
        x - A JSONTokener of the source text.
        Returns:
        A JSONArray of strings.
        Throws:
        JSONException
      • rowToJSONObject

        public static JSONObject rowToJSONObject​(JSONArray names,
                                                 JSONTokener x)
                                          throws JSONException
        Produce a JSONObject from a row of comma delimited text, using a parallel JSONArray of strings to provides the names of the elements.
        Parameters:
        names - A JSONArray of names. This is commonly obtained from the first row of a comma delimited text file using the rowToJSONArray method.
        x - A JSONTokener of the source text.
        Returns:
        A JSONObject combining the names and values.
        Throws:
        JSONException
      • toJSONArray

        public static JSONArray toJSONArray​(java.lang.String string)
                                     throws JSONException
        Produce a JSONArray of JSONObjects from a comma delimited text string, using the first row as a source of names.
        Parameters:
        string - The comma delimited text.
        Returns:
        A JSONArray of JSONObjects.
        Throws:
        JSONException
      • toJSONArray

        public static JSONArray toJSONArray​(JSONTokener x)
                                     throws JSONException
        Produce a JSONArray of JSONObjects from a comma delimited text string, using the first row as a source of names.
        Parameters:
        x - The JSONTokener containing the comma delimited text.
        Returns:
        A JSONArray of JSONObjects.
        Throws:
        JSONException
      • toJSONArray

        public static JSONArray toJSONArray​(JSONArray names,
                                            java.lang.String string)
                                     throws JSONException
        Produce a JSONArray of JSONObjects from a comma delimited text string using a supplied JSONArray as the source of element names.
        Parameters:
        names - A JSONArray of strings.
        string - The comma delimited text.
        Returns:
        A JSONArray of JSONObjects.
        Throws:
        JSONException
      • toJSONArray

        public static JSONArray toJSONArray​(JSONArray names,
                                            JSONTokener x)
                                     throws JSONException
        Produce a JSONArray of JSONObjects from a comma delimited text string using a supplied JSONArray as the source of element names.
        Parameters:
        names - A JSONArray of strings.
        x - A JSONTokener of the source text.
        Returns:
        A JSONArray of JSONObjects.
        Throws:
        JSONException
      • rowToString

        public static java.lang.String rowToString​(JSONArray ja)
        Produce a comma delimited text row from a JSONArray. Values containing the comma character will be quoted. Troublesome characters may be removed.
        Parameters:
        ja - A JSONArray of strings.
        Returns:
        A string ending in NEWLINE.
      • toString

        public static java.lang.String toString​(JSONArray ja)
                                         throws JSONException
        Produce a comma delimited text from a JSONArray of JSONObjects. The first row will be a list of names obtained by inspecting the first JSONObject.
        Parameters:
        ja - A JSONArray of JSONObjects.
        Returns:
        A comma delimited text.
        Throws:
        JSONException
      • toString

        public static java.lang.String toString​(JSONArray names,
                                                JSONArray ja)
                                         throws JSONException
        Produce a comma delimited text from a JSONArray of JSONObjects using a provided list of names. The list of names is not included in the output.
        Parameters:
        names - A JSONArray of strings.
        ja - A JSONArray of JSONObjects.
        Returns:
        A comma delimited text.
        Throws:
        JSONException