CSV from Progress 6
- Thread starter SPYO_O
- Start date
TomBascom
Curmudgeon
Upgrade to version 10 and then (assuming that you want to extract the whole "customer" table) write something like this:
V6 is, of course, so far beyond "ancient, obsolete and unsupported" that it boggles the mind. It is so long ago that I don't really recall for sure but the delimiter option to EXPORT may not have been available in v6. If not then the default delimiter is a space.
Code:
output to "customer.csv".
for each customer no-lock:
export delimiter "," customer.
end.
output close.V6 is, of course, so far beyond "ancient, obsolete and unsupported" that it boggles the mind. It is so long ago that I don't really recall for sure but the delimiter option to EXPORT may not have been available in v6. If not then the default delimiter is a space.
Ah good old V6 the first version of progress I ever learned (almost 18 years ago 
)
Im not sure if the delimiter keyword was available back then either but the simple fail safe way would be:
output to "filename.csv".
for each <tablename> no-lock:
put unformatted <field1> "," <field2> "," <field3> ..... etc skip.
end.
output close.
Of course you could run into problems if any of the fields contain commas and Im unsure as to whether the REPLACE function existed back then either.
)Im not sure if the delimiter keyword was available back then either but the simple fail safe way would be:
output to "filename.csv".
for each <tablename> no-lock:
put unformatted <field1> "," <field2> "," <field3> ..... etc skip.
end.
output close.
Of course you could run into problems if any of the fields contain commas and Im unsure as to whether the REPLACE function existed back then either.