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

learn more… | top users | synonyms (1)

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
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
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
53 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 ...
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
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
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
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
59 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 ...
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: ...
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
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 ...
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 ...
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 ...
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
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 ...
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
101 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
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 ...
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 .}
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
54 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 ...
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 ...
1
vote
1answer
24 views

Vim replace occurences of word with and without first capitalized in one S&R command

eg I have this peace of Java code public String setType(String newType) { this.type = newType: } I select all of it and I would like to search and replace type by model, but regardless of the ...
0
votes
0answers
12 views

Upping all seconds of X value

I have a subtitles file. What regex should I use in Notepad++ to up every line of 2 seconds? 00:01:15,444 --> 00:01:17,613 should become 00:01:17,444 --> 00:01:19,613
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> ...
0
votes
2answers
20 views

Notepad ++ : How to Replace as the description

I have lines like these abye/>abye abys/>abys aced/>aced aces/>aces I want it like this abye abys aced aces Is it possible? If it is then please someone show me the way.
1
vote
1answer
49 views

Multiple Find/Replace queries over multiple files: replace one by one

What I want is this (Software can run on Linux or Windows, both are available): Supply a list of files in which strings should be replaced (wildcards ideal, but not mandatory) Supply a list of ...
0
votes
0answers
7 views

Find/Replace high lighting

The default high-lighting that MS Office Excel uses when it 'Finds' a cell is too hard to read. Can it be automatically BOLDed or automatically highlighted, and go away when ending Find/Replace?
0
votes
2answers
40 views

How can I perform search & replace in a text file based on conditions?

I have a large text file (.bib) with lots of double entries for some fields. Essentially, the file is a .bib-file (more info here) which has roughly 1000 entries. The content is structured like this: ...
0
votes
1answer
31 views

How to update range of columns in excel

I have an excel sheet where from one sheets's Id used as reference in next sheet. The Id's are sequential. Like this : Sheet 1 Sheet 2 ID Name ID Sheet_1_ID Text 1 ...
1
vote
1answer
21 views

Expression help for Find and Replace in Notepad++ please

how to replace and but symbol (,) after second number between every five numbers by using replace in notepad++ ? replace 00:00:26092 --> 00:00:30552 00:00:36770 --> 00:00:39933 00:00:40040 ...
1
vote
1answer
121 views

Remove CR LF for all lines that are not followed by a specific number

I have 14000+ lines of a database, that I want to edit with Notepad++. All these lines should start with 1000 and I therefore want to delete CR LF at the end of those lines that are not followed by ...
0
votes
1answer
102 views

Notepad++ : Do batch text replace

I'm trying to create a dictionary file from several webpages I found online. The dictionary indexes headwords so that they can be easily found in search mode. The information in the webpage is divided ...
0
votes
1answer
77 views

Using Notepad++ search/replace PHP code with regexp

I don't have experience in regexp so I hope someone will able to help me to change faster than by hands Need to replace objects to arrays like $variable -> child; OR $variable->child to ...
0
votes
1answer
61 views

How can I delete before and after EMAIL in notepad++?

I have this: :814, 'pera', 'name1@gmail.com', '2ed', '', 'da', 0.00, '195..110.18'), >815, 'danka', 'name2@gmail.com', 'd3d6', '0655566', 'da', 0.00, '212..65.82'), *816, 'ana', ...
1
vote
1answer
196 views

Remove duplicate lines in LibreOffice / OpenOffice Writer

I'm working on a text file in Writer which is basically a sorted list of words and phrases. It contains some duplicates I want to remove. Normally I would use a regular expression in Search & ...
1
vote
1answer
85 views

Non case sensitive search case sensitive replace

How do I search/and replace like this using sed or another tool FOO => BAR Foo => Bar foo => bar That is: Look for foo regardless of case, and replace with the same case pattern. One ...
2
votes
0answers
71 views

How to find and replace hyphens with minus signs in Microsoft Word 2013?

When editing scientific texts, I often have to replace hyphens incorrectly used as minus signs with proper minus signs (i.e. U+2212). I'm working in Microsoft Word 2013 and trying to use a wildcard ...
2
votes
2answers
46 views

Find & replace on a folder of .txt (but only first 1-3 lines)

I have a folder of .txt files. They all look like this: Title: Title of blog post. Tags: tag1,tag2,tag3 Text on the post. Just my thoughts. > A blockqoute Written in *markdown.* Using ...
2
votes
1answer
143 views

Delete text in excel cell with certain format

How do I easily delete strings in excel cells with certain formatting.I want to get cell with formatted string deleted like the second cell The string could be anything the only thing that define ...
0
votes
1answer
73 views

How can I do a recursive find and replace from the command shell?

Using a shell like bash or zshell, how can I do a recursive 'find and replace'? In other words, I want to replace every occurrence of '/path/to/folder' with '/other/dir' in all files in this directory ...