Adding additional value to existing ones

[Zac_Soh (Zac)]

I have a data table with values ranging from 1 to n. How do i add “M” in front of each value and also a zero for the single digits so it appears like

M01
M02
...
M10
M11
...
Mn

The number of rows is not fixed and there is a second column of data, if that is a concern to take note of.

[lakshman (Ganta lakshman)]

@Zac_Soh

1. use Read Range activity to read the data from Excel file and will give you output as DataTable and say ‘inputDT’.

2. And then use ForEach Row activity to iterate that DataTable.

       ForEach row in inputDT
          If row("ColumnName").Tostring.Trim.Length = 1
           Then row("ColumnName") = "M0"+
            row("ColumnName").Tostring
            Else row("ColumnName") = "M"+
            row("ColumnName").Tostring
   

3. Finally use Write Range activity to write into Excel file.

[Bhavik_Solanki]

@Zac_Soh, You may find following thread helpful.

How to Update multiple rows in datatable

Hi, I need to update multiple rows in DataTable… I need to change the particular column value in all rows of the output comes from the Datatable.select query… I am try with below statement. But its giving Error Datatable.Select(“Name=‘Hemanth’”).ToList().ForEach(r =>r(“EmpId”)=“test”) Anyone give suggestion for that problem… Regards,

[Zac_Soh (Zac)]

@lakshman
Thanks! That solved my problem perfectly