Answers

• gaveyom Members

  January 2013 edited January 2013

  Hi Gayathri,
  
  hope the below code will help u
  
  

  
  
  var $writeData = [];
  var $data_CSV = [];
  
  var $csvFilePath = "D:/csvfile.csv";
  var $data_CSV = _readCSVFile($csvFilePath);
  
  try {
  
  	for(var $cnt_Row=0; $cnt_Row<$data_CSV.length; $cnt_Row++) {
  	
  		for(var $cnt_Clm=0; $cnt_Clm<$data_CSV[$cnt_Row].length; $cnt_Clm++) {
  
  			$writeData[$cnt_Row][$cnt_Clm] = $data_CSV[$cnt_Row][$cnt_Clm] +"append your manipulated content here";
  		}
  	}
  }catch($e) {
  	_logExceptionAsFailure("Exception: "+ $e);
  }
  
  // you can write manipulated array data($writeData) into another csv file by using _writeCSVFile
  _writeCSVFile($writeData, "ManipulatedData.csv", true);
  
  
  
  
• Gayathri Members

  January 2013

  Thanks. I reused yours with just one loop...
  
  The below one (with just one 'For' loop) make it much simpler for my requirement.
  
  var $data_CSV = [];
  var $csvFilePath = "getRowCount.csv";
  var $data_CSV = _readCSVFile($csvFilePath);
  try
  {
  for(var $cnt_Row=0; $cnt_Row<$data_CSV.length; $cnt_Row++)
  {
  //_alert ($cnt_Row);
  
  }
  _alert ("Total rows in the input file is " +$cnt_Row);
  }
  catch($e)
  {
  _logExceptionAsFailure("Exception: "+ $e);
  }
  
  Thanks. It helped.
• gaveyom Members

  January 2013

  Hi Gayathri,
  
  one more thing i wanna update.
  
  if u wanna know only Total rows from the file then u can use as
  
  _alert("Total rows in the input file is: "+ $data_CSV.length); // instead of $cnt_Row
  
  Below is the modified total code
  

  
  var $data_CSV = [];
  var $csvFilePath = "getRowCount.csv";
  var $data_CSV = _readCSVFile($csvFilePath);
  _alert ("Total rows in the input file is: "+ $data_CSV.length);
  
  
• Gayathri Members

  January 2013

  ya. This is much better even without the loop. (I had been assuming that the variable object declared to read the file would read the complete 'contents' of the file - as we use in java.)
  
  Thanks for the update. It works now.