Code: Select all

var sSeparator = ",";   // Separator to use in CSV file created by the script.

if (UltraEdit.document.length > 0)  // Is any file opened?
{
   // Define environment for this script.
   UltraEdit.insertMode();
   if (typeof(UltraEdit.columnModeOff) == "function") UltraEdit.columnModeOff();
   else if (typeof(UltraEdit.activeDocument.columnModeOff) == "function") UltraEdit.activeDocument.columnModeOff();
   UltraEdit.activeDocument.selectAll();
   if (UltraEdit.activeDocument.isSel())
   {
      // Get the data of interest with unwanted data between
      // and all line-feeds into an array of strings.
      var asData = UltraEdit.activeDocument.selection.match(/(?:"id":\d+[\t ]*?(?:,".+?){3},".+?:".+?"|\n)/g);
      UltraEdit.activeDocument.top();  // Cancel the selection.
      if (asData)                      // Was anything found at all?
      {
         var asDataValues  = [];   // array of arrays each with two arrays with variable number of strings
         var asIdentifiers = [];   // array of identifier strings in current line/row
         var asOptionNames = [];   // array of option name strings in current line/row
         var nTotalRowCount = 0;   // total number of data rows
         var nTotalColCount = 0;   // total number of data columns or more precise total
                                   // number of identifiers and option names per data row

         // Run the loop on each found string in data array.
         for (var nDataIndex = 0; nDataIndex < asData.length; nDataIndex++)
         {
            // Is the current string not a line-feed?
            if (asData[nDataIndex] != "\n")
            {
               // Use a regular expression to get just the wanted data
               // (identifier, option name) separated by a horizontal tab.
               asData[nDataIndex] = asData[nDataIndex].replace(/"id":(\d+)[\t \r\n]*?(?:,".+?){3},".+?:"(?:\d+\. )?(.*?)"/,"$1\t$2");
               // Add to array of identifiers of current line the identfier.
               asIdentifiers.push(asData[nDataIndex].replace(/(\d+).+$/,"$1"));
               // Add to array of option names of current line the option name.
               asOptionNames.push(asData[nDataIndex].replace(/\d+\t(.*)$/,"$1"));
            }
            else  // Line-feed marks end of a line/data row in JSON data file.
            {     // Was the previous processed string a data string?
               if (asIdentifiers.length)
               {
                  nTotalRowCount++;
                  // Has this line more identifiers then all lines before?
                  if (asIdentifiers.length > nTotalColCount)
                  {
                     nTotalColCount = asIdentifiers.length;
                  }
                  // Create a new array for this data row in CSV file
                  // and assign the identifier strings array and the
                  // option names array to this data row array.
                  var asRowData = new Array(2);
                  asRowData[0] = asIdentifiers;
                  asRowData[1] = asOptionNames;
                  // Append this array to the array containing structured
                  // all data values to write into CSV file.
                  asDataValues.push(asRowData);
                  // Create new arrays for identifiers and option names
                  // for the next data line read from JSON data file.
                  asIdentifiers = [];
                  asOptionNames = [];
               }
            }
         }

         // Delete all strings read from JSON file to free memory.
         asData.splice(0,asData.length);

         if (nTotalRowCount)
         {
            // Get type of line termination and code page of active file.
            var nLineTerm = UltraEdit.activeDocument.lineTerminator;
            var nEncoding = UltraEdit.activeDocument.codePage;
            var sFileName = UltraEdit.activeDocument.path;

            // Create a new file and make sure it has the same encoding
            // and the same line termination type as the JSON data file.
            UltraEdit.newFile();

            if (nEncoding != UltraEdit.activeDocument.codePage)
            {
               if (UltraEdit.activeDocument.codePage == 65001)
               {
                  UltraEdit.activeDocument.UTF8ToASCII();
               }
               else if ((UltraEdit.activeDocument.codePage == 1200) ||
                        (UltraEdit.activeDocument.codePage == 1201))
               {
                  UltraEdit.activeDocument.unicodeToASCII();
               }

               if (nEncoding == 65001)
               {
                  UltraEdit.activeDocument.ASCIIToUTF8();
               }
               else if ((nEncoding == 1200) || (nEncoding == 1201))
               {
                  UltraEdit.activeDocument.ASCIIToUnicode();
               }
            }

            // Create a string consisting only of separators according
            // to total number of identifiers / option names.
            var sSeparators = "";
            for (nDataIndex = 0; nDataIndex < nTotalColCount; nDataIndex++)
            {
               sSeparators += sSeparator;
            }

            // The search expression at top searched just for line-feeds.
            // So it is not possible that the JSON file is a MAC file.
            UltraEdit.activeDocument.unixMacToDos();
            var sLineTerm;
            if (nLineTerm < 1)
            {
               sLineTerm = "\r\n";
            }
            else
            {
               sLineTerm = "\n";
               UltraEdit.activeDocument.dosToUnix();
            }

            // Run the following loop on each data row array.
            for (var nRowIndex = 0; nRowIndex < nTotalRowCount; nRowIndex++)
            {
               // Join first all identifiers of current row to one string.
               var sDataRow = asDataValues[nRowIndex][0].join(",");
               // Has this data row less identifiers than at least one other
               // data row? Yes, append appropriate number of separators.
               if (asDataValues[nRowIndex][0].length < nTotalColCount)
               {
                  sDataRow += sSeparators.substr(asDataValues[nRowIndex][0].length);
               }

               // Append to data row string the option names enclosed
               // in double quotes.
               var nColCount = asDataValues[nRowIndex][1].length;
               for (var nColIndex = 0; nColIndex < nColCount; nColIndex++)
               {
                  sDataRow += ',"';
                  sDataRow += asDataValues[nRowIndex][1][nColIndex];
                  sDataRow += '"';
               }
               // Has this data row less option names than at least one other
               // data row? Yes, append appropriate number of separators. It
               // is not necessary to double quote the empty values.
               sDataRow += sSeparators.substr(nColCount);

               // Append the data row strings to the array of
               // data to write finally into the new file.
               asData.push(sDataRow);
            }

            // Append and empty string to data row strings array to
            // have also the last line finally terminated in CSV file.
            asData.push("");

            // Join the data row strings to a large block with determined
            // line terminator and write this block into the new file.
            UltraEdit.activeDocument.write(asData.join(sLineTerm));

            // Has the JSON data file a file name detected
            // on containing a backslash or a forward slash?
            if (sFileName.search(/[\\\/]/) >= 0)
            {
               // Replace the file extension of JSON file by ".csv".
               sCsvFileName = sFileName.replace(/\.[^.]+$/,".csv");
               // Append the file extension ".csv" if the
               // JSON file has no file extension at all.
               if (sCsvFileName == sFileName) sCsvFileName += ".csv";
               // Save the new file as CSV file with name of JSON file.
               UltraEdit.saveAs(sCsvFileName);
            }
            // Move caret to top in new file although not really needed.
            UltraEdit.activeDocument.top();
         }
      }
   }
}

Code: Select all

87116473,87116474,87116475,87116476,,"ABC","DEF","GHI","JKL",
896834,814835,514836,464837,894838,"KKK","LLL","MMM","NNN","OOO"