Export output file as pipe delimited with headers

All things related to the Script feature of AccuZIP6, including the Script Monitor.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1909
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Export output file as pipe delimited with headers

Post by Eric » Mon Mar 02, 2009 10:57 am

Code: Select all

* Copy all input files and related files to Archive Folder
SET SAFETY OFF
com_Csv=ADDBS(com_ArchiveFolder)+FORCEEXT(JUSTFNAME(com_InputFilePath),"csv")
com_Hdr=FORCEEXT(com_Csv,"hdr")
COPY TO (com_Hdr) TYPE CSV FOR .F.
COPY TO (com_Csv) TYPE DELIMITED WITH "" WITH CHARACTER |
com_FileString1=FILETOSTR(com_Hdr)
com_FileString2=FILETOSTR(com_Csv)
=STRTOFILE(STRTRAN(com_FileString1,[,],[|]),com_Csv)
=STRTOFILE(com_FileString2,com_Csv,1)
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply