public void isZipCode()
{
Assert.False(ZipCodeUtil.isZipCode(null));
Assert.False(ZipCodeUtil.isZipCode(""));
Assert.False(ZipCodeUtil.isZipCode(" "));
Assert.False(ZipCodeUtil.isZipCode("a30068 "));
Assert.True(ZipCodeUtil.isZipCode("30068"));
Assert.True(ZipCodeUtil.isZipCode("30068-"));
Assert.True(ZipCodeUtil.isZipCode("30068-1234"));
Assert.True(ZipCodeUtil.isZipCode("300681234"));
Assert.True(ZipCodeUtil.isZipCode(" 30068 "));
Assert.True(ZipCodeUtil.isZipCode(" 30068- "));
Assert.True(ZipCodeUtil.isZipCode(" 30068 - 1234 "));
Assert.True(ZipCodeUtil.isZipCode("30068 1234"));
}
public void parseZipCodeZeroPad()
{
Assert.Equal("00300", ZipCodeUtil.parseZipCode("300", zeroPad: true));
Assert.Equal("03006", ZipCodeUtil.parseZipCode("3006", zeroPad: true));
Assert.Null(ZipCodeUtil.parseZipCode("30068-123", zeroPad: true));
Assert.Null(ZipCodeUtil.parseZipCode("30068-12345", zeroPad: true));
Assert.Equal("030061234", ZipCodeUtil.parseZipCode("3006-1234", zeroPad: true));
Assert.Equal("003001234", ZipCodeUtil.parseZipCode("300-1234", zeroPad: true));
Assert.Equal("03006", ZipCodeUtil.parseZipCode("3006", zeroPad: true));
Assert.Equal("00300", ZipCodeUtil.parseZipCode(" 300 ", zeroPad: true));
Assert.Equal("03008", ZipCodeUtil.parseZipCode(" 3 0 0 8- ", zeroPad: true));
Assert.Equal("030061234", ZipCodeUtil.parseZipCode(" 30061234", zeroPad: true));
Assert.Equal("003001234", ZipCodeUtil.parseZipCode(" 300-1234", zeroPad: true));
Assert.Equal("003001234", ZipCodeUtil.parseZipCode(" 300 - 1234", zeroPad: true));
}
public void parseZipCode()
{
Assert.Null(ZipCodeUtil.parseZipCode(null));
Assert.Null(ZipCodeUtil.parseZipCode(""));
Assert.Null(ZipCodeUtil.parseZipCode(" "));
Assert.Null(ZipCodeUtil.parseZipCode("a30068 "));
Assert.Null(ZipCodeUtil.parseZipCode("3006"));
Assert.Null(ZipCodeUtil.parseZipCode("30068-123"));
Assert.Null(ZipCodeUtil.parseZipCode("30068-12345"));
Assert.Equal("30068", ZipCodeUtil.parseZipCode("30068"));
Assert.Equal("30068", ZipCodeUtil.parseZipCode(" 30068 "));
Assert.Equal("30068", ZipCodeUtil.parseZipCode(" 3 0 0 6 8- "));
Assert.Equal("300681234", ZipCodeUtil.parseZipCode(" 300681234"));
Assert.Equal("300681234", ZipCodeUtil.parseZipCode(" 30068-1234"));
Assert.Equal("300681234", ZipCodeUtil.parseZipCode(" 30068 - 1234"));
}
public static int main()
{
using (Pnyx p = new Pnyx())
{
p.setSettings(outputNewline: StreamInformation.newlineString(NewLineEnum.Unix));
p.read(@"c:/dev/asclepius/prod_import/American Academy of Private Physicians.csv");
p.parseCsv(hasHeader: true);
p.hasColumns(true, 2);
p.withColumns(p2 => { p2.lineTransformerFunc(line => line == "" ? "-66" : line); }, 1, 2, 3, 4, 5);
p.rowTransformerFunc(row =>
{
row[3] = TextUtil.extractAlpha(row[3]); // removes periods from title
return(row);
});
p.rowTransformerFunc(row =>
{
row[7] = ZipCodeUtil.parseZipCode(row[7], true);
return(row);
});
p.rowTransformerFunc(row =>
{
row[8] = PhoneUtil.parsePhone(row[8]);
return(row);
});
p.rowTransformerFunc(row =>
{
row[9] = EmailUtil.validateAndRepair(row[9]);
return(row);
});
p.rowTransformerFunc(row =>
{
String firstName = row[1];
String lastName = row[2];
firstName = firstName.Replace(",", " ");
lastName = lastName.Replace(",", " ");
String wholeName = firstName + " " + lastName;
Name name = NameUtil.parseFullName(wholeName);
row[1] = name.firstName;
row[2] = name.lastName;
row = RowUtil.insertColumns(row, 4, name.suffix);
row = RowUtil.insertColumns(row, 3, name.middleName);
return(row);
});
p.widthColumns(13);
p.headerNames("Credentials", "FirstName", "MiddleName", "LastName", "Suffix", "Title", "StreetAddress", "City", "State", "ZipCode", "Phone", "Email", "CompanyName");
p.write(@"c:/dev/asclepius/prod_import/aapp.csv");
}
using (Pnyx p = new Pnyx())
{
p.read(@"c:/dev/asclepius/prod_import/aapp.csv");
p.parseCsv();
p.columnDefinition(hasHeaderRow: true, maxWidth: true, nullable: true);
p.swapColumnsAndRows();
p.writeStdout();
}
return(0);
}
