<div>
Hi,<br />
<br />
The UNIX and DOS (and Windows) operating systems differ in the format in which they store text files.<br />
<br />
DOS places both a carriage return character [vbCr or Chr$(13)] &amp;&nbsp;a line feed character [vbLf or Chr$(10)] at the end of each line of a text file, but Unix uses only a line feed character.<br />
<br />
Some DOS applications need to see carriage return characters at the ends of lines, and may treat Unix-format files as giant single lines.<br />
<br />
Some Unix applications won't recognize the carriage returns added by DOS, and will display Ctrl-M characters at the end of each line (shown on-screen as ^M).<br />
<br />
<br />
You do not have to convert UNIX text files to DOS format in order to read them, but you need to ensure that whilst reading the lines with VBA that you then replace all single vbLf characters with vbCrLf.<br />
<br />
BFN,<br />
<br />
fp.<br />

</div>


Hi,

The UNIX and DOS (and Windows) operating systems differ in the format in which they store text files.

DOS places both a carriage return character [vbCr or Chr$(13)] & a line feed character [vbLf or Chr$(10)] at the end of each line of a text file, but Unix uses only a line feed character.

Some DOS applications need to see carriage return characters at the ends of lines, and may treat Unix-format files as giant single lines.

Some Unix applications won't recognize the carriage returns added by DOS, and will display Ctrl-M characters at the end of each line (shown on-screen as ^M).


You do not have to convert UNIX text files to DOS format in order to read them, but you need to ensure that whilst reading the lines with VBA that you then replace all single vbLf characters with vbCrLf.

BFN,

fp.


<div>
<div class="content wysiwyg-content">
I have a huge textfile in Unix format of several megabytes that I want to read line by line. How do I do this in VBA?<br />
Do I have to convert it to DOS/Windows format first? How? 
</div>
</div>


I have a huge textfile in Unix format of several megabytes that I want to read line by line. How do I do this in VBA?
Do I have to convert it to DOS/Windows format first? How? 

VBA: Read textfiles in Unix format

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.