This is a migrated thread and some comments may be shown as answers.

Csv separator

2 Answers 138 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

Igor asked on 15 Dec 2010, 03:57 PM

Hi. I have next code

var table=Csv.GetDataSet("C:\\Documents and Settings\\Administrator\\Desktop\\SFT\\Data\\Units.csv").Tables[0];

var tableRow=table.Rows[0][1];

table.Rows[0][1]= scuId;

Csv.SaveTable(table,"C:\\Documents and Settings\\Administrator\\Desktop\\SFT\\Data\\Units.csv");

I launch test and it fails because of values is separated by comma.

Failure Information:

~~~~~~~~~~~~~~~

Exception thrown executing coded step: '[UnitGroupCreation_CodedStep2] : Write group name in file'.

InnerException:

System.IndexOutOfRangeException: Cannot find column 1.

at System.Data.DataColumnCollection.get_Item(Int32 index)

at System.Data.DataRow.set_Item(Int32 columnIndex, Object value)

at SFT.UnitGroupCreation.UnitGroupCreation_CodedStep2() in c:\Documents and Settings\Administrator\Desktop\SFT\UnitGroupCreation.aii.cs:line 75

If I modify Units.csv manually and change separator from ',' to ';' the test will be passed successfully.

The problem is not resolved if I change list separator in the regional configurations in my system. Could anybody help?

Csv separator

2 Answers, 1 is accepted