New Homeowners Mailing List – Text Format

Text Format, also known as “Fixed Width Format”, is an alternative to the Comma Separated Value Format. While both formats use simple characters (text, ASCII), which means it can be opened by any text editor (like notepad on PC), they differ in that Fixed Width forces each line (record) be of same length, further more, each field (value) is conformed to a pre-determined length.
For example – John Q who lives in 123 main st. in FL would show as such in a CSV file: “John Q”,”123 main st.”,”FL” it may look like this in a text file:
John Q 123 main st. FL
(and we say “may” b/c the amount of free space you see between values, is subject to the specification of that file – it is usually derived from the maximum length one expects for each possible value.

Here’s what a text value looks like across multiple lines – you can see how the “fixed width” aspect of each field leads to a “nicely streamlined” and “organized” visual…

Data File Screenshot
(personal data has been partially covered)

…but it’s not the visual we aim for in this format, it is computer parsing. This format is a favorite of big data mills (like the ones you see in big credit rating agencies who process millions of records every day), as the computers only need to “count steps” (or characters) to know where each field (value) begins and ends, there are no confusions.
All this to say: if you are going to process your own list – you probably do NOT want to pick this format, as it involves programming and is not label-print friendly.

Fields available in our New Homeowners Text List Format

  • Field01 – Full Name
  • Field02 – Address
  • Field03 – City,State,Zip+4
  • Field04 – County Code
  • Field05 – Salutation
  • Field06 – First Name
  • Field07 – Middle Name
  • Field08 – Last Name
  • Field09 – City
  • Field10 – State
  • Field11 – Zip9
  • Field12 – Carrier Route
  • Field13 – Phone
  • Field14 – Purchase Price
  • Field15 – Loan Amount
  • Field16 – Document Number
  • Field17 – Condo Code
  • Field18 – Record Date
  • Field19 – Filler
  • Field20 – Lender Name
  • Field21 – Loan Type
  • Field22 – LTV
  • Field23 – Seller Name
  • Field24 – Buyer Status
  • Field25 – Sales Area
  • Field26 – Zip
  • Field27 – Zip+4
  • Field28 – Or Current Resident
  • Field29 – Keycode

The fields in bold font are not standard and will be provided only if you request them in your delivery (customization).