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

learn more… | top users | synonyms (1)

0
votes
1answer
30 views

Replace Substrings

I have a big text file (~80 MB). In this file there are many substring like: 14501,14508,26000 that I have to replace with a special number range. I have starting range number like 14500-26000 that I ...
0
votes
1answer
17 views

Using -replace on pipes in powershell

I want to test out a replace before I use it, so I'm trying to write a quick online command to see what the output is. However, I'm not sure what the syntax is. What I want to do is something like ...
0
votes
1answer
13 views

Partial formatting in Microsoft Word find and replace

I want to use Word's "Advanced Find and Replace" tool to find this string: See, e.g., And replace it with this: See, e.g., The difference between the two strings is that the second comma ...
0
votes
0answers
11 views

Backrefence syntax in powershell's sed

How do I back reference a capture group in powershell's sed? I can't seem to find the syntax for it. IE I expect echo "hello" | sed "s|(h)ello|world\1|" to output worldh, but instead I get the ...
1
vote
1answer
45 views

Notepad++ Find and Replace: Wildcard Varying Number of Lines?

I have a tricky problem. I need to make a minor change to a large number of xml files (500+). The change involves switching a value from 'false' to 'true.' The line that needs to change looks like ...
3
votes
3answers
509 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 ...
1
vote
2answers
44 views

Delete n lines following a pattern (and the line matching the pattern)

How can I delete a line containing a matching pattern and the following n lines using a tool supporting regular expressions? Said differently, how can I write a regular expression matching a line ...
0
votes
2answers
25 views

Find text and replace paragraph as a style

I'm working with a large document in Word that was converted from .pdf so any outline formatting was stripped out. I'm looking to run find replace where I'm looking for wildcard "[A-Z]. " and want to ...
1
vote
1answer
25 views

Make all sentences paragraphs in MS Word

I have text in MS Word 2007. It is needed to make all sentences paragraphs. I can go over text and press Enter after each sentence but want to do it automatically. I am thinking about using ...
0
votes
2answers
25 views

Notepad++ Remove Text after String

my text from IEEE looks like as follows: Spinellis, Diomidis, "The Strategic Importance of Release Engineering," Software, IEEE , vol.32, no.2, pp.3,5, Mar.-Apr. 2015 URL: ...
1
vote
0answers
28 views

How to replace only text in a selected column

When I select some text in a column, replace/in selection will become grey. How can I replace text only within a column of selected text in Notepad++?
-1
votes
2answers
102 views

Replace any number of spaces using regular expressions

How can I replace any number of consecutive spaces, with, for example, a tab in a text editor supporting regular expressions (like Notepad++) To clarify: Replacing every occurrence of one or more ...
2
votes
1answer
31 views

Replacing strings of (Hexidecimal) zeros in Notepad++

I have binary code that have 4 sets of zero strings (00 00 00 00) and also have sets of 3 (00 00 00). I want to get rid of the sets of 4. (replace with nothing.) When I do 00 00 00 00 in "find", it's ...
0
votes
2answers
31 views

How can I do find and replace with regex on Microsoft Word

I have a document that has (TL by user) all over the place. I'd like to replace this with nothing (thereby deleting it everywhere) but the user could be different or there could be many users (TL by ...
8
votes
6answers
20k 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 ...
1
vote
1answer
25 views

Find text and replace with index

I need to find a string and replace it with a moving index (in this case find pattern is "replaceThis") For example: id=replaceThis ...... id=replaceThis ...... id=replaceThis should become id=0 ...
7
votes
5answers
19k 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?
0
votes
2answers
49 views

Remove space before specific text excel

I have a list of 1000s of different labels and need to remove the space between the number and mg. Sometimes the space is present and other times it's not. The position of the text "mg" is not the ...
0
votes
0answers
8 views

How to use Find to highlight words and retain highlighting?

I'm using Word 2013. I can use the Find feature to pick out words from a document, then Highlight All examples that meet the search criteria. But the highlighting disappears when I try to edit the ...
0
votes
1answer
13 views

Excel: Find&Replace issue

I'm trying to find out, how to replace only those substrings (in my case it is ,_ where _ is a space), which starts at the beginning of the cell. I suppose, the solution should be like this regex: ...
1
vote
2answers
126 views

Find and replace notepad++ with wildcards

I've read about 15 tutorials on regular expression however I'm clearly not getting as I've been unable to tailor it to my problem. I have one set of code which would be found in many different ...
11
votes
2answers
14k 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 ...
0
votes
1answer
37 views

Notepad++ Check line number in search and replace

I am looking at translating guitar tabs into a string of digits! so when I do a search and replace, its wrong... for example Line 1 a 5 is a "A" line 2 a 5 would mean "D" My question is, How can I ...
0
votes
1answer
30 views

Excel: Find and Replace - Adjacent Columns

In excel, after I search and click "find all", I want to see the matching adjacent column values in the results list (so I can compare them). Is there a way for me to archive something like this? Or ...
1
vote
1answer
28 views

Word wildcards/regex search from the begining of line till the first :

In MS word 2013 I'm having multiple lines like: Duis pulvinar, enim montes : magna tincidunt penatibus nec amet a nec tristique rhoncus aliquet? porttitor diam amet : nascetur sociis dapibus ...
0
votes
1answer
40 views

How to extract a substring and add it to original string with sed?

