How delete empty cells from csv file

Help Studio
, ,
1

Hello,
I want to delete empty cells from(A2 :D2)but No of rows can vary from file to file.
and move the data to left.

image
image817×229 6.58 KB

2
  • Read Range into dt
  • For Each Row in Data Table
    ** If String.IsNullOrEmpty(CurrentRow(0).ToString)
    *** For Each in {0,1,2,3}
    **** Assign CurrentRow(currentItem) = CurrentRow(currentItem + 4).ToString
    **** Assign CurrentRow(currentItem + 4) = “”