Set the default field delimiter in AccuZIP6

Exporting expressions and information including exporting data in presort order or import order, and importing information, along with error messages that may apply to this category.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1910
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Set the default field delimiter in AccuZIP6

Post by Eric » Fri Oct 02, 2009 11:14 am

With AccuZIP6 version 5.04.06 (released October 2, 2009) or greater, we've added a new feature which allows you to set the default Delimiter that AccuZIP6 5.0 will use to Import data. So if your database is a pipe delimited file but AccuZIP6 believes it's a fixed length or comma delimited text file, you now have the ability to override AccuZIP6's choice:

1. Download the fieldmaps.zip file and extract it into the C:\Program Files\AccuZIP6 5.0\Field Maps\ folder.

2. The software will look at this file and the DELIMITER= setting to determine what character is used as the Delimiter for each field.

3. If the software sees a value for DELIMITER, it will not check for any other delimiter.

4. You can enter the delimiter as a value or as a reference, i.e., DELIMITER=| or the CHR equivalent, DELIMITER=CHR(124)
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply