Visual Basic Forum for Visual Basic Programmers VB

[kic3r]

Is there an API function that atuomatically determines if a text file is delimited or not

[P.T.A.M.]

What is a delimited text file?
_________________
No one is completely useless. They can at least be an example of what to avoid.

[kic3r]

it's used mainly for importing/linking text files for database or excel files. a delimited text file is a text file wherein the data or fields is separated from each other by a common character which is called the delimiting character. the other type is the fixed-width wherein the fields are arranged in exaclty the same width just like what you would see in a typical table. there is a text import wizard in access and excel. just try and import an external data and search for a text file and you'll see what I mean...

[DoobieKeebler]

In short, no, but then, really, is this reply, well, comma delimited, or isn't it? To the best of my knowledge you just have to import and hope for the best. You can see if the expected delimiting character is there, or see if the file is evenly divisible by {record size}, but those aren't foolproof. Too many fools out there.
_________________
Always take into account what a user would never ever in a million years do, because someone will.

"In theory, there's no difference between theory and practice. In practice, there is." -- Yogi Berra

[kic3r]

yup, it's comma delimited alright... Too many fools indeed... well, what i did was search for the character in the first line of the text file, if it's there then it is delimited and not if not found...i was really hoping there was an api for this, but thanx anyway...