Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting number of columns in CSV/Text file
CSV/My text file has data in it which originates from a spreadsheeet. My
goal is count the number of columns of data which were pulled into the text file. In a simple world I would just count the fields at the top of the text file. But I have no control over the imported data and the first line will not necessarily have the fields. I need to build a loop which loops though the rows in my text file and then performs a field count per row and stores the field count number. Then the Max of all field counts per row = number of columns in original data. How do I do this? Thanks EM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting text in two different columns | Excel Worksheet Functions | |||
Help Counting 10 Columns * X Number of Rows | Excel Worksheet Functions | |||
Counting text in two columns | Excel Worksheet Functions | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
syntax error for counting the number of columns end. | Excel Programming |