Code: Select all

if (GetListOfFiles(0,"C:\\Temp\\","*.csv",false))
{
   // Define the field delimiter character.
   var sFieldDelimiter = ",";

   // Get decimal code value of delimiter as string with 1 or 2 leading zeros.
   var sCodeFieldDelimiter = sFieldDelimiter.charCodeAt(0).toString(10);
   while (sCodeFieldDelimiter.length < 3)
   {
      sCodeFieldDelimiter = '0' + sCodeFieldDelimiter;
   }

   // If there was no error and files are found in the directory, the
   // function made the search results output with the file names active.
   // Select all lines in the file and load the file names into an array.
   UltraEdit.activeDocument.selectAll();
   var sLineTerm = "\r\n";   // Default line terminator type is DOS.
   var nLineTermPos = UltraEdit.activeDocument.selection.search(/\r\n|\n|\r/);
   if (nLineTermPos >= 0)    // Any line terminator found?
   {
      // The list file is a Unix file if first character found is a line-feed.
      if (UltraEdit.activeDocument.selection[nLineTermPos] == '\n') sLineTerm = "\n";
      // The list file is a Mac file if first character found is a carriage
      // return and the next character is not a line-feed as in a DOS file.
      else if (UltraEdit.activeDocument.selection[nLineTermPos+1] != '\n') sLineTerm = "\r";
   }
   var asFileNames = UltraEdit.activeDocument.selection.split(sLineTerm);

   // The list is not needed anymore and therefore the results window is closed.
   UltraEdit.closeFile(UltraEdit.activeDocument.path,2);
   asFileNames.pop();  // Remove empty string at end of the list.

   // Now open one file after the other and process each file.
   for (var nFileIndex = 0; nFileIndex < asFileNames.length; nFileIndex++)
   {
      var sHeaderRow = ""; // Clear header row string from previous loop run.

      // Check if the CSV file to process is opened already in UltraEdit/UEStudio.
      for (var nDocIndex = 0; nDocIndex < UltraEdit.document.length; nDocIndex++)
      {
         if (asFileNames[nFileIndex] == UltraEdit.document[nDocIndex].path)
         {
            // Load current line and column number into variables.
            var nLineNumber = UltraEdit.document[nDocIndex].currentLineNum;
            var nColumnNumber = UltraEdit.document[nDocIndex].currentColumnNum;
            // The next line is only needed for UE < v16.00 as those versions
            // of UE return a column number with 0 for first number instead of 1.
            if (typeof(UltraEdit.activeDocumentIdx) == "undefined") nColumnNumber++;

            // Move caret to top of file.
            UltraEdit.document[nDocIndex].top();

            // Select the first line in file and copy it to string variable.
            UltraEdit.document[nDocIndex].selectLine();
            sHeaderRow = UltraEdit.document[nDocIndex].selection;

            // Restore initial position of caret in the file.
            UltraEdit.document[nDocIndex].gotoLine(nLineNumber,nColumnNumber);
            break;
         }
      }

      // Was the file to process not opened already and therefore the string
      // variable for header row is still an empty string with length 0?
      if (sHeaderRow.length == 0)
      {
         // Open the file to process.
         UltraEdit.open(asFileNames[nFileIndex]);

         // Select the first line in file and copy it to string variable.
         UltraEdit.document[nDocIndex].selectLine();
         sHeaderRow = UltraEdit.document[nDocIndex].selection;

         // Close the just opened file without saving it.
         UltraEdit.closeFile(UltraEdit.activeDocument.path,2);
      }

      // Get length of header row with line termination
      // and convert the number into a decimal string.
      var sTopOffset = sHeaderRow.length.toString(10);

      // Get type of line termination, define record delimiter
      // accordingly and remove the line termination form the string.
      if (sHeaderRow.lastIndexOf("\r\n") >= 0)
      {
         var sRecordDelimiter = "013 010";
         sHeaderRow = sHeaderRow.substr(0,sHeaderRow.length-2);
      }
      else if (sHeaderRow[sHeaderRow.length-1] == "\n")
      {
         var sRecordDelimiter = "010";
         sHeaderRow = sHeaderRow.substr(0,sHeaderRow.length-1);
      }
      else
      {
         var sRecordDelimiter = "013";
         sHeaderRow = sHeaderRow.substr(0,sHeaderRow.length-1);

      }

      // Remove all double quotes from header row. This would be wrong
      // if a double quote would be part of a field name in header row.
      sHeaderRow = sHeaderRow.replace(/\"/g,"");

      // Split header row into an array of strings using field delimiter.
      // This produces wrong result if a field string is quoted and contains
      // additionally the field delimiter. However, the header row does
      // usually not contain a field delimiter within a field value.
      var asFields = sHeaderRow.split(sFieldDelimiter);

      // Create in a string variable the lines for the definition file.
      var sDefinitionFile = "TopOffset," + sTopOffset + "\r\n";
      sDefinitionFile += "Field Delimiter= " + sCodeFieldDelimiter + "\r\n";
      sDefinitionFile += "Record Delimiter= " + sRecordDelimiter + "\r\n";
      sDefinitionFile += "Field Framing Character= 034\r\n";
      for (nFieldIndex = 0; nFieldIndex < asFields.length; nFieldIndex++)
      {
         sDefinitionFile += asFields[nFieldIndex] + ",,C\r\n";
      }

      // Create a new file and make sure it's an ASCII file with DOS
      // line terminators. Then write the lines into the new file.
      UltraEdit.newFile();
      UltraEdit.activeDocument.unixMacToDos();
      UltraEdit.activeDocument.unicodeToASCII();
      UltraEdit.activeDocument.write(sDefinitionFile);

      // Save the new file with name of CSV file after replacing
      // the file extension "csv" case-insensitive by "dmt".
      UltraEdit.saveAs(asFileNames[nFileIndex].replace(/csv$/i,"dmt"));
      UltraEdit.closeFile(UltraEdit.activeDocument.path,0);
   }
}

Code: Select all

ID,"First Name","Last Name",Address

Code: Select all

      // Remove all double quotes from header row. This would be wrong
      // if a double quote would be part of a field name in header row.
      sHeaderRow = sHeaderRow.replace(/\"/g,"");

      // Split header row into an array of strings using field delimiter.
      // This produces wrong result if a field string is quoted and contains
      // additionally the field delimiter. However, the header row does
      // usually not contain a field delimiter within a field value.
      var asFields = sHeaderRow.split(sFieldDelimiter);

Code: Select all

ID,"""First, Last Name""",Address

Code: Select all

TopOffset,35
Field Delimiter= 044
Record Delimiter= 013 010
Field Framing Character= 034
ID,,C
First,,C
Last Name,,C
Address,,C

Code: Select all

TopOffset,35
Field Delimiter= 044
Record Delimiter= 013 010
Field Framing Character= 034
ID,,C
"First, Last Name",,C
Address,,C