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 just had to tell you how I LOVE the new upgrade.   Man, you talk about making the search and replace task easier!   It's so easy!...Kudos to you guys for making a great product even better.   I'm definitely sold!
P.C., Auburn, AL