Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [find-and-replace]

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

0
votes
0answers
8 views

Find in Page on Chrome for different terms on different pages

Is there a way to get Chrome to find different terms in different windows using the 'Find in Page' mechanic? At the moment it looks like Chrome has a unified 'Find in Page' behaviour, i.e. changing ...
0
votes
1answer
27 views

How replace * character with what it's found

I can't find specifically what I'm looking for, possibly because it's not possible. Essentially, I want to find capitalised words and replace them with the capitalised word followed by a carriage ...
0
votes
2answers
28 views

How can I find & replace a single word to multiple different words?

Using MS Word or Notepad++, I wish to find and replace a single vocabulary to multiple different synonyms. For example, from my text, I found that a specific word AAAA appears too frequently. So, I ...
0
votes
1answer
33 views

How to find and select multiple items / values at the same time in Excel

here is an over simplified example of my problem I have 2 excel spreadsheets. The first spreadsheet has 1 column with a list of names John, James, Steve, Richard, Bob The second spreadsheet also ...
1
vote
1answer
38 views

How to add a number to string\d

I want to replace a file's all string\d\+ For example string10 to string 20.I tried using s/\(string\)\d\+/\1\=submatch(0)+10 I know \= is judge \1 is exist or not .But help: submatch use like this....
0
votes
0answers
33 views

Notepad++ Replacement String with NUL Truncates After NUL

Using Notepad++, I'm trying to replace a string (in a binary file) like this: ANULpNULpNULlNULeNUL With another string like this: ONULrNULaNULnNULgNULeNUL So... Using the following format of ...
2
votes
0answers
60 views

Mass replace drive letter on symlinks?

A drive letter changed (and I need to keep that change). I had used Link Shell Extension to relocate many things before this happened, so I now have a lot of symlinks pointing to locations at the old ...
0
votes
1answer
32 views

Find and delete many different strings in Excel

I have two different tables on Excel, and I want to remove from the first table all the elements presents on the second table. In the first table I have a long list (10000) of references, they are ...
0
votes
1answer
71 views

Batch Script: Replacing line with random number

I'm running game servers and I need a batch script that changes a number in another batch-file to a random generated number when executed. The line that should be edited is set _seed="255" The file ...
0
votes
2answers
77 views

Replace certain text in lines with each line from another file

I have a text file with text of this order; str/4 <</Contents(100 cups)/(Date) Colour red <</Contents(080 bowls)/(Date) Status used Pack team <</Contents(200 John)/(Date) School ...
0
votes
0answers
23 views

How can made MS-Excel Find and Replace dialog box as a bar which is docked below the window same as LibreOffice Calc interface option?

I have an opportunity in LibreOffice Calc which is very attractive for me. That is an option for UI interface. Made the Find and Replace dialog box to a sub-bar. And possible to dock it below the ...
0
votes
1answer
85 views

Add an <h1> tag from filename on Linux

I have a folder with a bunch of html files and I wish to add an <h1>Filename without extension</h1> line just after the <body> tag. How could I go about having a script or one-...
1
vote
1answer
107 views

