StaffThe text driver is scanning the rows and determining that that column contains numbers and is reading them as numbers. You could try prefacing all entries with an alphabetic character (ie, "x10.10.10.10") and then strip off the 'x' later). Or you could try setting up a Schema.ini file in the same directory to specify the column as text:
[testing.csv]
Col1=test Text
See Using CSV Files as Data Storages for more info.
Think Joseph has cleared this up then. (Thanks Joseph)
It's down to how the TC driver is interpreting it. Sorted.
Thanks Joseph, Solution provided by you was already identified and mentioned in my first comment.
Do let me know if i add Schema.ini with that fix without modifying?? If yes, do let me know how to create Schema.ini and use it.
I would like to get the solution which doesnot involve any modification in the csv file since its autogenerated and will be using those csv as the intermediate input.
Regards
Vijay Bhaskar U
StaffUsing Schema.ini worked for me but, of course, you should simply test it out for yourself. Put the Schema.ini file in the same directory as the csv file. Use any text editor to create it, or create it on the fly, as long as it is there when you go to open the csv file.
