Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

96.Advanced search and replace -- How to add SH before each number, and remove/delete quota "'"?

User: editor -- 2008-05-13          << 95  97 >>
Hits: 2860
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to add SH before each number, and remove quota "'"?
Input Sample:
'3000001','1800003', 
'6000000','9333333', 
...
Output Sample:
SH3000001,SH1800003, 
SH6000000,SH9333333, 
...
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
It's easy, the solution is to find pattern 'xxxxx', and replace with SHxxxxx(remove first and last quota and add SH before it) 
1. ctrl-o open source file      
2. ctrl-h open replace dialog,      
in 'Replace' page,      
1)set 'Search for pattern':   
 
2)set 'Replace with pattern': 
 
3. Click 'Replace', that's ok! 
Note: \'.*?\' means anything matching 'xxxxx' 
chars($match,2,-2) means the character 2,3,4,...-2(bottom 2) of  the found text.
Download Script:  scripts/96.rst.zip

Screenshot 1:  Replace_Window


Similar Examples:
How to add line_no before each line of a text file? (56%)
How to add 0 before all 4 digit numbers in multiple filenames? (55%)
How to add one space before each digit of number in a text file, but ignore other letters? (55%)
How to add a number and remove "new line" for each segment separated by "@"? (53%)
How to search the "?" and remove/delete the text to the right of the "?" (53%)
How to batch remove/delete lines started by "address:"? (51%)
How to change each number to an increasing number starting from 8? (50%)
Is there a way to add a fixed line before each line of text? (50%)

Check Demo of Advanced search and replace
Keywords:
anything  matching  xxxxx  chin  quot  found  bottom  xxx  remove first  find  find character number  remove first and last character  remove last character in text file  remove first character  remove text before  remove last character  remove before  remove first number