/// <summary>
/// Loads all the values for the current line and returns them in a list
/// </summary>
/// <returns>Returns a list of values</returns>
public List<string> GetValues()
{
HabaneroStringBuilder stringBuilder = new HabaneroStringBuilder(_currentLine.Replace(",\"\",", ",,"));
stringBuilder.SetQuotes(new string[] { "\"" });
stringBuilder.RemoveQuotedSections();
if (stringBuilder.IndexOf("\"") > -1)
{
string nextLine = _reader.ReadLine();
if (nextLine == null)
{
nextLine = "";
throw new UserException("Unclosed quote in CSV file, line " + _lineNo);
}
_currentLine = _currentLine + nextLine;
_lineNo++;
return GetValues();
}
List<string> values = new List<string>();
int commaPos = 0;
int pos = 0;
int endPos = 0;
do
{
commaPos = stringBuilder.IndexOf(",", pos);
if (commaPos == -1)
{
endPos = stringBuilder.ToString().Length;
}
else
{
endPos = commaPos;
}
string value = stringBuilder.Substring(pos, endPos - pos).PutBackQuotedSections().ToString().Trim();
if ((value.StartsWith("\"") && value.EndsWith("\"")) || (value.StartsWith("'") && value.EndsWith("'")))
{
value = value.Substring(1, value.Length - 2);
}
values.Add(value);
pos = commaPos + 1;
} while (commaPos != -1);
return values;
}
