I have a Goldmine database. I need to export four fields to a .CSV text file nightly. (Company ID, Company Full Name, Address1, State) Several of the company names and addresses have commas in them, so the fields in the output file need to be tab delimited or pipe "|" delimited (not comma delimited). The export needs to be done nightly without user action. Windows scheduler can be used to run the program on a schedule.
Main requirements: Pull data from a GoldMine database. No user interaction required. Output file is text (ASCII). One line per record. Fields delimited with tab or pipe. No quotes "" separating or surrounding fields. Must be able to scheduled to run nightly automatically, Windows Scheduler OK.