HI @varunk
Try this out… I think it will solve your problem to remove the last character…
- Use a Read Range activity to read the excel onto a data table
- Use a For Each Row activity to loop through the data table to get the values of each row of a particular column
- Within the loop, apply the logic given in the xaml shared
you can use an assign activity
Remove(str.Length - 1)
row(“ColumnName”) = Remove(row(“ColumnName”).ToString.Length - 1)
Hope it helps!!
If this works for you, please mark the answer as the solution so that it could help others as well