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

I appreciate [AccuZIP support technician] Geoff! He has over and over with a positive attitude given us exceptional support. He is a key asset to us and we are so thankful for him. I just wanted to let you all know that he has so much patience and knowledge. I am sure you know but he is a KEEPER for your company.
K.P., Colorado Springs, CO