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’m influenced and impressed by the AccuZIP support personnel you have. We had setup issues on Friday and I was jamming things through my mail department and wanted to be able to use AccuTrace THAT DAY. It was important for my client. As a result I phoned support and spoke to a wonderfully pleasant woman who was extremely knowledgeable, polite and helpful. Donna whom I believe lived in Georgia was the representative. She is a treasure.
T.R., San Luis Obispo, CA