<div>
Read through the file one character at a time looking for the tab character.<br />
<br />
dim sChar as string<br />
dim sField as string<br />
<br />
Do While Not EOF(&lt;filenumber&gt;)<br />
&nbsp; &nbsp;<br />
&nbsp; &nbsp;sField = &quot;&quot;<br />
&nbsp; &nbsp;sChar = Input(1,&lt;filenumber&gt;)<br />
<br />
&nbsp; &nbsp;Do While sChar &lt;&gt;&nbsp;chr(9) &nbsp; ' 9 = tab<br />
&nbsp; &nbsp; &nbsp; sField = sField &amp;&nbsp;sChar <br />
&nbsp; &nbsp; &nbsp; sChar = Input(1,&lt;filenumber&gt;)<br />
&nbsp; &nbsp;Loop<br />
&nbsp; &nbsp;<br />
&nbsp; &nbsp;' Do Something with sField (ie set variable etc)<br />
&nbsp; &nbsp;<br />
Loop<br />

</div>


Read through the file one character at a time looking for the tab character.

dim sChar as string
dim sField as string

Do While Not EOF(<filenumber>)
   
   sField = ""
   sChar = Input(1,<filenumber>)

   Do While sChar <> chr(9)   ' 9 = tab
      sField = sField & sChar
      sChar = Input(1,<filenumber>)
   Loop
   
   ' Do Something with sField (ie set variable etc)
   
Loop


<div>
It worked great! Thanks for your valuable help.<br />
<br />
Regards<br />
mmahdi<br />

</div>


It worked great! Thanks for your valuable help.

Regards
mmahdi


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am trying to extract information from a tab delimited text file. For example the info are are organised in the following;<br />
<br />
field1 &lt;tab&gt; field2 &lt;tab&gt; field3 &lt;tab&gt; field4<br />
&lt;blank&gt;&lt;tab&gt; field2 &lt;tab&gt;&lt;blank&gt; &lt;tab&gt; field4<br />
<br />
I can programmatically open the file in excel which is going to organise the fields in columns but I am trying to avoid that. So I am looking for a way to extract field1, field2, field3 and field4.<br />
<br />
Anyone can help?<br />
<br />
Regards<br />
MMAHDI
</div>
</div>


Hi,

I am trying to extract information from a tab delimited text file. For example the info are are organised in the following;

field1 <tab> field2 <tab> field3 <tab> field4
<blank><tab> field2 <tab><blank> <tab> field4

I can programmatically open the file in excel which is going to organise the fields in columns but I am trying to avoid that. So I am looking for a way to extract field1, field2, field3 and field4.

Anyone can help?

Regards
MMAHDI

Extracting fields from a tab delimited text file in VB5

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.