// Fix format issues.
String prepareStringForOutput( String value )
{
	if (value != null)
	{
		value = value.replaceAll("\"", "\'");
		value = value.replaceAll("&", "&");	
		value = value.replaceAll(" ", " ");
		value = value.trim();
	}
	return "\"" + ( (value==null || value.equals( " " ))? "" : value ) + "\"";
}

// Set name of file to write to.
outputFile = "SAGE.CSV";

// Error catching.
try
{
	File file = new File( outputFile );
	fileExists = file.exists();
	
	// Open up the file to be appended to.
	out = new FileWriter( outputFile, true );
	session.log( "Writing data to a file." );
	if (!fileExists)
	{
		// Write out the headers.
		out.write("\"COMPANY\"" + ",");
		out.write("\"CONTACT\"" + ",");
		out.write("\"PHONE\"" + ",");
		out.write("\"2ND_PHONE\"" + ",");
		out.write("\"EMAIL\"" + ",");
		out.write("\"FAX\"" + ",");
		out.write("\"WEBSITE\"" + ",");
		out.write("\"ADDRESS\"" + ",");
		out.write("\"CITY\"" + ",");
		out.write("\"STATE\"" + ",");
		out.write("\"ZIP\""); // No comma for last one.
		out.write( "\n" );
	}
		
	// Write columns.
	out.write( prepareStringForOutput(dataRecord.get( "COMPANY" ))+ "," );
  	out.write( prepareStringForOutput(dataRecord.get( "CONTACT" ))+ "," );
	out.write( prepareStringForOutput(dataRecord.get( "PHONE" ))+ "," );
	out.write( prepareStringForOutput(dataRecord.get( "2ND_PHONE" ))+ "," );
	out.write( prepareStringForOutput(dataRecord.get( "EMAIL" ))+ "," );
	out.write( prepareStringForOutput(dataRecord.get( "FAX" ))+ "," );
	out.write( prepareStringForOutput(dataRecord.get( "WEBSITE" ))+ "," );
	out.write( prepareStringForOutput(dataRecord.get( "ADDRESS" ))+ "," );
	out.write( prepareStringForOutput(dataRecord.get( "CITY" ))+ "," );
	out.write( prepareStringForOutput(dataRecord.get( "ST" ))+ "," );
	out.write( prepareStringForOutput(dataRecord.get( "ZIP" ))); // No comma for last one.
	out.write( "\n" );

	// Close up the file.
	out.close();
 
}

catch( Exception e )
{
	session.log( "An error occurred while writing the data to a file: " + e.getMessage() );
}