Reading Text Files

[Nimesh2008]

Please can anybody solve this dilemma? It's very urgent.
How to read the following text file and assign col5 as integer and get the values which are less than -500 and more than 500 but not equal to 0 in new text file by vb6.0?
col1|col2|col3|col4|col5|col6|
AXC
doc|100|500|7800|900|chd|no5|
MNC
doc|100|500|6800|200|chd|no6|

Get output in below format

doc|200| or doc,200,

[debasisdas]

get the values which are less than -500 and more less than 500 but not equal to 0

What do you mean by this ?

Post your question clearly.

[cugone]

What version of VB? 6.0, 2003, or 2005?

[QVeen72]

What version of VB? 6.0, 2003, or 2005?

Hi Cugone,

Read the post properly, he has already mentioned VB 6.0


Regards
Veena

[Killer42]

... How to read the following text file and assign col5 as integer and get the values which are less than -500 and more than 500 but not equal to 0 in new text file by vb6.0?

Ok, two things. First, use the Split() function to chop up the text on the "|" delimiters.
Second, your logic is a bit fuzzy there. A number which is less than -500 or more than 500 cannot possibly equal zero.

So the code will be quite simple:

• Open the file for reading
• Read each line
• Use Split() to chop it into an array
• Check the fifth entry (number 4, since they start at 0) in the array
• If < -500 or > 500 then write it to new file.
• End of loop.