Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

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: 150
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