[Sima]

Hello,

how can I fully delete a row from a CSV file?

For instance, I have a CSV file with a total of three rows (shown below).
2015/9/21, 3, 5
2015/9/22, 2, 10
2015/9/23, 4, 9

When I deleted the first row commas still remain in it. And the CSV file still acknowledges the remaining two rows as row 2 and 3 (instead of acknowledging the remaining two rows as row 1 and row 2). As shown below (notice the commas)

,,
2015/9/22, 2, 10
2015/9/23, 4, 9

How can I get the mentioned commas not to show up and have the CSV file acknowledge the remains two rows as rows 1 and 2 (rather then still acknowledging them are rows 2 and 3)?

Thanks

[Yutaka Emura]

Hello Sima,

The “Cut” command (instead of “Delete”) can delete the full row.

Thanks,

[Sima]

Thanks!

[Author]

Posts