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); }