Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #21442

    Sima
    Participant

    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

    #21444

    Yutaka Emura
    Keymaster

    Hello Sima,

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

    Thanks,

    #21449

    Sima
    Participant

    Thanks!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

Share with friends... Tweet about this on TwitterShare on FacebookShare on Google+Email this to someone