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

learn more… | top users | synonyms (1)

1
vote
2answers
482 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 ...
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 ...
2
votes
3answers
29 views

Find and Replace with Notepad++

Having a large list with icons to include in HTML icon-picons-abacus icon-picons-add icon-picons-airplay icon-picons-alert HTML Code <div class="col-sm-4 col"><em ...
1
vote
1answer
273 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
vote
1answer
12 views

Find and replace in output of command based on file contents

I have a tail -f command reading a log containing IPs however I wish to replace these IPs with hostnames, I have the dhcpd.leases file available to the machine on which this is running. I have been ...
1
vote
3answers
43 views

Remove spaces between characters in cell, but only if the space exists between two single characters

To process in 10,000 lines of excel, to remove spaces between characters in cell, but only if the space exists between two single characters. P J A JACKSON AND SONS should become PJA JACKSON AND ...
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).
0
votes
1answer
25 views

VLOOKUP returning N/A because references contain “.” and “ ” in one table, not in other

OK I am trying to vlookup a table but the problem is the references on one table are slightly different to the references on the other table. I can get the VLOOKUP function working, but it is ...
-1
votes
1answer
15 views

replace/rename directory name using regex

i have multiple folder with this pattern "720p.MP4-ABC[abcde]" trying to replace or rename "720p.MP4-CAB[aedcb]" to "."
0
votes
1answer
15 views

add closing tag at end of line using notepad++

I have a text document where every line has an opening tag. I need to add a matching closing tag at the end of each line. For example: What I have:<exe>Example text between tags. What I ...
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 ...
1
vote
0answers
33 views

Search & replace speed in Notepad++ / indexing

I am using Notepad++ to search and replace in around 60, 000 files, one folder. It only seems to be processing around 2 files per second, is there any way to speed this up? I have an i7 processor ...
1
vote
2answers
62 views

Replace copyright header in deeply nested hierarchy

Our project is open source and I need to substitute all our copyright headers for our new license's. The project consists of about 1500 C++/Obj-C/Java files across a nested folder hierarchy. A header ...
0
votes
2answers
34 views

Find and replace capture group inside file

I'm trying to read a text file, doesn't matter what language ... $x = [IO.File]::ReadAllText("__init__.py") ... find a string $pattern = [regex] '(?s)(?:ExportSTL.+?global_scale = ...
2
votes
2answers
55 views

String replacement in Windows batch

I am trying to understand how string replacement in Windows batches actually works and having trouble. @echo off set var=wild set varnew=%var:l=n% echo var is: %var% echo varnew is: %varnew% does ...
0
votes
1answer
41 views

Find and replace by a single dot several series of two dots attached to the end of words

I want to replace every series of two dots in a document by a single dot, excluding the cases where there are three dots in a row, i.e., the written ellipsis (...). Yet, the series of two dots always ...
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 ...
0
votes
0answers
12 views

Regular expression for find in files in Textpad

I want to use regular expression for find in files in TextPad. I need to find URLs starting with "Areas/" and ending with "/pdf"(something like this Areas/../../...pdf). Please suggest me the correct ...
2
votes
2answers
32 views

How to search for text from back to front

Backstory: I am copying and pasting search results from a website into word. the pasted text looks something like the image below: Goal: I only want two lines from each set of search results ...
0
votes
1answer
22 views

Find and replace blocks of formatted code in multiple HTML files on a Linux server

Many of my sites consists of hundreds of HTML files, and I often have to make changes via "Find and replace" in all files simultaneously. I use a combination of FTP, cPanel's file manager, Notepad++ ...
0
votes
2answers
315 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 ...
0
votes
0answers
9 views

Mac OS X Find and Replace API

Are the Find and Replace operations under the Edit menu in Acrobat or Word simply a front end for the unix awk, sed or grep commands? Where can I find more information about what's going on underneath ...
1
vote
1answer
40 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
0answers
30 views

Delete lines containing string using Notepad++ [duplicate]

I would like to delete all lines in multiple HTML files containing the following strings: api.addthis.com <!-- span class="invisible">Bookmark Thanks for the help!
0
votes
1answer
60 views

Regex for “Delete everything going forward but only up until start of [Expression]” [duplicate]

I am in Notepad++. I have the following data embedded in a large html file. I want to get the variables before the </ix:nonNumeric> at the end of the lines, onto their own lines by themselves so ...
2
votes
2answers
462 views

How do I set the default search direction in Word's Find and Replace from `down` to `all`?

How do I set the default search direction in Word's Find and Replace from down to all? I really hate how "helpful" Word is by asking me constantly if I want to search the rest of the document.
0
votes
1answer
46 views

Delete all code inside a tag in multiple HTML files with Notepad++

I need to delete all code contained within <li class="share"> ... </li> including the <li> tags themselves. There are multiple other <li> tags inside the li class="share" ...
0
votes
1answer
75 views

Notepad++ Deleting everything apart from 40 variables, putting them on their own line, combining regex

