Replace Pioneer Home
All Examples
Free Download
all
Advanced search and replace
Replace text in multiple files
Regular expression replace
Batch file rename
Batch download
Text file parser
Text file splitter
Html text generator
Search replace binary
Random word generator
Count and statistics
Character encoding
Bin Hex Oct Dec converter
Text generator
Text sort
Text merge
Text data calculation
RSS: Replace Pioneer Examples
1320.Advanced search and replace -- How to replace commas with hash symbols for lines contain more than two commas?
User:
Dilip -- 2015-10-28
<< 1319
1321 >>
Hits:
2842
Type:
Advanced search and replace
Search all
Advanced search and replace
examples
Description:
If a line contains more than two commas then replace it with a # hash symbol
Input Sample:
Benz, Audi
Benz, Audi, BMW
Output Sample:
Benz, Audi
Benz# Audi# BMW
Answer:
Hint: You need to
Download and install "Replace Pioneer"
on windows platform to finish following steps.
1. ctrl-o open text file
2. ctrl-h open 'replace' dialogue
* set 'replace unit' to 'Line'
* set 'replace with pattern' to:
replace($match, ',', '#')
* set 'if=>' to:
count($match, ',') >= 2
3. click 'replace', done.
Screenshot 1: Replace_Window
Similar Examples:
How to remove all lines that contains more than one word?
(60%)
How to replace all the symbol @ with sequence number that started from 1?
(56%)
How to delete phrase does not contain word mat in between two tabs?
(54%)
How to extract all lines that has more than 2 numbers?
(54%)
How to remove/delete line breaks of all lines which has more than 20 characters?
(54%)
How to extract all lines that has more than 4 columns from csv file?
(53%)
How to replace all numbers 93 in every line that contains gas?
(53%)
How to remove all lines that shorter than 10 characters?
(53%)
Check Demo of
Advanced search and replace
Keywords:
replace commas
commas
symbols
more than
symbol
sym
two
contains
lines contain
replace comma
two lines
if match contains
symbol pattern
count lines
if contains
replace symbol
match contains
two text