Export Database as Pipe Delimited Text File
This technote uses the Command feature. Find this feature in AccuZIP6 by pulling down the Edit menu to Command
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.
