Createing a comma delimited file from a universe database using pick

#11

I wrote a basic that is cataloged under 'EXPORT'. You simply
substitute EXPORT for LIST or SORT. It lays out a flat file in &HOLD&
that contains comments and quotes. It 'doctors' the sentence to be one
long page. Then you upload to your spreadsheet of choice. Its a
blast. Free to a good home.

john reid
On Mon, 14 Jul 2003 23:27:38 +0200, "DennisQ" <dqb|@|zsd.co.za> wrote:

Quote:

Createing a comma delimited file from a universe database using pick.

A way I use with great effectiveness (sp?) is to create a dictionary item
called comma
1> A
2> 0
3
4
5
6
7
8> F;","
9> L
10> 1

then I set the printer to record to the &HOLD& file (this system file is a
Type 1 file, meaning that it is a directory at o/s level). I can't think of
the exact syntax, but something like this...

SETPTR 0,132,5000,BANNER MY_CSV.TXT

(the 5000 stops the thing from asking for Next Page - literally sets page
length to 5000 lines)

Finally I list the file I require, inserting a COMMA between each field. Of
course this doesn't add in the double quotes...

LIST SALES SALESMAN COMMA SGRP COMMA SALES TARGET COMMA RANKING (P

with the setptr above this creates a file in &HOLD&. To get at the file (on
Windows & nix) just navigate to that directory

#12

Re: I wrote a basic that is cataloged under 'EXPORT'. Free to a good
home.
Why don't you post it too PickSource.com?

#13

please send a copy of it to mrparkland (AT) yahoo (DOT) com
"Claude" <leavego (AT) once (DOT) com> wrote

Quote:

Re: I wrote a basic that is cataloged under 'EXPORT'. Free to a good
home.
Why don't you post it too PickSource.com?

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.399 / Virus Database: 226 - Release Date: 10/9/02

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Createing a comma delimited file from a universe database using pick

comp.databases.pick comp.databases.pick

Re: Createing a comma delimited file from a universe database using pick - 10-09-2003 , 09:27 PM

Re: Createing a comma delimited file from a universe database using pick - 10-11-2003 , 03:10 AM

Re: Createing a comma delimited file from a universe database using pick - 10-11-2003 , 09:25 AM