I am trying to write an sh script witch receives a string as input, extracts a particular substring and adds it after an specified expression to the input string. I tried a lot with sed -i'N ... but ...
0
votes
3answers
1k views

Excel or Batch - Trying to Automate Text Correction (Many Changes; One or More Characters Each)

I have a lot of lines of text. I can put them into a text file or into an Excel spreadsheet. They need many changes. Here's an example of a before and after: Input: I'm buying one! Only ...
0
votes
1answer
23 views

How do I replace one argument in each formula in a column of formulas?

I have a column of formulas like this: =VLOOKUP($C3,Sheet4!$A$1:$H$50,7,0) picking up the details in column 7, as you can see. But I have now removed two columns from sheet 4 and the pertinent ...
0
votes
1answer
37 views

Place string in front of underlined text in Word 2013

I have a bunch of questions with right (underlined) and wrong answers in a list like this: 1. What is love? - baby - don't - hurt - me where only the part with the right ...
0
votes
1answer
34 views

Replace a couple of strings of text automatically?

More detailed: I've got a folder with data for a game which code is pure text and customizable (M.U.G.E.N). Beside all other things, the *.cns file of each character contains following string of ...
0
votes
1answer
135 views

How to find and remove external links in (Libre|Open)Office Calc spreadsheet

I have a LibreOffice Calc spreadsheet which pops up a message asking me whether I wish to update external links. I did not add external links myself, but did copy data from another Calc window at one ...
0
votes
0answers
11 views

Contents of find-and-replace input shared between programs

When using the find functionality in Firefox and Sublime Text 2, the contents of the input field are shared between programs. Effectively, if I have been using find in one program, as soon as I hit ...
2
votes
1answer
71 views

NotePad++ - How to remove or replace newline characters?

Within my notepad++ environment, I have the following value on a page... test me out </li> I can search and find the ending </li> value with.... \n</li> but what do I need to ...
3
votes
7answers
15k 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 ...
0
votes
0answers
40 views

Is there any reason Word 2013's Find/Replace (using wildcards) would replace things out of order?

I'm using find/replace with wildcards. Let's say I want to surround specific text strings (names of Word documents) with parentheses. Each word doc starts with BP_ and ends with docx. Find: ...
2
votes
2answers
3k views

How to replace one line to two lines or more on a text file using the “find and replace mode”?

Right now I'm developing a script with vbscript and I need to find one specific line(with a lot of occurrences) on a 5k lines source code and replace it to two new code lines(1 line to 2 lines ...
0
votes
1answer
38 views

Need to replace text in clipboard based on a pattern [duplicate]

I have text like: 123*321 (* represents a wildcard) When I copy and paste it, I need to recognize the pattern (123 and 321), and replace the entire string with another. For example, I copy ...
0
votes
1answer
95 views

Delete “unidentified” carriage-return char from a text file

I have a text file containing a strange "carriage return" char. If I open the file with Notepad I can't see the new line. If I open the file with Wordpad I can see the new line. I uploaded an ...
1
vote
2answers
51 views

Replacing several strings in a file in one go

Suppose I want to replace all AAA with BBB and all BBB with AAA in a text file. The thing which looks an obvious solution (in Perl or in Sed) is: s/AAA/BBB/g; s/BBB/AAA/g; But this does not ...
0
votes
1answer
264 views

Multiline find and replace wrapper with wildcard inside

I'm trying to put a wrapper around a bunch of fields that already exist. I want to convert this: <div class="editor-label"> @Html.LabelFor(Function(model) model.FirstName) </div> ...
1
vote
1answer
36 views

How do you Find & Replace only in specific Styles in Word?

I have a document with sub-sections and text. The sub-titles for each sub-section starts with a number. I want to remove this number. I know searching for ^# and replacing with 'blank' removes all ...
1
vote
1answer
40 views

Linux bash, command replace

How can I erase the - from clipboard? I have a script: #!/bin/bash xclip -o | replace - "" | xclip Bat this doesn't work So replace \- "" take no effect ]$ uname -a Linux localhost.localdomain ...
0
votes
1answer
840 views

Add new line after words matching a specific pattern

I'm trying to add a new line before and after a hyphenated word (one or many hyphens) in Notepad++ Input This is a search-and-replace test which I need-help to figure-out</h2> Output This ...
2
votes
1answer
133 views

Bug in Microsoft Word with Find and Replace when searching text containing a hyperlink?

I was trying to replace a text with a email address in the middle of it in a Word document. If I only use the Find command, then it works fine, and Microsoft Word finds the text I wanted to replace. ...
2
votes
2answers
347 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 ...
0
votes
1answer
297 views

Microsoft Word wildcards

I have a document that has the word "The" capitalised in many places it shouldn't be. I wish to change "The" in those cases, to "the". I need to change any instances of "The" that are not at the ...
0
votes
1answer
56 views

Search and replace option in notepad++ for making a dictionary

We've gotten several files from a professor who published his dictionary and we convinced him to make it open source and make it freely available online. So now I've ended up with several files with ...
4
votes
2answers
5k 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 ...
10
votes
3answers
14k 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 ...
0
votes
0answers
118 views

How do I bulk replace a hyperlink containing a File:\\ command in excel

I work with Sharepoint 2007 and Excel 2007 In SharePoint I sometimes use a hyperlink with the file command like; (file://\\group.net.dk\sites\S01625\stt\Drawings). This is useful when I want to open ...