×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Export table to text without extra spaces

Export table to text without extra spaces

Export table to text without extra spaces

(OP)
Is it possible to export DBF without extra spaces that fill up to field length? Trying to get CRLF characters right after my data:



and not(used- copy to "name" sdf):


RE: Export table to text without extra spaces

Yes. Do this:

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

RE: Export table to text without extra spaces

(OP)
I can't believe how easy it was. thanks

RE: Export table to text without extra spaces

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
https://www.doschke.name

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close