Questions tagged [find-and-replace]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
12 views

How to replace Weekly Off with "Absent" if attendance status is "Absent" before and after Weekly Off and there could be multiple condition of "Absent"

How to replace Weekly Off with "Absent" if attendance status is "Absent" before and after Weekly Off and there could be multiple conditions of "Absent"
user avatar
0 votes
1 answer
9 views

How to do a bulk delete or replace

How to do a massive replace or delete (44k+ lines) with the below: Line 238440: <FLTR> Line 238441: <FLTR> Line 238442: <FLTR> Line 238443: <FLTR> Line 238444: <FLTR> ...
user avatar
  • 1
1 vote
1 answer
35 views

Remove the first blank line from every document Notepad++

I use markdown with YAML frontmatter as below. I want to remove the first blank line that appears in every document using Notepad++. I would appreciate if anyone could help me to do this. Thanks in ...
user avatar
1 vote
1 answer
25 views

Find the word "Dr" (with the "r" in superscript) in MS Word, and replace it with "Dr" (with the "r" in normal font)

I am looking for a way to replace all occurrences of "Dr" ("r" in superscript) with "Dr" ("r" not in superscript) in a Word document. Thanks to all.
user avatar
0 votes
1 answer
28 views

Add incrementally ascending numbers in Word find and replace

Is there any way to add ascending numbers in "find and replace" in Word - Office 365 for Mac? I would like to add a number to every ocurrence of a word. For example I want to replace: In ...
user avatar
1 vote
1 answer
37 views

Extract/Replace and Convert string in Notepad++

