creating tab delim file

Kenneth Brody kenbrody at bestweb.net
Wed Oct 24 05:56:33 PDT 2007


Quoting Walter Vaughan (Wed, 24 Oct 2007 08:34:02 -0400):

> scooter6 at gmail.com wrote:
>
>> FWIW - I did look at the help in processing for the proper way to create
>> what I wanted but the
>> help for export is pretty limited in that it doesn't tell you much other
>> than how to use a comma as a delimiter -- what if you wanted to use a
>> pipe or some other character (which oddly enough I have gotten requests
>> for from other databases I work with, etc)
>> Thanks again
>
> The pipes AFAIK kinda how the default Oracle way of doing imports
>
> For example to load pipe delimited data into postgreSQL table   
> CUSTOMER2 we run
> \COPY CUSTOMER2 FROM '/appl/fpmerge/cust2.pipe' WITH DELIMITER '|' NULL ''

In which case, you would tell filePro to use a pipe by using a pipe:

     f=|

-- 
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com


More information about the Filepro-list mailing list