Tagged: 

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

    David
    Participant

    Hello, I have two questions regarding CSV mode. Wish to get help. Thanks in advance!
    1. How to filter “null” cells by Filter toolbar?
    For example, I have a CSV file which includes 10-row and 13 columns. In column 4, there are some empty cells which have no contents . I want to use filter function to leave these rows and delete them.But I don’t know what filter rules I should type.

    2.How to select multiple cells?
    I want to select some discontinuous cells. But when I press [Ctrl] key and click cells, it doesn’t work. How should I do?

    #22630

    Yutaka Emura
    Keymaster

    Hello,

    1. How about using a regular expression . (period) with the negative option if necessary and specify a column in the Column drop-down list?

    2. Currently, you can’t select discontinuous cells.

    #22646

    David
    Participant

    Problem 1 has been solved. Use . (period) in regular expression mode and active “negative” function. It works very well, thanks!
    Problem 2, wish to see it in future version.

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