How do I import Tab delimited text files?

[Judy]

Can anyone tell me how to code a program that will import a tab delimited text file?

[Judy]

But sdf needs a fixed length file. The files I'm trying to import have varying field widths so the positions are never fixed..

see "append from sdf" in the OLH
- glenn

Post by Judy
Can anyone tell me how to code a program that will import a tab delimited text file?

[Glenn Johansen]

Sorry, meant append from delimited

- g

Post by Judy
But sdf needs a fixed length file. The files I'm trying to import have
varying field widths so the positions are never fixed..

see "append from sdf" in the OLH
- glenn

Post by Judy
Can anyone tell me how to code a program that will import a tab
delimited
text file?

[Glenn Johansen]

see "append from sdf" in the OLH
- glenn

Post by Judy
Can anyone tell me how to code a program that will import a tab delimited text file?

[Mervyn Bick]

Post by Judy
Can anyone tell me how to code a program that will import a tab delimited text file?

It is, strictly speaking, a tab separated file and dBase cannot handle
anything other than comma separated files without a little help.

If you are using dBase Plus, have a look at Importdata.wfm in the dUFLP.
Ken Mayer has coded in the ability to handle different separators.

If you haven't got the dUFLP (dBase Users Function Library) yet, you can
get it from http://www.goldenstag.net/dbase/ where you will find it about
three quarters of the way down the page.


Mervyn.

[Ken Mayer [dBVIPS]]

Post by Mervyn Bick

Post by Judy
Can anyone tell me how to code a program that will import a tab delimited text file?

It is, strictly speaking, a tab separated file and dBase cannot handle
anything other than comma separated files without a little help.
If you are using dBase Plus, have a look at Importdata.wfm in the
dUFLP. Ken Mayer has coded in the ability to handle different separators.
If you haven't got the dUFLP (dBase Users Function Library) yet, you can
get it from http://www.goldenstag.net/dbase/ where you will find it
about three quarters of the way down the page.

Or click on the link at the top of the page ... <g>

Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm
http://www.goldenstag.net/dbase

[Mervyn Bick]

On Mon, 24 Nov 2008 07:51:39 +0200, Ken Mayer [dBVIPS]

Post by Ken Mayer [dBVIPS]
Or click on the link at the top of the page ... <g>

Duh!. Of course. But who ever reads the top of the page? <g>


Mervyn.

[Ken Mayer [dBVIPS]]

Post by Mervyn Bick
On Mon, 24 Nov 2008 07:51:39 +0200, Ken Mayer [dBVIPS]

Post by Ken Mayer [dBVIPS]
Or click on the link at the top of the page ... <g>

Duh!. Of course. But who ever reads the top of the page? <g>

Ah, the life of a webdesigner. <g>

Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm
http://www.goldenstag.net/dbase

[Judy]

Hi, I downloaded your program but I get this error message when I try to run it:

"error opening file C:\....:redlight.gif"
"File does not exist :dUFLP:BDeAlias.cc"
"File does not exist :dUFLP:StringEX.cc"

All the files are in the same folder that the import program is running from.

What am I doing wrong?

[Mervyn Bick]

Post by Judy
"error opening file C:\....:redlight.gif"
"File does not exist :dUFLP:BDeAlias.cc"
"File does not exist :dUFLP:StringEX.cc"
All the files are in the same folder that the import program is running from.
What am I doing wrong?

Try running setup.prg in the dUFLP. This sets up the source aliases (the
:dUFLP: part of the file name.)

Mervyn.

[Ken Mayer [dBVIPS]]

Post by Judy
"error opening file C:\....:redlight.gif"
"File does not exist :dUFLP:BDeAlias.cc"
"File does not exist :dUFLP:StringEX.cc"
All the files are in the same folder that the import program is running from.
What am I doing wrong?

As noted, you must install the dUFLP properly. Read the "readme.txt"
file, or "Whats.new" ... or even the section of the website that you
downloaded it from ...

Ken Mayer
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm
http://www.goldenstag.net/dbase

[Geoff Wass [dBVIPS]]

Post by Judy
Can anyone tell me how to code a program that will import a tab delimited text file?

Judy,

Which version of dBASE are you using? There is code in the dUFLP for
importing such files. It is called importData.wfm. You can get the dUFLP
from Ken Mayer's site at:

http://www.goldenstag.net/dbase/

[Greg Hill]

Post by Judy
Can anyone tell me how to code a program that will import a tab delimited text file?

There are some custom classes for that in the Binaries group.

From: "Roland Wingerter" <***@daheim.de>
Subject: Sample text files for rwAppend.prg
Date: Fri, 22 Feb 2008 11:04:13 +0100

Hope this helps.

Greg Hill