Operations that locate specific instances of conditions being met and replacing them.

learn more… | top users | synonyms (1)

32
votes
1answer
19k views

Search and replace with TAB character in Sublime Text 2

In Sublime Text 2, I want search and replace by the TAB character. I tried replacing with \t char but it's not working. How can I do it?
29
votes
5answers
31k views

How can I do a recursive find and replace from the command line?

Using a shell like bash or zshell, how can I do a recursive 'find and replace'? In other words, I want to replace every occurrence of 'foo' with 'bar' in all files in this directory and its ...
27
votes
9answers
23k views

How to remove this symbol “^@” with vim?

I have some files that are corrupted with this symbol: ^@ It's not part of the string; it's not searchable. How do I substitute this symbol with nothing, or how do I delete this symbol? Here ...
15
votes
1answer
6k views

vim delete all lines that do NOT contain a certain word

In vim I can delete all lines that contain the word "price" with this :g /price/d How can I delete all lines that do NOT contain the word "price"?
12
votes
1answer
9k views

How can I use newline with the Find-And-Replace in Visual Studio?

I've become rather fond of the "Find-And-Replace" function in Visual Studio. The function lets me replace phrases, words, symbols, or whatever you can type into the textbox on the screen. How can I ...
11
votes
2answers
19k views

How to find and replace the character “*” in excel

I am trying to find and replace the * (star, or shift+8) character in a bunch of formulas in Excel 2007. * of course matches the ENTIRE contents of the cell, which is not what I want. How do I ...
10
votes
3answers
16k views

Can I search and replace in a Notepad++ macro?

I'm trying to create a macro in Notepad++ that allows me to do a few standard Search & Replaces. I can get the macro to do everything (add lines, add characters) except search and replace. I ...
10
votes
3answers
8k views

Use Notepad++ to change under_score_case to CamelCase?

I can write a regular expression in NP++ to find under_score_case. I can use TextFX in NP++ to change case to upper and lower case by highlighting and selecting. How can I use either NP++'s ...
9
votes
3answers
3k views

Search and replace tool that can handle multiple files and subfolders [closed]

I'm looking for a tool which can search/replace within file contents for a broad range of file types (i.e. it should, if possible, process the maximum possible number of file types like .txt, .sql, ...
8
votes
5answers
25k views

How do I find and replace a character in filenames in Windows 7 using Explorer?

I want to replace all the underscore characters (_) with a space () in a filename. How can I do this quickly, when I have lots of _ characters to replace?
8
votes
5answers
19k views

Notepad++ Delete Lines with Find & Replace

Does anyone know how to delete a line using Find & Replace in Notepad++ ? In my Find query it finds the proper lines okay: ^.pPrev.$ In the Replace field, I leave it blank thinking the line ...
8
votes
6answers
21k views

How can I search and replace in multiple Word files?

I am looking for a way to do search and replace in many Word (.doc) files (for the purpose of automation of the process). The software I found so far only allows me to search, but not replace. How ...
7
votes
5answers
21k views

Find and replace multiple blank lines

How do I use the find and replace function in notepad to delete multiple blank lines in a text file?
7
votes
1answer
15k views

Find and replace in Notepad++ using wildcards/regex

I have a SQL dump with expressions such as youtubehd:2nj6bykw. The 2nj6bykw can also be a different random string. It is always 8 characters long. I want to replace youtubehd:2nj6bykw with just ...
6
votes
7answers
18k views

Find and Replace several several different values all at once

I have a file with multiple instances of Text_1 and Text1 and I need to replace both those strings with Text_A and TextB respectively. Currently I'm doing two Find and Replace functions on each ...
6
votes
2answers
20k views

Replace newline character with another in Word 2007

Using Microsoft Word 2007, is it possible to replace the newline character (\n) with some other character? What about vice versa? (That is replace a character with the newline character).
5
votes
6answers
16k views

Regex Replace from Command line

Is it possible to regex replace from command line? Right now I'm using notepad++ to do this. In command line I can only use FINDSTR wich can only locate the mached files/lines EDIT : Maybe it will be ...
5
votes
2answers
3k views

