how to write the cursor's data in a txt file? visual fox pro

Question

well i have a cursor for example

select col1, col2, col3, col4, colN from cursor into into array thecursor

my current cursor is the cursor

i have got all its data information including null, null information

how can i a txt as it:

col1, col2, col3, col4, colN 
a,b,c,d,e
1,2,3,4,5
a1,b1,,d1,e1
11,12,13,14,
,bb,cc,dd,ee

so you could see at rows a1,b1,,d1,e1 i have a null value between b1 and d1 so you could see i have a null value at row

`11,12,13,14,`(here null value)

and i have a null value at last row

(here null value), cc,dd,ee

so i want this finally txt file

col1, col2, col3, col4, colN 
a,b,c,d,e
1,2,3,4,5
a1,b1,,d1,e1
11,12,13,14,
,bb,cc,dd,ee


**I need this was dynamic i refer it receive a cursor and do it with any cursor

Ganapathy · Accepted Answer · 2012-07-26T12:41:01.650

3

You can directly move the data into a text file instead of cursor as below:

select col1, col2, col3, col4, colN from table to file test.txt

edited Jul 26 '12 at 12:41

answered Jul 24 '12 at 15:55

Ganapathy

174
1
3
11

score 2 · Answer 2 · edited Jul 21 '12 at 17:39

2

Have you looked at the COPY TO command? Try:

COPY TO <filename> TYPE DELIMITED WITH ""

edited Jul 21 '12 at 17:39

Chris Vesper

646
7
18

answered Jul 20 '12 at 20:35

Tamar E. Granor

3,817
1
21
29

You need to insert the filename between COPY TO and TYPE DELIMITED. Tamar tried to put there, but markdown ate it. – Chris Vesper Jul 21 '12 at 17:31
Thanks. Didn't even think of that. – Tamar E. Granor Jul 23 '12 at 20:42

how to write the cursor's data in a txt file? visual fox pro

2 Answers2