Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Delete multiple columns/rows that repeats in multiple files

    Help wanted · · · – – – · · ·
    2
    3
    1845
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Vasile Caraus
      Vasile Caraus last edited by Vasile Caraus

      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?

      1 Reply Last reply Reply Quote 0
      • guy038
        guy038 last edited by

        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

        1 Reply Last reply Reply Quote 0
        • Vasile Caraus
          Vasile Caraus last edited by Vasile Caraus

          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.

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Copyright © 2014 NodeBB Forums | Contributors