topic Re: Reading text files in VBA Forum

Reading text files

Anonymous — Sun, 23 Mar 2003 15:06:08 GMT

Hi,
I am new to VBA, can someone point me in the right direction. I want to read in a text file and create a schedule. Is it better to read the file into a record or read each line and get each word out of each line.
Is there a function like split that will read a text line and return each word to EOL

Any help would be great.
Thanks Chris

Re: Reading text files

Anonymous — Sun, 23 Mar 2003 17:57:15 GMT

Chris,

I'm not sure what you mean by a 'schedule' so my answers will be generic.

You can read either by line or field or character(s). You can only read by field if the line is comma-delimited. I've been using VB for years so tend to use what I know which is Open / Input # / Line Input #, however there is a more modern method using TextStream / Read / ReadLine / ReadAll.

Which method you choose depends on what you want to do with the information. If you need to process 'words' then you can indeed use the native Split function. If the contents of each word is irrelevant then I would use one of the 'chunkier' methods.

You'll find all these methods in the VBA Online Help.

Regards

Wayne Ivory

IT Analyst Programmer

Wespine Industries Pty Ltd

Re: Reading text files

Anonymous — Mon, 24 Mar 2003 04:44:44 GMT

href="http://www.afralisp.com/vba/extext.htm">http://www.afralisp.com/vba/extext.htm

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"chrisbristol" <
href="mailto:chris.bristol@kvaerner.com">chris.bristol@kvaerner.com>
wrote in message
href="news:f151435.-1@WebX.maYIadrTaRb">news:f151435.-1@WebX.maYIadrTaRb...
Hi,

I am new to VBA, can someone point me in the right direction. I want to
read in a text file and create a schedule. Is it better to read the file into
a record or read each line and get each word out of each line.
Is there a
function like split that will read a text line and return each word to EOL

Any help would be great.
Thanks Chris

Re:

Anonymous — Tue, 25 Mar 2003 12:38:00 GMT

Is the split funtion available in all versions of VBA?

Tom Craft

wivory wrote:

> Chris,
>
> I'm not sure what you mean by a 'schedule' so my answers will be
> generic.
>
> You can read either by line or field or character(s). You can only
> read by field if the line is comma-delimited. I've been using VB for
> years so tend to use what I know which is Open / Input # / Line Input
> #, however there is a more modern method using TextStream / Read /
> ReadLine / ReadAll.
>
> Which method you choose depends on what you want to do with the
> information. If you need to process 'words' then you can indeed use
> the native Split function. If the contents of each word is irrelevant
> then I would use one of the 'chunkier' methods.
>
> You'll find all these methods in the VBA Online Help.
>
> Regards
>
> Wayne Ivory
> IT Analyst Programmer
> Wespine Industries Pty Ltd

Re:

Anonymous — Tue, 25 Mar 2003 16:56:17 GMT

No, Split is only a version 6 function. However you can find a user-defined equivalent at this excellent site:



http://www.vb2themax.com/Item.asp?PageID=CodeBank&ID=194

Regards

Wayne

Re:

Anonymous — Wed, 26 Mar 2003 06:36:53 GMT



Input #File, TextLineCol1, TextLineCol2, TextLineColn ...

Joe
--