I am in Notepad++. I have the following data embedded in a large html file. I want to get the variables before the </ix:nonNumeric> at the end of the lines, onto their own lines by themselves so ...
0
votes
0answers
59 views

iXBRL to XBRL? XML inside HTML - Excel can't resolve

I have a bunch of files which should be a table with one row and 30/40 columns with data, in this format: Inline XRBL (iXRBL - XML in HTML) ...
0
votes
1answer
39 views

Notepad++ delete everything in entire large file before and after a variable

I have large text files with all kinds of characters, symbols and numbers. Can I use notepad++ to batch work through a directory of these and delete everything before and after a variable? I need to ...
4
votes
1answer
79 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 ...
1
vote
1answer
28 views

Delete metadata in multiple files

How do i use Find and Replace in Files in Notepad++ to delete the following lines from multiple files? <meta name="perc_linkback" id="perc_linkback" content="xxxxxxxxxxx"/> and <link ...
2
votes
1answer
25 views

Excel 365 Find and Replace modifies column formatting

I have a column in spreadsheet set to 'text' format that looks like this: xxxxxx057483245 I am attemtping to replace the x's with another series of numbers. 42424242 for example. I go to find and ...
2
votes
2answers
46 views

How to Replace Every Space in a Notepad++ Doc With a Null Character?

I copy and pasted the hex (I think it's hex, but I have no clue) from one document to another and all the null characters turned into spaces. How would I change them all back to null characters, ...
0
votes
0answers
72 views

Replace text with images in Word using VBA and avoid dialog box

I've been trying to replace specific text with a related image, but cannot stop the 'word reached end of doc, start at beginning' (press OK to keep code going) from coming up, despite Find.Wrap = ...
0
votes
5answers
9k views

Replace given char with ASCII nul in Notepad++

I tried extended search --> replace with \0, but it does not seem to work. Instead it deletes all occurrences of the character. Could it be a bug? NB: replacing with \n, \r\n and the like works in ...
0
votes
0answers
12 views

Replace numbered paragraphs from one document to another?

I have two documents that are identical, but one is in English, the other in Spanish. I took the first and took care of reformatting it by hand, mostly. Now, rather than going through the lengthy ...
0
votes
1answer
38 views

Opposite font formatting

I remember seeing somewhere an option to set the cursive, also called italics, formatting in such a way that, when applying it to the selected text, the value of every single character changes to its ...
0
votes
2answers
89 views

Is it possible to stop Notepad++ from searching inside binary files?

I just discovered via an unfortunate accident that the Find in Files feature in Notepad++ searches files inside RAR archives. After running several "find and replace" queries, all the RAR files I had ...
1
vote
0answers
24 views

How to replace HTML code using MS Word 2010?

I’m trying to delete the CSS from my code using Word 2010. I’ve searched online on how to find and replace text, and tried some but none worked. Below is the code i don't want. ...
2
votes
0answers
63 views

How to rename files in file from lines of a text file

My script PowerShell: $liste = get-content "Y:\Users\H\Documents\D\Game Of Throne\prod\recup.txt" ` |Select-Object -last 1 $liste | ForEach-Object {Write-Host ($i++) $line} get-childItem ...
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 ...
-1
votes
2answers
54 views

Find and replace {0,} occurrences in Word

Are there any alternatives to the concept {0,} which is not allowed in MS Word? For example, if I wanted to replace, by a single abbreviation, the next five terms: articul articulo articula ...
1
vote
1answer
45 views

How can I add a fixed amount of time to all “hh:mm” strings in a document?

I have a document that's a transcription of a video interview. The video itself has embedded SMPTE timecode as well as burnt-in timecode (BITC). The SMPTE timecode and BITC correspond to the time of ...
0
votes
0answers
40 views

Adobe Brackets: How to find and replace using Regex?

I have installed the latest version of adobe brackets on my Dell laptop. Before this I was using notepad++ and there are many features in notepad++ that I'm trying to load in brackets via extenaions ...
0
votes
1answer
24 views

How to specify a replacement string with a newline in it?

I am using Source Insight. I am trying to replace the string Tmem::Set with the following string that includes a newline in it. //here memset I set the replacement string to be the regex [//here ...
1
vote
1answer
47 views

Search for specific key word and replace entire cell contents with something else in LibreOffice Calc

I would like to be able to search for a specific word, lets say "House" in a calc sheet, and then replace the entire cell content with something else like "Car". It is important to notice, that the ...
0
votes
0answers
25 views

Notepad++ - Replace multiple lines with multiple lines

I've got 3 text file with thousands of lines like this: File n°1 name1_a name2_a name3_a name4_a name5_a File n°2 name1_a name4_a name5_a File n°3 name1_b name4_b name5_b What I want to do ...
0
votes
2answers
56 views

How to construct a regex find/replace in word 2010

I have some limited experience with basic javascript regex, which I've used to manipulate some user data entries. But now, I've been asked about manipulating MS Word 2010 documents. Specifically, my ...
0
votes
1answer
33 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 ...