|
/*
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
* User: andy
* Date: 30/07/2006
* Time: 08:37
*/
using System;
using System.Collections;
namespace uk.org.aspellclark.common.file
{
/// <summary>
/// <name>ExcelCsvImportFile</name>
/// <namespace>uk.org.aspellclark.common</namespace>
/// <version>1.0</version>
/// <author>Andy Aspell-Clark</author>
/// <description>This is a specialization of the DelimitedFile class that is
/// delimited with tab characters, and ignores all characters that would be
/// invalid .when the data is inserted into a database.
/// </description>
/// <history>
/// <historyitem> 6 Aug 2004 1.0 ARA Initial Version.</historyitem>
/// </history>
/// </summary>
public class ExcelCsvImportFile : DelimitedFile
{
/// <summary>
/// constructor. defaults the delimieter to a comma character
/// </summary>
public ExcelCsvImportFile()
:base(",")
{
m_sFilename = ".csv";
}
private string removeInvalidCharacters(string aLine)
{
string tmpStr = aLine;
//tmpStr = tmpStr.Replace("'", "''");
//tmpStr = tmpStr.Replace("\"", "");
return tmpStr;
}
/// <summary>
/// reads the first line of the file
/// </summary>
/// <returns>a list of the fields in the first line of the file</returns>
public override ArrayList readFirstLineFromFile()
{
ArrayList alFields = new ArrayList();
String line = readFirstTextLineFromFile();
if (line != null)
{
alFields = convertLineToFields(line);
}
return alFields;
}
/// <summary>
/// reads the first line of the file
/// </summary>
/// <returns>a list of the fields in the first line of the file</returns>
public override ArrayList readNextLineFromFile()
{
ArrayList alFields = new ArrayList();
String line = readNextTextLineFromFile();
if (line != null)
{
alFields = convertLineToFields(line);
}
return alFields;
}
}//class
}//namespace
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.