Exporting Data - File Layout The file (normally called prospect.txt) produced by the TARGET data export mechanism is a standard DOS text file; each record is terminated by a carriage return-line feed pair. Each field is enclosed in double quotes and the fields are separated by commas. The fields are also fixed lengths so they may be opened by programs that require that format. Details of the data layout are shown below. Note that byte offsets are relative to zero and do not include the quotes or commas. The first field starts at offset 1 because offset 0 is the opening double quote on that field. Byte offset(s)     Field content     Notes 001-040 Company name 044-083 Address 1 087-126 Address 2 130-153 City 157-158 State/Prov Applies only to D/C 162-171 ZIP/PostCode Applies only to D/C 175-178 Country code Applies only to F - dialing code from US 182-211 Contact name 215-226 Telephone 230-269 Email address 273-312 URL (web address) 316-327 Fax number 331-331 Mail code D=domestic (US), C=Canada, F=other 335-335 Prospect type D=dealer, E=end user 339-378 Country Applies only to C/F 382-385 Area/region Local meaning 389-392 Salesman 396-401 A/R cust code 405-410 A/P vendor code 414-423 Selection codes 427-430 SIC 434-434 Bulk mail OK If Y, bulk mail allowed 438-438 Bulk fax OK If Y, bulk fax allowed 432-432 Bulk email OK If Y, bulk email allowed 434-435 Terminators CR/LF character pair Total record length including terminators is 436 bytes Back