Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
parse from txt file
hi,
i would like to know if there is a way i can take certin rows from a text file? thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
parse from txt file
I think you will have to provide more details about what you are trying to
do. Rick "geebee" (noSPAMs) wrote in message ... hi, i would like to know if there is a way i can take certin rows from a text file? thanks in advance, geebee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
parse from txt file
What would your criteria be based on in order to decide what rows to take
from the text file? I would say yes it is possible. Give some more info on the data itself as well. Is the text file comma delimited? Will you need the code to set field widths for you. If it is comma delimitted will you need to parse part of a cell, entire rows, just cells, certain columns? It can all be done you just need to be more specific with the question if you want help on how to do it. geebee wrote: hi, i would like to know if there is a way i can take certin rows from a text file? thanks in advance, geebee -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200808/1 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
parse from txt file
You have to write a code that uses the line input command to read an entire
line. Then you can parse the line to see if it meets your criteria. If it does, you can do what you want with it. You would place this code in a loop that ends when an EOF is reached on the file. "geebee" wrote: hi, i would like to know if there is a way i can take certin rows from a text file? thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parse File Location | Excel Worksheet Functions | |||
VBA - Error Using Mid To Parse A Data (.dat) File | Excel Programming | |||
How to parse data in text file | Excel Programming | |||
Parse through a TXT file in reverse order | Excel Programming | |||
Parse Text File | Excel Programming |