TextDataReaderSettings question

[Sundaram Sridharan]

I need to read in a CSV/TXT file and change data types using ironpython. The TextReaderSettings class has one method called SetDataType and looks like

readersettings.SetDataType(0,DataType.Integer)

let's say I have 5 columns and I made guesses as to what the data types are (by reading a few rows) - I have put the data types in a list:

list = ["Integer","String","Real",....]

is there a way to set up a loop to assign data types using this list if I try something like

dType = "DataType."+list[0]

and then try

readersettings.SetDataType(0,dType)

it gives me error as it expects a data type as second argument whereas I am giving it a string.

How do I implement this

are there other ways of forcing spotfire to guess data types automatically through IronPython

[Sundaram Sridharan]

I am answering my own question - I added the readersettings statement right inside the loop where I figure out data typs of different columns