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

learn more… | top users | synonyms (1)

0
votes
2answers
37 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
5 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
12 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: ...
0
votes
0answers
11 views

Multiple character lookup within square brackets with regex [migrated]

I’m using regex in JavaScript for certain text replacements to convert legacy encoded text to unicode (it’s an indic language). Suppose I anywhere I find either of a,b,c followed by either of x,y,z ...
1
vote
2answers
54 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
13k 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
27 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
22 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
18 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 ...
-3
votes
0answers
22 views

Excel: Replace only inside the brackets between

I have cell 452,Audi ,Audi 80 (B4, 8C, ka. S2, RS2) aasta 09/1991-01/1996 ,1.6 52KW / 71PS ABM aasta 09/1991-12/1994 This is in my CSV and delimiter is ",". But I need replace only in: ...
0
votes
1answer
34 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
18 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
33 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
28 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
60 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
65 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 ...
2
votes
7answers
14k 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
31 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
2k 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
69 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
45 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
121 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
35 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
37 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
792 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
94 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
103 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
276 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
42 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
4k 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
13k 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
69 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 ...
1
vote
1answer
75 views

Notepad++ replace .|every 5th line with .}

I got a text that ends on every single line with .| And I need to replace the .| on every 5th line with .}
2
votes
1answer
2k views

Multiple find and replace in a word document

I want to do a series of find and replace operations. Unfortunately, the documents I have to work on are in Word (.docx) format so I cannot script this. These are book chapters so formatting is ...
1
vote
0answers
34 views

How to find and replace lines in one file that match the pattern of lines in another file

I have a scenario with two documents. The first doc has lines of text, and the second doc also has same text with different text before and after this text. They need to be replaced. Doc 1 ...
0
votes
1answer
55 views

Notepad ++ Find word and replace line above and below

Here's my example : class Item478 { position[]={14186.376,18.035046,18340.531}; azimut=-134.41499; id=734; side="EMPTY"; vehicle="Land_LampStreet_F"; skill=0.60000002; ...
0
votes
1answer
89 views

Replace multiple strings in multiple files

I think the title speaks for itself. How can I replace multiple strings in multiple files? For example, I have the following strings: home.php, blog.php, forums.php, contact.php, etc. And I want ...
23
votes
8answers
19k 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 ...
2
votes
2answers
455 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 ...
2
votes
2answers
1k views

How can I replace around a wildcard in a regex search?

I'm trying to comment out all of the variable type declarations in a script I have, but I've run into this problem a few other times. I'd like to match a string, followed by a variable name, followed ...
0
votes
2answers
1k views

Adobe Brackets; How to use the replace regexp function?

I searched the Brackets user guide @github and couldn't find how can I use the the search and replace function inside of the program. A simple example is to find foo and replace it with bar in a ...
0
votes
5answers
334 views

On a Mac, how to rename all files ending with a question mark?

I have some files that are like: 123.mp3? I need to rename them to 123.mp3 How can I do this to all the files in a given folder? I'm on a Mac
2
votes
2answers
2k views

How to replace a specific character between specific words?

Would you be able to help me in finding out how I can use the Notepad++ Find/Replace function to replace a specific character between specific words. Please see the example below, I would like to find ...
1
vote
1answer
107 views

Notepad++ replace every 3rd and 4th iteration

I'm using notepad++ I'm wondering if it's possible to replace every 3rd and 4th iteration in lines of HTML. The original code looks like: <div class="ui-bar ui-bar-d" <div class="ui-bar ...
1
vote
1answer
3k 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 ...
1
vote
1answer
1k views

How to replace a word with Regular Expression in Microsoft Word 2007?

How can I replace a word with Regular Expression in Microsoft Word 2007? For example, I want to find and replace all \n with some spaces.
1
vote
2answers
232 views

replace all names with an alternative using Stream editor (Sed)

I got this question on a task. Nothing works.. Can someone help me? Write a sed script that replace all names with an alternative, search for every words that: Start with a capital, Longer than ...