Reading text files

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

Joe
--