how to do a vim search inverse search for all lines with out text

with grep I can do a grep -v "my search" to get all the lines with out "my search" with sed I can sed '/baz/!s/foo/bar/g' to find replace text on lines with out baz Is there a way to do the same ...
5
votes
2answers
3k views

Multiple search and replace actions in one large text file

I have a big text file (about 2GB). I want to do five search and replace actions on the same file, and would like to do this in one command. Normally I use vim, open the file, do one replace action, ...
5
votes
1answer
408 views

How can I insert a page break using Find/Replace dialog in Word 2007?

I'm trying to replace "----------" with a new page or a CTRL+enter keyboard shortcut. I pasted "CTRL+ENTER" into the "Replace With:" field in Microsoft Word 2007, hoping that when I clicked "Replace ...
5
votes
3answers
1k views

Emacs Evil search and replace function

Emacs has a Vim emulator mode called Evil. This mode has a search-replace function that does basically the same thing as highlighting a region and running sed on it. The brilliant thing about this ...
4
votes
4answers
3k views

Is it possible to edit a PDF file directly?

I have a PDF file that is produced as part of a help file compilation. There is always late breaking stuff which goes into a text file (e.g. "What's new in this version" type of stuff) and while Help ...
4
votes
2answers
2k views

How to “demote” all titles and headings in Word 2010?

I built a large help document for an application I wrote. I used all the default styles in Word 2010, including "Title", "Heading 1", "Heading 2", etc. Sadly, when I generated the Table of Contents, ...
4
votes
3answers
627 views

Replace a regular expression within vim with an output produced by a console command with the expression as its argument?

let's say I have a file with the following content: This is a _file_ which has some _special_ keywords, that I would _like_ to replace. I can do a search and replace of the speical keywords ...
4
votes
3answers
6k views

How to find and replace link paths in multiple Excel files at once

We have a huge folder containing office documents on our server. IT wants to change the name of the folder from Mehper_repository to Planning_reports. Since most of the Excel files in the subfolders ...
4
votes
2answers
1k views

shell script to replace a keyword in a file with the contents of another file

I'm to create a .sh to replace a specific keyword in a file using the contents of an other file. template.html contains a unique string "PLACEHOLDER" it must be replaced with the contents of file ...
4
votes
2answers
2k views

sed: replace first occurance of a string in every line

