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

learn more… | top users | synonyms (1)

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
2answers
65 views

Search Replace extended in a html file

i have a little question. I have a big html file and want to replace lots of things inside a lot of times. The only problem i cant solve is a replace with a variable. Example: <image ...
-1
votes
2answers
54 views

How to delete word and all words after that

I have this URL: https://www.facebook.com/photo.php?fbid=611377065590688&set=a.320150204713377.74079.229899403738458&type=1 I want to be: ...
-1
votes
2answers
41 views

Adding characters at the end of multiple lines [closed]

What I have: hello What I want: hello1 hello2 hello3 hello4 hello5 But with around 1500 numbers and the word isn't hello. I want to use Notepad++ for this. I don't wanna have to do find: $ replace ...
3
votes
2answers
576 views

Microsoft Project 2003 - How to do a “find” in non-expanded nodes?

I am using Microsoft Project 2003 find command. When I choose ctrl+f and type a string to search for, MS Project only appears to search tree nodes that are expanded. Is there a way to get MS Project ...
1
vote
1answer
22 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
11 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
2answers
19 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
2k views

How can I remove unicode characters in a Microsoft Word document?

I'm saving a Microsoft Word document as a PDF but it is warning me that there are a few problems including the fact that the document includes Unicode characters. I'm not sure what characters it is ...
1
vote
1answer
40 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?
1
vote
2answers
193 views

How can I remove certain parts of a word document?

I have a word document filled with Physics equations and annotations. I want another word document to be a copy of the first document but with the annotations removed. I have all the annotations in ...
0
votes
2answers
38 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: ...
2
votes
1answer
4k views

Notepad++ excluding find filters

In Notepad++ I want to search in all file types except one. For instance: I want to search in all files but not .class files. Can the Notepad++ filter can be configured to work this way?
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
18 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
87 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
81 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
65 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
48 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
60 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 ...
0
votes
1answer
371 views

Script for modifying file content in specified files

I tried searching previous questions but none worked, or I couldn't adapt them to my needs. I want to write a script that asks for: folder criteria old string new string And replace every file in ...
1
vote
1answer
125 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 & ...
9
votes
3answers
3k views

Search and replace tool that can handle multiple files and subfolders [closed]

I'm looking for a tool which can search/replace within file contents for a broad range of file types (i.e. it should, if possible, process the maximum possible number of file types like .txt, .sql, ...
-1
votes
2answers
22 views

Change Identical Code Strings in Multiple, Separate Files in One Command

How can I change strings of code in multiple HTML documents which are all identical, to something else? How can I change this: File A: code1 File B: code1 File C: code1 ... Into this: File A: code2 ...
2
votes
0answers
53 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
45 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
106 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
59 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 ...
-2
votes
1answer
32 views

Inserting line before lines containing a particular word

How to insert a line before a line ending with a certain word in textpad? For eg: I want to insert a blank line before every line that ends with the word 'Chapter'
4
votes
2answers
501 views

shell script to replace a keyword in a file with the contents of another file

I'm to create a .sh to replace a specific keyword in a file using the contents of an other file. template.html contains a unique string "PLACEHOLDER" it must be replaced with the contents of file ...
0
votes
1answer
755 views

How do I find and replace 'whole words only', in Microsoft Word?

I want to be able to find and replace eat with Eat in Microsoft Word 2007. However, I don’t want to replace every occurrence of eat such as those that can be found inside other words such as great and ...
2
votes
3answers
455 views

Word find/replace: add space to postal code with wildcards

Using the “Find and Replace” dialog in Microsoft Word 2003, I want to search a list of addresses for postal codes (Canadian) that do not have a space in them, e.g., M2N3X6 L4C2A9 K5G1S7 and put a ...
0
votes
1answer
61 views

Selective Find & Replace to pretty up my C code in Eclipse or Notepad++

