Delete multiple columns/rows that repeats in multiple files

[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?

[guy038]

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

[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.