Changing the numbers in “[#number]” format in an MTA file so they are sequential

I have a very long MTA file for scripting MP3 tag changes. I've edited the file numerous times in Notepad++ and this has caused the numbers for each particular action to go out of sync. How could I ...
2
votes
1answer
330 views

Find and replace plain text with merge field in Word

I have an email template that currently has tokens like [[cost]]. However, I am now transitioning to using formal merge fields, which look like «cost». I have the old format at lot in this template, ...
0
votes
1answer
46 views

Find and Replace in LibreOffice Calc

So I have a Price column and all the values has a £ prefixed. These are formatted string. I tried via the Find & Replace function to replace all of these with nothing, but I can't seem to get it ...
1
vote
1answer
240 views

Find and Replace specific column, but only when it equals a specific value

How do I replace column 132 (either a space or a Y) with a character (N), but only when column 132 = a space? Looking at other threads here I've come up with a way to replace column 132 with an N: -...
-2
votes
1answer
72 views

Replace special chararcters in a 60MB file

I have a big text file. 200,000 lines. 60MB. I would like to replace : &amp; -> & &#203; -> Ë &#202; -> Ê etc... Any simple idea please ? (Textpad or Notepad++?) Edit : ...
1
vote
1answer
251 views

VB script to find and replace using lookup table

I have a spreadsheet that I need to anonymise for an audit (Usernames, hostnames, IP addresses etc..) I'm trying to run a find and replace task on an entire workbook, I have created a lookup table ...
3
votes
1answer
36 views

Notepad++ Don't skip to next instance after search and replace

I am using the search and replace function in notepad++. Since it involves some regex, I would like to see the result after each single search and replace. However, if I click on Replace, the instance ...
1
vote
1answer
993 views

VS Code Find in current file: Regular Expressions

This is find and replace issue in VS Code. I want to find the following text in my Markdown file in VS Code: ## [](https://www.website.com/)Heading and Replace with this text ## [Heading](https://...
0
votes
0answers
29 views

Text typed into different apps (e.g. Chrome, Sublime) find functions (Cmd-F) overwrites each other

I'm seeing unusual behavior in the interaction between some Mac programs like Firefox, Safari, Sublime, and Chrome. I'll concentrate on the last two. I have a Macbook Pro (Retina, 13-in, mid-2014) ...
0
votes
2answers
223 views

How to mass-change index field text in MS Word?

Let's say I created dozens of index entries with value {XE "foo"}. Now I decide that I want to change that to {XE "fooz"}. Is there any way to do a mass search and replace to do this? I tried ...
2
votes
0answers
357 views

find string from multiple files and replace it without creating new file

I want to find string e.g. "date" from my files of a folder which contains multiple ".c" and ".h" files in it and replace it with "date 24-April-2018" using batch file. what should do? Please see ...
1
vote
1answer
335 views

Notepad ++ - Find text and replace the number after

I'm trying to use Notepad++ to find and replace a lot of random numbers in a long string. I have over 1000 text files with strings like this "movemeto":40. How can I replace the numbers following ...
1
vote
1answer
173 views

How to replace asterisk symbols (*) with bold tags to denote important words and phrases?

I have a document of nearly 20K lines. Many (but not all) of the lines use asterisk symbols to denote important words and phrases. Example: What kind of *vegetable* is it? You are *best?!* I hope ...
0
votes
1answer
66 views

can't find mistake in sed substitution [duplicate]

I'm trying to substitute include guards in headers with same include guards, prepended with #pragma once: #ifndef _HELLO_H #define _HELLO_H Becomes: #pragma once #ifndef _HELLO_H #define _HELLO_H ...
1
vote
1answer
80 views

Excel 2016 Find and Replace with miscellaneous character

I have a set of data that was imported from a pdf. When the data was brought into excel, it placed a period instead of a comma in a number. For example 1.334.10. I can find the problem with the ...
0
votes
3answers
241 views

Search for partial character string in Excel

The search tool in Excel allows for the string to be either a part of the cell or the entire cell, but can I use it for more complex options? For example, if I'm looking for cells ending in "cht", to ...
-8
votes
1answer
114 views

i don't know how to replace a line in notepad++ [closed]

i do now know how to do it it simple i even mad a short video https://youtu.be/3-fHpqXdK8c
1
vote
1answer
36 views

Auto-replace within hyperlinks in a Word doc

I have a Word document with a lot of hyperlinks in it. I need to replace the "http:" in all of their addresses with "https:". Is there a way to do that automatically in Word 2013, or am I stuck ...
1
vote
3answers
105 views

text editor find replace different words

Good evening I have got a question about some text editor. I am using CotEditor on Mac and I want to find and replace something special. I have an .csv data which I converted as an .txt data with ...
2
votes
1answer
576 views

Find superscript text in Word

I want to use Find and Replace to locate all instances of superscript text throughout a Word 2016 document. I had a look at Microsoft Technet's search string guide but couldn't find one for ...
0
votes
1answer
22 views

Is there a way to add a linebreak before any character in a set of characters in MS Word?

Is there a way to add a linebreak before any character in a set of characters in MS Word? I already had an answer for Notepad++, but I also need this feature (if possible) in Word. E.g. I would like ...
0
votes
1answer
28 views

How to add a linebreak before any character in a set of characters in notepad++?

Is there a way to add a linebreak before any character in a set of characters in Notepad++? E.g. I would like to add a linebreak before any number. Before: 1 Lorem ipsum dolor sit amet, consectetur ...
0
votes
0answers
431 views

VBA macro script to find/replace words, then highlight them to know what words were changed in Word docment

I have a nifty macro below that finds and replaces words, then highlights them so I know what words were changed by the script. However I have to set my highlight color first, then run the script. ...
0
votes
2answers
50 views

Formula: Excel Find and Replace All full stops before specified characters

I have a column of research data I wanted to clean. As users have not followed instructions, there are unnecessary full stops in the sentences. I need to remove all full stops that are before a ...
1
vote
1answer
33 views

How can I delete every letter in vim

In my code I have a HUGE line containing number and letters. How can I delete all the letters of this line using vim ?
0
votes
0answers
23 views

How do I delete all date/time stamps, everything between [ ____ ] with find/replace? What is the code required?

[10/10/16, 11:16 AM] (Addie) [10/10/16, 11:16 AM] (Addie) [10/10/16, 11:16 AM] (Addie) [10/10/16, 11:16 AM] (Addie) [10/10/16, 11:16 AM] (Addie) [10/10/16, 11:16 AM] (Addie) [10/10/16, 11:19 AM] ...
1
vote
1answer
15 views

I want to change in a TEX file : string a\a{nn}o into a(nn)o

I have a .tex file in which I want to replace the string a\a{nn}o with a(nn)o I have tried the following PowerShell (v5) code: (Get-Content h:\combined.tex) | ForEach-Object { $_ -replace "a\a{nn}o",...
0
votes
2answers
1k views

Notepad++ Replacing text between two points with different characters?

I have this text: D5 0.25 8;0.25 E5 0.25 8;0.5 F#5 1 8;1.5 E5 1 8;2.5 D5 1 8;3.5 B4 1 8;4.5 A4 Except, it's 800 characters long... For example, I would like to get the text between D5 and E5 and ...
2
votes
2answers
673 views

Using regex in the “replace” part of a search/replace?

I have a large amount of tab-indented (outlined) text that is missing a leading bullet character: some point a sub-point I want to replace each tab by 2 spaces, and add a hyphen ...
1
vote
1answer
218 views

LibreOffice Calc | How to reference a column (to iterate all rows) using a formula in “Find & Replace”?

i have two columns: A and B. In column A, there is some currency values (all positives). In column B, there is a value that indicates if column A value is positive or negative. i was reading the help ...
1
vote
1answer
91 views

Can I consider “whole word” as the word with space isolated in notepad++?

Currently, if I have the following text 5 0.5 4 Then I do a "whole word only" replacement for 5 to 9, I will get 9 0.9 4 instead of 9 0.5 4 So how can I get 9 0.5 4? Is this doable within ...
-1
votes
1answer
280 views

Notepad ++ add text in end of line with matching two strings

if lines start with NEW and contains / then need to add at end -reg. current: NEW /RAM VFXV RAM NEW /TEST SDFSDF DSFDSF NEW RAM expected: NEW /RAM-reg VFXV RAM NEW /TEST-reg SDFSDF DSFDSF NEW ...
0
votes
3answers
695 views

Replace <values> data in a lot of xml files

I have a lot of xml files with a specific structure, for example <Class="Object"> <Speed>25</Name> <Price>3</Price> I want to replace the values from specific ...
0
votes
0answers
36 views

FrameMaker 2017 Unstructured - automatically center data in a column

I am the technical writer for all user software, software, and programming manuals at a company. One of my books has has +6600 tables - called registers. I have to import these tables (usually) from ...
0
votes
1answer
94 views

Batch file to find and replace while keeping formatting? [closed]

Is there any way to make a batch file that will find and replace while keeping formatting like replcaing \begin{center} \begin{tikzpicture}[declare Function ={fy(\x)=sin(\x+rand*100)^2;}] \begin{axis}...
0
votes
2answers
59 views

For MacOS, how to delete text (long paragraphs) in multiple files?

I'm learning Swift, and the THE SOFTWARE Announcement of repos on github is too long. It is very important. I have seen the content, so i think it's OK to not see it. My question is how to delete ...
1
vote
1answer
73 views

Searching and replacing numbers

I use a lot of charts in documents and need to re-number them sequentially. I can use the following to find the next occurrence of a number within text: Selection.Find.ClearFormatting With Selection....
2
votes
1answer
237 views

Excel - Search & Replace - Multiple placeholder

is it possible to set a certain sequence of placeholders in Excels "Search & Replace Function" ? I got data like: aaa-bbb aaaaaa-bbb aaaa-bbbbbb and I only want to manipulate data that is less ...