i have a file looking like this: Line 207: ["Mystic Scroll: Shock and Swarm"] = { Line 297: ["Mystic Scroll: Concentrated Solar Beam"] = { Line 474: ["Mystic ...
user avatar
  • 13
0 votes
1 answer
42 views

Finding and replacing " with « in Microsoft Word

I'm using macOS version of Microsoft Word (2019). Been doing my final uni project for the last 3 months. Ended up with doing quoting wrong all along I used " in the entire document while should'...
user avatar
  • 113
1 vote
1 answer
28 views

Searching for multiple line breaks in Notepad++

I have a large text file that I am editing in Notepad++ and want to search for all instances where there are two line breaks and a particular string of characters on the following line (i.e., two left ...
user avatar
0 votes
2 answers
166 views

Powershell: How do I shift a date (format: yyyymmdd) from any position in the file name to end of the file name?

Currently im using dir | Rename-Item -NewName {$_.name -replace "",""} to rename files in a directory. The file names vary and need to be unified. Examples for file names: ...
user avatar
-1 votes
2 answers
77 views

I have a list of searching word. How to replace them in another file?

I'm sure this question is asked multiple times, but I fail to find it. Basically I have a text file, and a list of all search strings (e.g. cat, dog, banana, etc). I want all occurrences of those ...
user avatar
  • 1,761
1 vote
0 answers
28 views

Remove lines with less than X number of letters from Microsoft Word (2016 or higher)?

I'm using MS office 365. I have a big MS word document containing more than 10000 lines. The document has some meaningless lines that contain meaningless alphabet letters, unknown Asian letters, ...
user avatar
  • 125
0 votes
0 answers
126 views

Word VBA select all left indented paragraphs to format text

I want to change the font colour of all left indented paragraphs (in documents exported as rtf from another program). The paragraphs dialog shows they are all indented by 7.94 cm. I have done this by ...
user avatar
0 votes
1 answer
71 views

Find and replace from a different text document from each new line

I have some file conversion software that which works through cmd and doing something along the lines of: converter.exe input.wav -o output.wav --ffmpeg "-af volume=0.1" I'm trying to ...
user avatar
0 votes
0 answers
13 views

Recursive search and replace of all files insubfolder, with counter to id changes

I looked at most questions here, and i dont hink my question came up: I have 80 occurences of a certain string in my project, and would like to mark each occurence with an id-tag, e.g. a incrementing ...
user avatar
0 votes
1 answer
32 views

Remove specific text separated with comma

I have srt file containing following text 1 00:00:06,139 --> 00:00:07,140 F/6.3, SS 800, ISO 200, EV 0, GPS (76.2463, 25.7251, 16), D 93.74m, H 35.00m, H.S 2.09m/s, V.S 0.10m/s 2 00:00:07,140 --&...
user avatar
1 vote
2 answers
45 views

How to change random domains to a simple domain using Notepad++

I have a file with a random domains like this: host-name estkowjf.tradicebk.cz domain-key smtp,*,/home/pmta/keys/dkim.pem </virtual-mta>...
user avatar
0 votes
2 answers
77 views

notepad ++ Help need to split groups of 4,6,8 digits to groups of 2

I have some data and would like to split the groups of 4,6 and 8 digits into groups of 2 3 16 53 7282 192331 68 83 9 29364255 00001 4 10 57 7188 6 3943 6574 1228 4558 79 00002 2 415266 80 142433 7887 ...
user avatar
  • 1
1 vote
2 answers
64 views

Remove all spaces and tabs from ONLY specified segment line?

I use Notepad++ v8.1.1. How to find a specific segment and remove all spaces and tabs from ONLY that segment? E.g. I want to find all "EQD" lines and remove all spaces and tabs from JUST ...
user avatar
2 votes
2 answers
2k views

Regular Expression To Match Multiple Lines Of Text

I am trying to match lines that start with and end with the following tags using regular expressions: <Description> </Description> Inbetween the tags, there can be multiple lines of text, ...
user avatar
  • 35
1 vote
1 answer
85 views

Regular Expression To Find And Replace Text

A file has hundreds of lines of text similar to the one below: <Random Variable1="test" Description="this is a random description" number="12345" /> The value &...
user avatar
  • 35
0 votes
1 answer
31 views

Inject a page break before numbered list in MS word

I have a document with 70+ questions in it. Most of the questions were numbered using MS Word's numbered list. I need to inject a page break before each of these questions so that they are on their ...
user avatar
0 votes
1 answer
34 views

Find characters that are NOT in a specific font, colour or size with MS Word's find/replace panel

MS Word allows you to search for characters that are in a specific format (font, colour, size, etc.). Would it be possible, in a similar way, to find characters in a document that are not in a ...
user avatar
0 votes
0 answers
25 views

MS Word: Remove all continuous section breaks but keep next-page section breaks

I have a 600-page Word file that was originally written in WordPerfect (which I don’t have) and then exported to a .doc file by the author (who’s not technical at all). Presumably because of this ...
user avatar
1 vote
1 answer
638 views

How can I “replace all” in Acrobat Pro DC?

How can I "replace all" in Acrobat Pro DC? I can only find "replace":
user avatar
0 votes
2 answers
378 views

How to extract numbers from string and separate them by comma (or other separator) (substitute, replace, erase, isnumber, remove, delete, ...)

I need to extract numbers from a string in Excel and the numbers need to be separated by a comma as shown in row 3 (or any other separator). I can extract the numbers in row 1 by: =SUMPRODUCT(MID(0&...
user avatar
0 votes
3 answers
265 views

How do I remove the blank spaces before a certain character using notepad++

I want to remove the spaces before the ".V" if posible. How do I do that with the replace feature in Notepad ++ For Example, I want this: A .V Armor Minerals Inc AAC-P .V Anacott ...
user avatar
0 votes
0 answers
19 views

"Find and Select" feature can't discover specific Fill and Font Color Combinations [Excel]

I have been using the "Find and Select" feature in Excel, and I have discovered there are specific cell formats (i.e. specific Fill Color and Font Color combinations) that Excel is unable to ...
user avatar
2 votes
2 answers
2k views

Notepad++: Add leading zero(s) to lines but up to 9 digits

I have these numbers 94349850 999445183 999445183 94173345 54303954 42588251 150425435 74140053 1234547 12345678 123456789 I need them to be exactly 9 digits and if any is not then to add a leading ...
user avatar
0 votes
1 answer
33 views

How do I selectively change numbers to subscript as part of chemical names?

Sometimes I have to typeset, correct, or otherwise format papers by other people. These papers sometimes lack the proper formatting for chemical names. For example, H2O2 may have been written as H2O2. ...
user avatar
0 votes
2 answers
305 views

(vim) How to remove word that has a specified character?

so I tried to remove any word that has a letter "a" in it with vim I want to change this string hotel echo lima lima oscar whiskey oscar romeo lima delta to hotel echo whiskey romeo I hope I ...
user avatar
1 vote
1 answer
167 views

How to find "#VALUE" cells in Excel?

In Excel 2007 I have two sheets: sheets1 with data sheets2 links with some formulas data from sheets1 If a formula does not work in sheets2 I have cell that shows #VALUE!, but in the bar I can see ...
user avatar
  • 746
1 vote
0 answers
47 views

Word replacement between symbols

I have a translation file that looks like this: Apple=Apfel Banana=Banane Cherry=Kirsche Train=Zug ...500+ more lines like that now I have a file I need to work on with text. Only certain parts of ...
user avatar
  • 35
2 votes
1 answer
124 views

Replace [[Word]] with a word from another file

I have a translation file that looks like this: Apple=Apfel Banana=Banane Cherry=Kirsche Train=Zug ...500+ more lines like that now I have a file I need to work on with text. Only certain parts of ...
user avatar
0 votes
0 answers
32 views

What on earth is Microsoft Word wildcard search * replace doing in this case?

I'm trying to get Microsoft Word wildcard search and replace to add <b> on either side of blocks of bold-formatted characters. I've tried many things, none of which have done quite what I need, ...
user avatar
  • 143
1 vote
1 answer
233 views

Replace attribute of XML parent node with values from child node

I have an xml file where I want to replace text in a parent node with some text from the child node. This is an example xml: <output name="Element_152"> <field name="NAME&...
user avatar
1 vote
1 answer
49 views

Microsoft wild cards - find words with different endings but next to each other

Aim Hi folks, I am building an Index and I am trying to search for two-word phrases but with declinations in MS Word. So what I want to find is two words next to each other with fixed beginnings but ...
user avatar
1 vote
2 answers
205 views

Notepad ++ Change last name from Upper case to Proper case

Hi I would like to replace all the "last name" instances in my text file from full upper case to Proper case. DOE to Doe or IPSUM to Ipsum as you can see below Name = John DOE Random info 1 ...
user avatar
  • 13
0 votes
1 answer
62 views

Replace certain text string within quotation in Microsoft Word

For example: "I elaborate this as bla," Caesar said. Then, Alexis elaborate, "This only elaborate that bla." I would like to replace all elaborate strings inside the quotation to ...
user avatar
0 votes
1 answer
525 views

Trying to replace multiple strings in Notepad++ from a file

What I am doing is looking at multiple large text files, in these text files are common strings that need to be replaced. If it was a handful of instances I could use the Replace function, but I have ...
user avatar
  • 1
0 votes
1 answer
45 views

Continue add selected php in large value

I have a large amount of code in notepad++ or any editor but I want to replace all the text quickly. Is there any option edit and replace in notepad++? <option value="0&...
user avatar
1 vote
1 answer
60 views

Delete trailing hashes in a list of URLs using powershell?

I got a bit rusty with PowerShell, and I am missing the correct search terms, so I hoping asking here is ok. I have list of URL of the following structure: /pub/pdf/ssm.supervisorymanual.en.pdf?...
user avatar
  • 204
1 vote
0 answers
126 views

VBA Replace cell if it contains certain text in a given column

I'm an absolute beginner at VBA and need some help with find and replace automation. I need a code that that can find cells in a column that contain certain partial text and replace that cell with a ...
user avatar
0 votes
1 answer
20 views

Replace multiple occurences of a string in cells

Is it possible to replace a certain string that can occur multiple times in a single cell, but also in multiple cells? I'd like to prefix the first character / with another string :: in comma ...
user avatar
  • 113
0 votes
2 answers
50 views

Word find/replace with wildcards

Using Word 2010. I'm using wildcards to find a string -- 4 digit year inside parentheses. ([(])([0-9]{4})([)]) I want to replace with a line break (or paragraph, CR, etc.) BEFORE the string + the ...
user avatar
  • 1
1 vote
3 answers
240 views

Using Notepad ++ I need to remove all text except specific words

Example: Line 1 is this Adobe Ceiling EngramEntry_AdobeCeiling_C 106 5 15 I want to take out everything except : EngramEntry_AdobeCeiling_C
user avatar
1 vote
1 answer
52 views

Automatically Find/Replace fixed set of phrases in Word

I want to perform the following Find/Replace operations (or equivalent) in Word: For example: End of sentence: also `.`, `?`, `!` 1. `. ` by `.` (xInf) 2. `.` by `. ` 3. ` .` by `.` (xInf) ...
user avatar
1 vote
2 answers
26 views

How to make my last Worlds copy to the first in notepad++

So i need help I want to copy all my last word to the first word example: ^=/system/priv-app/Hearingdro_Tablet_V4_N ^=/system/priv-app/SetupWizard ^=/system/priv-app/ANTRadioService to: ...
user avatar
0 votes
1 answer
34 views

Is there a difference between using 2 slashes and using 1 slash when replacing one pattern by another in a string in bash?

Given the following strings in bash original="a bird flew in my window" old="a" new="the" the following, using 2 slashes after original result=${original//$old/$new} ...
user avatar
0 votes
0 answers
127 views

Regular expression to match blocks of { } in JSON

I have the following piece of JSON that occurs on about a hundred and fifty files in an application I am working on. { path: "/cms/scenarios/:scenarioId/impacts/add", ...
user avatar
0 votes
1 answer
39 views

RegEx. Is it possible to create search patterns that set different groups in different lines?

I would like to have one search pattern that searches for different strings across different lines. code: M90 G90 G71 G75 G00 G97 S16000 G00 T1 G00 X123.4437 Y149.1445 Z-12.0 M12 G00 G01 Z1.5 F50.0 ...
user avatar

1
2 3 4 5
13