I am working on a old C code which have debug statments like this: debug(1, "SomeDebugStmt %s %d", someString, someNumber); ... debug(2, "another SomeDebugStmt number 2 %s %d", anotherString, ...
1
vote
1answer
217 views

How can I replace “/>XXXXX”/> with "/> within a selection

I have a CSV file which I am editing with Notepad++. There is a section of about 500 consecutive lines where I want to replace "/>XXXXX"/> with "/> where XXXXX are numbers. Is there a way to ...
9
votes
2answers
11k 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 ...
2
votes
1answer
311 views

Use perl to do multi-line replacement [closed]

I have to do some replacements in many *.c files. I want to do the replacement like this: original: printf("This is a string! %d %d\n", 1, 2); result: print_record("This is a string! %d %d", 1, 2); ...
0
votes
0answers
250 views

Can't Find/Find&Replace “Purple, Accent 4, Lighter 40%”, all other colors work - Excel 2007

I have a several large Excel tables that I am managing for my current project. Whenever a metric or value in the table changes, I indicate the change by changing the background color of the cell for ...
8
votes
5answers
21k views

How do I find and replace a character in filenames in Windows 7 using Explorer?

I want to replace all the underscore characters (_) with a space () in a filename. How can I do this quickly, when I have lots of _ characters to replace?
1
vote
1answer
2k views

Is there a GUI in Ubuntu for folder based find and replace?

Is there a GUI in Ubuntu for directory based mass find and replace? Preferrably one that works similar to Adobe Dreamweaver's find and replace system.
0
votes
0answers
66 views

Search and replace with different formatting style

In LibreOffice or OpenOffice Calc spreadsheet, is it possible to search-replace while changing formatting of the replacement text to subscript or superscript at the same time? I have a spreadsheet ...
0
votes
1answer
32 views

replacing 2 different words with each other [closed]

I want to replace 2 different text sentences with each other using only Find and Replace which you find amongst the most common word processing packages. For example let say I want to replace: ...
3
votes
2answers
230 views

How to format a string substitute, or a text line, in Vim?

Is it possible to format the replacement string when substituting a match with Vim? Say I have a file with a 2-column table, where the entries in each row are separated with a space. The entries (and ...
4
votes
4answers
2k views

What's the best way to find and replace text in multiple files over FTP?

How can you search and replace text in multiple files on an FTP server? Basically I need to change the Google Analytics information on a bunch of plain old HTML pages and I'm wondering if there is a ...
0
votes
1answer
77 views

Handling punctuation in text pattern with vim search/replace

In vim we have the :substitute command that searches for a text pattern and replaces it with a text string. How does one handle a text pattern with punctuation in it? Minimum working example: the ...
19
votes
1answer
12k views

Search and replace with TAB character in Sublime Text 2

In Sublime Text 2, I want search and replace by the TAB character. I tried replacing with \t char but it's not working. How can I do it?
1
vote
1answer
80 views

Matching html paragraphs with at least one word in all caps

Using regex or anything, I need to match any paragraph which contains at least one all caps word. Then transform it into a header and capitalise all the content of the title. In the example below, ...
2
votes
2answers
259 views

Remove colons (:) from illustration index in Microsoft Word 2010?

How can I remove all the : from illustration index in Word 2010? FIG. 2.4: Representação em RDF/XML da FIG. 2.3 27 FIG. 2.5: Ilustração da Utilização do RDF com o RDFS 28 But I need this: FIG. ...
2
votes
1answer
65 views

How can I add an additional line break (paragraph return) to each line break found in an Open Office Document?

I have tons of text that runs together paragraph breaks like so: off the wounded, and with the same calmness and composure as before resumed the watch over his armor. But these freaks of his guest ...
1
vote
2answers
226 views

How Do You Replace Individual Periods/Full Stops Without Replacing Decimal Points?

A bit of an awkward one, this; I've been gathering data using an eye-tracker, which gives its output as .txt files (Excel is also an option but there are too many samples so notepad it is). I need to ...