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.