Support 805.461.7300
Sales
Our Technology. Your Success.

Export out of AccuZIP6 as Pipe delimited text

Description

This command allows you to export your AccuZIP6 Database file as a pipe delimited (|) text file. The text file will only have | characters in between each field; no commas will separate the fields. By default, the command will export your data to C:\pipe.txt. Change the path in all three instances of the path being mentioned in the command if you plan on giving the file a different name or if you plan on saving the file to a different location.

The Command

SET SAFETY OFF
PUBLIC comString
COPY TO C:\PIPE.TXT DELIMITED WITH CHARACTER |
comString=FILETOSTR("c:\pipe.txt")
comString=STRTRAN(comString,'"','')
=STRTOFILE(comString,"C:\PIPE.TXT")

In the Save As box of the Command window, give the command a name, such as Export as Pipe Delimited Text.

Click Run to create the export file.

« Back to Commands

AccuZIP's customer service is great. It keeps us from having down time and I'm always able to get a quick answer. don't have to worry about the size of the order I'm working with a client on. Most times, AccuZIP employees know more than the USPS employees. I've been able to navigate the lack of government employee training, which saves time, money and headaches.
M.L., Lansing, WV