Delete multiple columns/rows that repeats in multiple files



  • hello. Suppose I have this column:

    العربية
    Deutsch
    English
    Español
    Magyar
    Polski
    Русский
    Türkçe
    中文

    I try to select this rows (by cursor) and delete (replace all). But only one occurence that I select had been delete.

    How can I delete those rows (columns) that repeats several times in one or more files?



  • Hi Vasile,

    Sorry, but we need some extra information ! I wasn’t able to clearly guess your goal !

    • When you’re speaking of rows and columns, do you refer to the usual Excel notation : Columns A, B, C,… and Rows 1,2 ,3… ?

    • Is this column, of inhabitants names, part of a CSV file or alone, in a simple text file ?

    • Do you select this column with the column mode way or with a classical selection ?

    So, as usual, a piece of text, containing several occurrences of the area to delete, would, greatly, help us !!

    Cheers,

    guy038



  • hello Guy, it’s about rows…for now. I can easy make a regex like this:

    Search:

    العربية | Deutsch | English | Español | Magyar | Polski | Русский | Türkçe | 中文

    Replace with: (Leave empty)

    But it take time is If I have 60 rows. It may be a little faster to select with mouse those rows (copy) and paste somewhere and replace / delete them.


Log in to reply