Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

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

User: Dilip -- 2017-10-09          << 1403  
Hits: 114
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 7 and Column 8:

All Merchants must have at least one Stock count. Else, then delete all items from
Merchant
Input Sample:
1,2,3,4,5,6,Marchant1,Stock
1,2,3,4,5,6,Merhcant2,NoStock
1,2,3,4,5,6,Marchant1,NoStock
1,2,3,4,5,6,Merhcant2,NoStock
Output Sample:
1,2,3,4,5,6,Marchant1,Stock
1,2,3,4,5,6,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 some column? (91%)
How to batch sort csv files by the order of value in the specified column? (65%)
How to decorate each of marching number with specified format? (56%)
How to delete all lines containing specific word in specific column? (56%)
How to find maximum and minimum number out of specified column? (55%)
How to split each line of csv file into a single file with specified format? (55%)
How to delete rows with same column as previous line? (54%)
How to convert a text file to specified format? (54%)

Check Demo of Advanced search and replace
Keywords:
delete rows  based on  found  stock  toc  mer  else  values  delete all  clear  delete specified words  csv column delete  delete column csv  csv split rows  delete specified  split rows  delete tab  delete column