tagged [replace]

How to replace text in a string column of a Pandas dataframe?

How to replace text in a string column of a Pandas dataframe? I have a column in my dataframe like this: and I want to replace the `,` comma with `-` dash. I'm currently using this method but nothing ...

21 Dec at 22:11

How to find and replace all occurrences of a string recursively in a directory tree?

How to find and replace all occurrences of a string recursively in a directory tree? Using just grep and sed, how do I replace all occurrences of: with within a text file under the `/home/user/` direc...

18 Oct at 19:42

Multiple REPLACE function in Oracle

Multiple REPLACE function in Oracle I am using the `REPLACE` function in oracle to replace values in my string like; So this is OK to replace one value, but what about 20+, should I use 20+ `REPLACE` ...

1 Jun at 06:18

Alternative to String.Replace

Alternative to String.Replace So I was writing some code today that basically looks like this: ``` string returnString = s.Replace("!", " ") .Replace("@", " ") .Replace("#", " ") .Re...

16 Dec at 23:29

What would be the fastest way to remove Newlines from a String in C#?

What would be the fastest way to remove Newlines from a String in C#? I have a string that has some Environment.Newline in it. I'd like to strip those from the string and instead, replace the Newline ...

20 Nov at 11:39

Is this possible with regular expressions?

Is this possible with regular expressions? Something like this: The idea is that `a` will get replaced with `e`, `b` with `f`, `c` with `g` and so on. Ideally, this should be language independent. If ...

18 Dec at 03:45

How to replace straight quotation mark (")

How to replace straight quotation mark (") I would like to replace a straight quotation mark (") using C#. I might be missing something small, but I can't get it with a normal `string.Replace();` `som...

28 Oct at 04:32

jQuery if div contains this text, replace that part of the text

jQuery if div contains this text, replace that part of the text Like the title says, I want to replace a specific part of the text in a div. The structure looks like this: And I want to replace only "...

4 Jul at 07:43

php Replacing multiple spaces with a single space

php Replacing multiple spaces with a single space I'm trying to replace multiple spaces with a single space. When I use `ereg_replace`, I get an error about it being deprecated. Is there an identical ...

Replace sequence of bytes in binary file

Replace sequence of bytes in binary file What is the best method to replace sequence of bytes in binary file to the same length of other bytes? The binary files will be pretty large, about 50 mb and s...

29 Jun at 18:48

MySQL string replace

MySQL string replace I have a column containing urls (id, url): I'd like to change the word "updates" to "news". Is it possible to do this with a scrip

17 Aug at 22:48

Pandas - Replace values based on index

Pandas - Replace values based on index If I create a dataframe like so: How would I change the entry in column A to be the number 16 from row 0 -15, for example? In other words, how do I replace cells...

14 Feb at 13:44

How can I get at the matches when using preg_replace in PHP?

