Csv to Table

Community Support
1

Wondering if someone can help me out.  Cant figure this out I have a csv with just symbol names.

AAPLXOMMST...

and I trying to load it as a table but keep getting a type error and not sure why.  I am loading via

table: ("S";enlist ",") 0:c:/symbols.csv`

When I read0 the file I get

("AAPL";"XOM";"MSFT";....

Any ideas?

2

Roni I have no idea why you get the error BUT if you 

want to use 0: to read it in this works..

file.csv

sym

AAOK

XOM

MSN

t:("S "; enlist “,”) 0:  `:file.csv

For some reason you need a space "S ".

I added a sym column name 

3

> table: (“S”;enlist “,”) 0:`c:/symbols.csv

?First arg needs to be list

table: (enlist “S”;enlist “,”) 0:`c:/symbols.csv

or equivalently

table: ((),“S”;enlist “,”) 0:`c:/symbols.csv