Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export table to text without extra spaces 1
- Thread starter linousa
- Start date
-
1
- #2
Mike Lewis
Programmer
Yes. Do this:
If you only want one field to be copied, add a FIELD clause.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads
Code:
SELECT MyDBF
COPY TO MyText DELIMITED WITH ""If you only want one field to be copied, add a FIELD clause.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads
- Thread starter
- #3
![[thanks]](/data/assets/smilies/thanks.gif "[thanks] [thanks]")
Olaf Doschke
Programmer
I'd use TAB delimited or even simpler CSV to also eliminate all the intermediate spaces.
Ideally, you'd rather have tab positions like the origin of the word "tab" for word pressing was, not as equally spaced out tab lengths for all tabs, but tab positions for 2nd, 3rd, etc column, it's obviously simplest with spaces, as that doesn't require the correct tab length, but you could also have a proprietary own format with tab positions in a header line and then replace tabs with the necessary amount of spaces on the fly in time for display or printing/reporting. That means it's of no use for a normal text editor or straight forward monospace font generic text printing, but it'd not be impossible to create such a text file viewer based on a form with editbox and conversion of the file content to editbox value.
If your goal is small file sizes compression will help, too, of course.
Bye, Olaf.
Olaf Doschke Software Engineering
Ideally, you'd rather have tab positions like the origin of the word "tab" for word pressing was, not as equally spaced out tab lengths for all tabs, but tab positions for 2nd, 3rd, etc column, it's obviously simplest with spaces, as that doesn't require the correct tab length, but you could also have a proprietary own format with tab positions in a header line and then replace tabs with the necessary amount of spaces on the fly in time for display or printing/reporting. That means it's of no use for a normal text editor or straight forward monospace font generic text printing, but it'd not be impossible to create such a text file viewer based on a form with editbox and conversion of the file content to editbox value.
If your goal is small file sizes compression will help, too, of course.
Bye, Olaf.
Olaf Doschke Software Engineering
- Status
Similar threads
- Question
