public void WhenLinesHaveCr_ThenReturnTwoLines()
{
var text = CsvHeader + "\r" + Line1 + "\r" + Line2;
var fileInfo = FileTestBuilder.InFileSystem
.WithFilePath(Path.Combine(WorkingDir, "Test1.csv"))
.WithText(text)
.Build();
var result = Act(fileInfo.FullName);
Assert.That(result.First().Values, Is.EquivalentTo(Line1.Split(',')));
Assert.That(result.Second().Values, Is.EquivalentTo(Line2.Split(',')));
}
} // FillFromOneLine
private void FillFromTwoLines(CustomerAddressModel filled)
{
filled.HouseNumber = Regex.Match(Line1, "\\d*").Value;
if (!string.IsNullOrWhiteSpace(filled.HouseNumber))
{
var line1 = Line1.Split(' ');
filled.HouseNumber = line1[0];
filled.Address1 = string.Join(" ", line1.Skip(1));
filled.Address2 = Line2;
return;
} // if
string uLine1 = Line1.ToUpper();
if (uLine1.StartsWith("APARTMENT") || uLine1.StartsWith("FLAT"))
{
filled.FlatOrApartmentNumber = Line1;
filled.HouseNumber = Regex.Match(Line2, "\\d*").Value;
if (!string.IsNullOrWhiteSpace(filled.HouseNumber))
{
var line2 = Line2.Split(' ');
filled.HouseNumber = line2[0];
filled.Address1 = string.Join(" ", line2.Skip(1));
}
else
{
filled.Address1 = Line2;
}
}
else
{
filled.HouseNumber = Regex.Match(Line2, "\\d*").Value;
filled.HouseName = Line1;
if (!string.IsNullOrWhiteSpace(filled.HouseNumber))
{
var line2 = Line2.Split(' ');
filled.HouseNumber = line2[0];
filled.Address1 = string.Join(" ", line2.Skip(1));
}
else
{
filled.Address1 = Line2;
}
} // if
} // FillFromTwoLines
public void WhenTrimIsEnabled_ThenReturnTrimmedValues()
{
var text = CsvHeader + "\n" + Line1WithWhitespace + "\n" + Line2WithWhitespace;
var fileInfo = FileTestBuilder.InFileSystem
.WithFilePath(Path.Combine(WorkingDir, "Test1.csv"))
.WithText(text)
.Build();
var result = Act(fileInfo.FullName, new CsvFileReaderOptions {
EnableTrimValues = true
});
Assert.That(result.First().Values, Is.EquivalentTo(Line1.Split(',')));
Assert.That(result.Second().Values, Is.EquivalentTo(Line2.Split(',')));
}
} // FillDetails
private void FillFromOneLine(CustomerAddressModel filled)
{
filled.HouseNumber = Regex.Match(Line1, "\\d*").Value;
if (!string.IsNullOrWhiteSpace(filled.HouseNumber))
{
var line1 = Line1.Split(' ');
filled.HouseNumber = line1[0];
filled.Address1 = string.Join(" ", line1.Skip(1));
}
else if (Line1.ToUpper().StartsWith("PO BOX"))
{
filled.POBox = Line1;
}
else
{
filled.HouseName = Line1;
}
} // FillFromOneLine
} // FillFromTwoLines
private void FillFromThreeLines(CustomerAddressModel filled)
{
string uLine1 = Line1.ToUpper();
if (uLine1.StartsWith("APARTMENT") || uLine1.StartsWith("FLAT"))
{
filled.FlatOrApartmentNumber = Line1;
filled.HouseNumber = Regex.Match(Line2, "\\d*").Value;
if (!string.IsNullOrWhiteSpace(filled.HouseNumber))
{
string[] line2 = Line2.Split(' ');
filled.HouseNumber = line2[0];
filled.Address1 = string.Join(" ", line2.Skip(1));
filled.Address2 = Line3;
}
else
{
filled.HouseNumber = Regex.Match(Line3, "\\d*").Value;
if (!string.IsNullOrWhiteSpace(filled.HouseNumber))
{
string[] line3 = Line3.Split(' ');
filled.HouseNumber = line3[0];
filled.Address1 = string.Join(" ", line3.Skip(1));
}
else
{
filled.Address1 = Line3;
}
filled.HouseName = Line2;
} // if
return;
} // if
bool neitherUnitNorBlock =
!uLine1.Contains("UNIT") &&
!uLine1.Contains("BLOCK") &&
Regex.Match(Line1, "^\\d[0-9a-zA-Z ]*$").Success;
if (neitherUnitNorBlock)
{
filled.HouseNumber = Regex.Match(Line1, "\\d*").Value;
if (string.IsNullOrWhiteSpace(filled.HouseNumber))
{
return;
}
var line1 = Line1.Split(' ');
filled.HouseNumber = line1[0];
filled.Address1 = string.Join(" ", line1.Skip(1));
filled.Address2 = Line2;
}
else
{
filled.HouseName = Line1;
filled.Address1 = Line2;
filled.Address2 = Line3;
} // if
} // FillFromThreeLines