Imagine I have a file like this: INSERT INTO table VALUES('1','<p><em>The lazy fox jumps again</em></p>bunch of other html<p><em>Is the lazy fox ...
4
votes
4answers
3k views

What's the best way to find and replace text in multiple files over FTP?

How can you search and replace text in multiple files on an FTP server? Basically I need to change the Google Analytics information on a bunch of plain old HTML pages and I'm wondering if there is a ...
4
votes
1answer
80 views

Find-And-Replace Any Selected Text

Goal: Quick find-and-replace for active selected text in any application. Description: I want a utility to quickly perform a predetermined find-and-replace for the current selected text in the active ...
4
votes
2answers
6k views

Replacing all special/accented characters with equivalent regular characters in Notepad++

I'm trying to figure out a way to automatically search and replace all special/accented letters/characters (such as Â/Ô) with the equivalent regular letters/characters (A/O) in Notepad++. Tried using ...
4
votes
2answers
2k views

Using search and replace to remove line breaks in Open Office

I've imported a document into Open Office and it has a number of hard returns in wrong places. In MS Word, I could use the search and replace to simply get rid of them all easily, but Open Office's ...
4
votes
1answer
744 views

ms excel find and replace @ symbol results in broken formula

I'm trying to search and replace in excel, the column is formatted as 'Text'. Find: [@ replace with: @ Whenever this finds a match at the start of a cell i.e the cell contents start with [@ and ...
4
votes
1answer
561 views

How to do a search-and-replace in Opera for textarea context?

How do I do a search-and-replace in Opera for a textarea's context? I have a web page with html form and I need to input and edit large text in this form. Easy example: Stay on this page, scroll ...
3
votes
2answers
454 views

How to format a string substitute, or a text line, in Vim?

Is it possible to format the replacement string when substituting a match with Vim? Say I have a file with a 2-column table, where the entries in each row are separated with a space. The entries (and ...
3
votes
1answer
10k views

Multi-Line Sed Replace

Consider the following text (incidentally, part of a MySQL dump): CREATE TABLE `table` ( `id` int(10) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `description` text NOT ...
3
votes
3answers
3k views

Substituting a multi-line pattern in an HTML file

I have a series of HTML files that contain two lines like this: <body> <h1>Title</h1><p> <a href="url">Description</a><br> I want to replace this text with ...
3
votes
4answers
5k views

Excel Smart Find and Replace only specific characters

I want to change INT to INTERNATIONAL and NA to NATIONAL ASSEMBLY in whole excel workbook through an excel Macro or Find and Replace dialogue box. But when I run the macro or change it through Find ...
3
votes
1answer
502 views

Linux: Find all occurrences of “string1” in files under a directory and replace them with “string2”

In linux, what's a good way to find all occurrences of "string1" in files under a directory and replace them with "string2"?
3
votes
2answers
36 views

How to insert a recent search pattern to use for search-and-replace in vim?

I've entered some search pattern in vim using / command. Now, I want to replace those occurrences I've found with something else. How do I easily insert the recently used search pattern into the :%s/ ...
3
votes
2answers
3k views

How can I search and replace in Firefox?

I am moderator on a site with lots of structured content and regularly edit posts for poor formatting (in particular Markdown and LaTeX). Many of those tasks are tedious and could easily be performed ...
3
votes
2answers
349 views

Append lines one after another in notepad++

How do we achieve the following using replace function in notepad++? Transforming the following cow horse elephant camel into 'cow','horse','elephant','camel' I know ^ and $ (under Regular ...
3
votes
1answer
409 views

Can I delete any line with a given search string?

In Vim, I'd like to search for lines with a given string, then delete them. Specifically, I'd like to find lines with the LaTeX commands \begin{frame} and \end{frame}, and delete them. =
3
votes
2answers
6k views

How to search & replace within a cell value?

I have a cell A and its value is 122abb12. In another cell B, I want its value to be the value in cell B but all 1 should be replaced by I - value in cell B should be I22abbI2. What is the function ...
3
votes
1answer
4k views

Replace text when in visual-block mode

Maybe I'm searching the wrong way, but I've failed to find out how to do this. Here's the scenario: I have a list in a text file where I want to insert the same word on multiple lines, here's an ...
3
votes
1answer
5k views

Delete all text before and after a certain string

I have some URL like the following http://www.SOMEURL.com/first-category/1343381-example-text-text-text-text-2000-a.html What I want is to simple delete all of the text before and after the number ...
3
votes
2answers
4k views

Notepad++ find and replace expression help

I want to find all content between two characters, say A and B: Asd;lfksjd;fsdfjs;ldfkB which would be sd;lfksjd;fsdfjs;ldfk and replace them. How would I write this expression?
3
votes
2answers
976 views

Sed replace between 2 strings with special character

I have an XML file containing a code and to use it with xmllink I need to remove a link. XML file containing: <xml version="1.0" encoding="UTF-8" standalone="yes"?> <PackingList xmlns="Link ...
3
votes
1answer
889 views

Saving part of found term when replacing in Notepad++

I want to use Notepad++ to find/replace large chunks of code, but a hefty part of it deals with arrays. How can I put a "variable" in Notepad++'s Find/Replace window so that part of it can be saved ...
3
votes
2answers
10k views

Using sed to replace string with special characters in XML file

I am having difficulty getting sed to replace a string of text in an XML file, despite the fact that I have no trouble using grep to find that same string. Since the new string and old string to be ...
3
votes
2answers
745 views

Microsoft Project 2003 - How to do a “find” in non-expanded nodes?

I am using Microsoft Project 2003 find command. When I choose ctrl+f and type a string to search for, MS Project only appears to search tree nodes that are expanded. Is there a way to get MS Project ...