Replace Pioneer Home All Examples Free Download

1403.Advanced search and replace -- How to delete rows in csv based on criteria of some column?

User: Sam -- 2017-10-03 << 1402 1404 >>

Hits: 2412

Type: Advanced search and replace

Search all Advanced search and replace examples

Description:

Delete rows in csv based on criteria of the following found in Column A and Column B:

All Merchants must have at least one Stock count. Else, then delete all items from
Merchant

Input Sample:

Marchant1,Stock
Merhcant2,NoStock
Marchant1,NoStock
Merhcant2,NoStock

Output Sample:

Marchant1,Stock
Marchant1,NoStock

Answer:

Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.

1. ctrl-o open csv file
2. ctrl-h open 'replace' dialogue
* set 'replace unit' to 'Line'
* set 'if' to:

* click 'advanced' tab, set 'run following at the beginning of replace' to:

3. click replace, done.
4. ctrl-s save to file.

Screenshot 1: Replace_Window

Screenshot 2: Replace_Advanced_Window

Similar Examples:

How to delete rows in csv based on criteria of specified column? (91%)
How to delete rows with same column as previous line? (59%)
How to replace a words with the previous word in the same column? (57%)
How to batch sort csv files by the order of value in the specified column? (55%)
How to merge other columns' data base on the value of the first column? (54%)
How to split a csv file according to the value of column A? (52%)
How to delete all lines containing specific word in specific column? (51%)
How to search and replace text base on csv file column 1 and 2? (51%)

Check Demo of Advanced search and replace

Keywords:

delete rows based on found stock toc mer else values delete all clear csv column delete delete column csv csv split rows split rows delete tab delete column column delete split file on column