Advanced Search

Question: readdata and columns

Question:readdata and columns

Christopher2222 5785 Maple
readdata
March 08 2017
0

What's the best way to read data from a text file where say there are 3 columns separated by say 5 spaces.  However the first column is a column of names, just as a simple example

green beans     50     12
potatoes     20     15
red peppers     10  10
tomatoes     5     5

readdata takes each space as a column separator.

readdata("c:/test.txt",string,3)
                                     

How do I work it so that I keep the name identifiers in one column?

 

***
Using ImportMatrix I keep getting error
ImportMatrix("c:/beantest.txt",delimiter="     ")
                              Error, (in ImportMatrix) cannot interpret file
 
Please Wait...