How can I get at the matches when using preg_replace in PHP? I am trying to grab the capital letters of a couple of words and wrap them in span tags. I am using [preg_replace](http://php.net/manual/en...

29 Jul at 22:9

C# replace string in string

C# replace string in string Is it possible to replace a substring in a string without assigning a return value? I have a string: And I want to replace the substring `[REPLACE]` with something else: Th...

20 Jul at 18:15

jQuery remove special characters from string and more

jQuery remove special characters from string and more I have a string like this: What I would like to do is removing all special characters from the above string and replace spaces and in case they ar...

23 Jan at 22:51

How to remove any URL within a string in Python

How to remove any URL within a string in Python I want to remove all URLs inside a string (replace them with "") I searched around but couldn't really find what I want. Example: I want the result to b...

4 Jul at 15:30

How to search for occurrences of more than one space between words in a line

How to search for occurrences of more than one space between words in a line How to search for occurrences of more than one space between words in a line All the above are valid matches for this regex...

9 Mar at 17:2

Replace specific characters within strings

Replace specific characters within strings I would like to remove specific characters from strings within a vector, similar to the feature in Excel. Here are the data I start with: ``` group

Can I replace groups in Java regex?

Can I replace groups in Java regex? I have this code, and I want to know, if I can replace only groups (not all pattern) in Java regex. Code: ``` //... Pattern p = Pattern.compile("(\\d).*(\\d)"); S...

21 Nov at 06:45

Replacing double quote with a single quote

Replacing double quote with a single quote I have the following string in c#: `ptFirstName` returns: `"John"` I wish to convert this to `'John'` I have tried numerous variations of the following, but ...

17 Mar at 01:29

How to Replace by pattern with Regex in C#

How to Replace by pattern with Regex in C# I have a text, the text contains char sequence which begins with # and ends with ="" characters. Between the # and ="" characters just exists alphanumeric ch...

24 Oct at 07:20

How to replace multiple substrings of a string?

How to replace multiple substrings of a string? I would like to use the .replace function to replace multiple strings. I currently have but would like to have something like although that does not fe...

8 Dec at 16:57

Removing spaces from string

Removing spaces from string I'm trying to remove all the spaces from a string derived from user input, but for some reason it isn't working for me. Here is my code. ``` public void onClick(View src) {...

11 Nov at 15:59

Replace all values in a matrix <0.1 with 0

Replace all values in a matrix

19 Sep at 08:10

How to find and replace with regex in excel

How to find and replace with regex in excel I have an excel file with 1 column and multiple rows. The rows contain various text, here's an example: I want to replace "texts are *" where * is anything ...

15 Jan at 20:45

Replace the string of special characters in C#

Replace the string of special characters in C# My requirement is: > I have to replace some special characters like * ' " , _ & # ^ @ with `string.Empty`, and I have to replace blank spaces with `-`. T...

29 Mar at 18:0

Replace None with NaN in pandas dataframe

Replace None with NaN in pandas dataframe I have table `x`: I want to replace python None with pandas NaN. I tried: But I got: ``` TypeError: 'regex' must be a string or a compiled regular expression ...

14 May at 03:8

How can I use a dictionary to do multiple search-and-replace operations?

How can I use a dictionary to do multiple search-and-replace operations? I have to replace text like "north", "south", etc. with "N", "S" etc. in address fields. I thought of making a dictionary to ho...

4 Feb at 18:3

Find and replace with sed in directory and sub directories

Find and replace with sed in directory and sub directories I run this command to find and replace all occurrences of 'apple' with 'orange' in all files in root of my site: But it doesn't go through su...

9 Mar at 15:51

How to replace a character by a newline in Vim

How to replace a character by a newline in Vim I'm trying to replace each `,` in the current file by a new line: But it inserts what looks like a `^@` instead of an actual newline. The file is not in ...

12 Apr at 13:18

Remove multiple whitespaces

Remove multiple whitespaces I'm getting `$row['message']` from a MySQL database and I need to remove all whitespace like `\n` `\t` and so on. should be formatted to: I tried: b

Java how to replace 2 or more spaces with single space in string and delete leading and trailing spaces

Java how to replace 2 or more spaces with single space in string and delete leading and trailing spaces Looking for quick, simple way in Java to change this string to something that looks like this wh...

4 Sep at 05:0

How to replace space with comma using sed?

How to replace space with comma using sed? I would like to replace the empty space between each and every field with comma delimiter.Could someone let me know how can I do this.I tried the below comma...

24 Jun at 05:59

regex string replace

regex string replace I am trying to do a basic string replace using a regex expression, but the answers I have found do not seem to help - they are directly answering each persons unique requirement w...

4 May at 08:59

How to delete all instances of a character in a string in python?

How to delete all instances of a character in a string in python? How do I delete all the instances of a character in this string? Here is my code: However, if I run this, this is what happens: ``` >>...

5 Mar at 02:23

String replace method is not replacing characters

String replace method is not replacing characters I have a sentence that is passed in as a string and I am doing a replace on the word "and" and I want to replace it with " ". And it's not replacing t...

13 Jul at 12:21

Replace CRLF using powershell

Replace CRLF using powershell Here is my powershell script: ``` $original_file ='C:\Users\abc\Desktop\File\abc.txt' (Get-Content $original_file) | Foreach-Object { $_ -replace "'", "2"` -replace '2', ...

22 Feb at 04:19

How do I perform a Perl substitution on a string while keeping the original?

How do I perform a Perl substitution on a string while keeping the original? In Perl, what is a good way to perform a replacement on a string using a regular expression and store the value in a differ...

1 Aug at 18:12

How to replace an entire line in a text file by line number

How to replace an entire line in a text file by line number I have a situation where I want a bash script to replace an entire line in a file. The line number is always the same, so that can be a hard...

19 Apr at 21:54

How do I replace an actual asterisk character (*) in a Regex expression?

How do I replace an actual asterisk character (*) in a Regex expression? I have a statement: I have a string such as I want to search and replace it with so when I am done the string contains this: My...

10 May at 22:13

Replace/Remove characters that do not match the Regular Expression (.NET)

Replace/Remove characters that do not match the Regular Expression (.NET) I have a regular expression to validate a string. But now I want to remove all the characters that do not match my regular exp...

27 May at 15:49

Replacing multiple characters in a string in c# by a one liner

Replacing multiple characters in a string in c# by a one liner What I'm wondering of is whether it is possible to replace multiple characters in a string (lets say, the &, | and $ characters for examp...

30 Jul at 08:14

How to remove a pattern from a string using Regex

How to remove a pattern from a string using Regex I want to find paths from a string and remove them, e.g.: ``` string1 = "'c:\a\b\c'!MyUDF(param1, param2,..) + 'c:\a\b\c'!MyUDF(param3, param4,..)..."...

10 Feb at 22:43

Using tr to replace newline with space

Using tr to replace newline with space Have output from `sed`: Those two strings should be merged into one and separated with space like: Two strings are pipelined to `tr` in order to replace newline ...

7 Mar at 01:53

Replace all occurences of a string from a string array

Replace all occurences of a string from a string array I have a string array like: I would like to replace all ones with zero at once. Then items should be: `{"zero","two","three","zero","two","zero"}...

8 Jan at 22:13

How to remove spaces and newlines in a string

How to remove spaces and newlines in a string sorry if they are not very practical for C # Asp.Net, I hope to make me understand I have this situation I would make sure that the string does not contai...

9 Jan at 10:19

How to use named groups when performing a Regex.Replace()

How to use named groups when performing a Regex.Replace() How do I use named captures when performing Regex.Replace? I have gotten this far and it does what I want but not in the way I want it: ``` [T...

18 Oct at 19:19

C# String replace with dictionary

C# String replace with dictionary I have a string on which I need to do some replacements. I have a `Dictionary` where I have search-replace pairs defined. I have created following extension methods t...

5 Aug at 07:58

Turning a single quote into an escaped single quote within a string

Turning a single quote into an escaped single quote within a string It pains me to ask this, but, for some reason I have not been able to get this to work (it's late in the day, yes, that's my excuse)...

23 May at 22:10

Quickly replace first line of large file

Quickly replace first line of large file I have many large csv files (1-10 gb each) which I'm importing into databases. For each file, I need to replace the 1st line so I can format the headers to be ...

6 Dec at 16:39