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!

*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.

Jobs

APPEND FROM delimited file

APPEND FROM delimited file

(OP)
At the dot-prompt of dBase 3plus, I am trying to append from a txt file containing fields delimited by '|'.  The command>   append from <txt filename> type sdf delimited with '|'    does not work.  It appends but leaves the pipes in the data.  Leaving the "type sdf" out gives same results.  My empty dbf is defined with fields that match the delimited txtfile data.  I know I've done this before with comma-delimited files, etc, but...    I'd appreciate any suggestions.  Thanks!

RE: APPEND FROM delimited file

Hello,

I *think* you have to use either a literal or a character string in parenthesis:

CODE

append from myfile.txt delimited with character |

Should probably work

Regards

Griff
Keep ing

RE: APPEND FROM delimited file

(OP)
Thanks very much, Griff and Jock.   I'm still fighting my problem.  My source file is in Excel 2003 format.  I did a save-as, creating files in different formats (CSV, text, text tab-delimited, DBF) then tried append-from, trying both the dBase3 dot-prompt and a small Clipper program.  No luck yet.  I tried the function, Jock, but it uses some functions that aren't known to my Clipper S87 version.  What bugs me is that a few days ago, I was able to take another Excel file and append it into a DBF but I aobviously can't remember the steps I used to to it.  Argh!

RE: APPEND FROM delimited file

Hi, Encinoman

Well, if the source is Excel, wgat to do is file/save as and choose type CSV (comma delimited). That is compatible with the simple "append from filename delimited"  command in clipper S'87 version.

The biggest problem is if the Excel sheet has multi-line text cells, because those will have embedded CR's, which will mess up the import, but if you format the column in Excel to eliminate that first it should work.

However any currency fields will have $'s & will have to be imported into text fields and converted later and any dates will come in as YYYYMMDD (dtos format).

Jock

RE: APPEND FROM delimited file

Jock,

You should get a royalty on this issue,  over & over again.

Jim C.

RE: APPEND FROM delimited file

(OP)
Jock, Griff,  it worked!  Thanks very much!
Bill

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!

Resources

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