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: 395
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 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%)
How to add a '#' before every number not followed by ','?
(50%)

Check Demo of Advanced search and replace
Keywords:
anything  matching  xxxxx  found  remove first  find  before  last  las  delet  remove first and last character  remove text before  remove before  find and replace add  replace first character  first character  add page number  replace first last