Fastest way to remove 'extra' spaces (more than 1) from a large range of cells using VBA for excel

excel-vba,replace,trim,spaces

The loop is killing you. This will remove spaces in an entire column in one shot: Sub SpaceKiller() Worksheets("Sheet1").Columns("A").Replace _ What:=" ", _ Replacement:="", _ SearchOrder:=xlByColumns, _ MatchCase:=True End Sub Adjust the range to suit. If you want to remove double spaces, then: Sub SpaceKiller() Worksheets("Sheet1").Columns("A").Replace _ What:=" ", _...

Replacing alternate spaces with newline?

unix,replace

awk might help in this case: echo "0 1 2 3 4 5" | awk ' { for (i=1; i<=NF; i++) { if ((i-1)%2 == 0) { printf "%d ",$i; } else { print $i } } } ' We split by space and have 6 items. We, then, are...

find common string in two text files using batch script

string,parsing,batch-file,search,replace

Not sure about the requirements, but, maybe awk "{print $1}" 2.txt | findstr /g:/ /l /b 1.txt Without awk cmd /q /c"(for /f "usebackq" %%a in ("2.txt") do echo(%%a)" | findstr /g:/ /l /b 1.txt Only awk awk "{a[$1]=!a[$1]} !a[$1]" 2.txt 1.txt ...

Replace special qoutes with normal

vb.net,replace,utf-8

Unfortunately VB.NET doesn't support escape sequences but you can use ChrW() to specify code point: s = s.Replace(ChrW(&H201C), """") That's for “, code for ” is &H201D. Note that using code points you're free to search & replace any Unicode character (not just what VB.NET has an escape for -...

Calling bash function in perl find replace

bash,perl,replace

You don't need bash and unnecessary piping through multiple system utilities, perl -i -pe' BEGIN { @chars = ("a" .. "z", "A" .. "Z", 0 .. 9); push @chars, split //, "[email protected]#$%^&*()-_ []{}<>~\`+=,.;:/?|"; sub salt { join "", map $chars[ rand @chars ], 1 .. 64 } } s/put your...

Find and replace in an AS3 String

string,actionscript-3,replace,find

You need to mask "(" and "*" in your pattern: var pattern:RegExp = /\(\*/gi; ...

Search for string in file while ignoring id and replacing only a substring

python,regex,string,replace

One way to do this is to have a function for replacing text. The function would get the match object from re.sub and insert id captured from the string being replaced. import re s = 'ref_layerid_mapping="x4049" lyvis="off" toc_visible="off"' pat = re.compile(r'ref_layerid_mapping=(.+) lyvis="off" toc_visible="off"') def replacer(m): return "ref_layerid_mapping=" + m.group(1) +...

Replace All Words In Document Body Doesn't Work

javascript,replace

no need to iterate body element try this: want to change to with that js? i have used to make it function addTitleToSurveyUrls() { var elements = document.getElementsByTagName('a'); for(var el in elements) { var element = elements[el]; var href = element.getAttribute("href"); if(href.indexOf('survey_')>-1) { element.setAttribute('title', 'Some TITLE HERE'); } } }...

How to extract single-/multiline regex-matching items from an unpredictably formatted file and put each one in a single line into output file?

linux,shell,unix,replace,grep

Assuming that your document is well-formed, i.e. <b> opening tags always match with a </b> closing tag, then this may be what you need: sed '[email protected]<[/]\?b>@\n&\[email protected]' path/to/input.txt | awk 'BEGIN {buf=""} /<b>/ {Y=1; buf=""} /<\/b>/ {Y=0; print buf"</b>"} Y {buf = buf$0} ' | tr -s ' ' Output: <b>data1</b>...

Replace numbers with Boolean in r

r,csv,replace,weka

The function as.logical will coerce any non-zero number to TRUE and zero to FALSE. Assuming your CSV has been loaded into a data frame called boxdata with the same column names as in the CSV: ifelse(as.logical(boxdata$Receiver_TotalVideoDecoderErrors), 'Error', 'No error') Or you can use broadcasting to do the work for you....

jquery losing value of $(this) on ajax request [duplicate]

javascript,jquery,ajax,replace

You need to preserve $(this) in a variable for the callback like var $link = $(this); $.ajax({ type : "POST", cache : false, url : $(this).attr('href'), data : $(this).serialize(), success : function(data) { $('.loading-icon').hide(); $link.attr('href').replace(/delete/, 'add'); $link.removeClass('remove-favourite').addClass('add-favourite'); } }) this itself will have changed because the execution context of the...

Sphinxql Replace() function like mysql

replace,sphinx,sphinxql

ignore_chars seems to be a perfect fit for this... http://sphinxsearch.com/docs/current.html#conf-ignore-chars...

Extract Cells content in the first Excel File based on Worksheet in another File

excel,function,excel-vba,replace

This is the literal translation of what you shown : Sub MacroClear() Dim wbD As Workbook, _ wbC As Workbook, _ wsD As Worksheet, _ wsC As Worksheet, _ Dic() As String 'Replace the names in here with yours Set wbD = Workbooks("Dictionnary") Set wbC = Workbooks("FileToClean") Set wsD =...

Using R to repeatedly replace words

r,loops,replace

You could construct a simple loop and print using cat. for (i in 1:length(day)) { cat("Today is", day[i], "and it is a", weather[i], "day.\n") cat(day[i], "is a", weather[i], "day\n") } # Today is Monday and it is a sunny day. # Monday is a sunny day # Today is Tuesday...

Javascript Replace function not working on first instance

javascript,jquery,string,if-statement,replace

The problem is with the check of tagcounter <= 0. When you are checking that for the first time, tagcounter is still 1. You decrement it later. Hence the "+" never gets appended. Hence when you are trying to remove "+Light" it doesn't work because the "+" is not there...

Replace the characters in every line of a file, if it match a condition - Unix

unix,replace,sed,match,condition

There is no need to loop through the file with a bash loop. sed alone can handle it: $ sed -r '/^.{14}R.{12}D/s/(.{52}).{4}/\10000/' file 05196220141228R201412241308D201412200055SA1155WE130800001300SL07Y051 05196220141228R201412241308A201412220350SA0731SU1950LAX C00020202020 05196220141228R201412241308D201412200055SA1155WE130800005300SL07Y051 05196220141228N201412241308A201412240007TU0548WE1107MEL C00000000015 07054820141228N201412220850D201412180300TH1400MO085000040300UL180001 This uses the expression sed '/pattern/s/X/Y/' file:...

Regular expression, match error

regex,replace,match

You can dispense with most of your pattern - much of it is unnecessary. Try this: <img.*?> With the unnecessary brackets removed, the important change is adding ? to make it a reluctant quantifier - one that matches as little as possible....

Regex Lookahead/behind to find character unless followed by the same

regex,vb.net,replace,replaceall

Let me explain why your regex does not work. \\ - Matches \ (?=[0]) - Checks (not matches) if the next character is 0 (?<![\\]) - Checks (but not matches) if the preceding character (that is \) is not \. The last condition will always fail the match, as \...

How to alter dynamic/live element attributes - (replaceWith()) used

jquery,dynamic,replace,live

I think the only thing you're maybe not wrapping your head around is the idea of callbacks and asynchronous methods. You're currently running your console.log statements before the replaceWith occurs. The function() { } block (your "callback") passed as the second parameter to $.get doesn't execute until the AJAX call...

Replace text between two special characters

regex,r,text,replace

Try sub('(?<=").*(?=")', y, x, perl=TRUE) #[1] "\t\t<taxon id=\"TOT_A01\"/>" ...

Python: Replace “wrong” floats by integers inside string

python,string,replace,floating-point,integer

(?<=\d)\.0+\b You can simple use this and replace by empty string via re.sub. See demo. https://regex101.com/r/hI0qP0/22 import re p = re.compile(r'(?<=\d)\.0+\b') test_str = "15.0+abc-3" subst = "" result = re.sub(p, subst, test_str) ...

Replace values in column of a dataframe based on overlap with a vector

r,for-loop,replace

#addones lstcol <- list('cola', 'colb') lstvec <- list(veca, vecb) myfunc <- function(COL, VEC) { dataframe[[COL]][dataframe$ID %in% VEC] <<- 1 } for(i in 1:length(lstcol)) { myfunc(lstcol[[i]], lstvec[[i]]) } dataframe # ID cola colb colc cold cole colf #1 XXXYYY 1 0 0 0 0 0 #2 XXYYXX 1 0 0 0...

Splitting string before name of month with regex

python,regex,python-2.7,replace,data-cleaning

You should be able to do this with a one RegeEx for all months: import re lines = [ "Yes, I'd say so. Nov 08, 2014 UTC", "Hell yes! Oct 01, 2014 UTC" ] for ln in lines: print re.sub(r'(\w+\s\d{2}, \d{4} UTC)$', r'\t\1', ln) Which will return: Yes, I'd say...

Powershell For Loop, Replace, Split, Regex Matches

regex,powershell,replace,split

Leveraging the power in PowerShell we can turn the output of pnputil into an object array that will make it much easier to parse the data you are looking for (since it appears you are looking for something specific). Each entry is a group of variables with a blank line...

String.replace() isn't working like I expect

java,string,replace

The replace method isn't changing the contents of your string; Strings are immutable. It's returning a new string that contains the changed contents, but you've ignored the returned value. Change example.replace(oldNumber, newNumber); with example = example.replace(oldNumber, newNumber); ...

Swift - how to convert hyphen/minus sign into + sign

string,swift,replace,converter

tmpAddress = tmpAddress.stringByReplacingOccurrencesOfString("-", withString: "+") This replaces '-' with '+' The first parameter is the search string, and the second is the replacement string....

PHP Replace binary file at hex address [closed]

php,replace,binary,hex,preg-replace

If the string is at fixed position, you can write data directly: $position=hexdec("00010edb"); // You have to pre-calculate it once $data="some data"; // Replacement if ($f=fopen("your_file", "r+")) { fseek($f, $position); fwrite($f, $data); fclose($f); } else { echo "Can't open file"; } ...

LabVIEW variables Find and Replace

variables,replace,labview

You can rebind local variables from one control or indicator to another using VI Scripting. Place this code in a new VI: This opens a reference to the VI whose locals you want to rebind, gets a reference to the VI's front panel, gets a reference to the control on...

Looping Over a String Gives Segmentation Fault

c++,string,replace,lowercase

Turning on the warnings, you may spot the error yourself: g++ -o main main.cpp -Wall Errors: main.cpp: In function ‘std::string lowercase(std::string)’: main.cpp:9:21: warning: comparison between signed and unsigned integer expressions [-Wsign-compare] for (int i=0; i < ans.size(); i++) ^ main.cpp:14:1: warning: no return statement in function returning non-void [-Wreturn-type] }...

Is it possible to change ONE line in a txt file WITHOUT reading and writing the whole file (Java)?

java,file,text,replace,line

Short answer: no. Long answer: Not really. If you know that the text you're inserting directly replaces the text you're removing you could perform a substitution by seeking to the portion of the file, reading a small block, substituting the new text and replacing that block. This would work for...

RegEx replace returns unexpected result without .*

javascript,regex,replace,capture-group

I would do like, > "Apple Orange".replace(/(?:^|\s)([A-Z])|./g, "$1") 'AO' Don't complex the things. Just capture all the uppercase chars which exists just after to a space or at the start. And then match all the remaining characters. Now replace all the matched chars by $1. Note that all the matched...

Replace every occurence of [b: “text”] to text where text can be anything

javascript,regex,replace

You need to use a capturing group ((.*)) to match the text between the quotes and use that in your replacement. Note that if you have to handle escaped quotes inside the string or anything complex, you'll want to use a real parser rather than complicating the regex more (I'd...

Powershell variable in replacement string with named groups

regex,powershell,replace

@PetSerAl comment is correct, here is code to test it: $sep = "," "AAA BBB" -Replace '(?<A>\w+)\s+(?<B>\w+)',"`${A}$sep`${B}" Output: AAA,BBB Explanation: Powershell will evaluate the double quoted string, escaping the $ sign with a back tick will ensure these are not evaluated and a valid string is provided for the -Replace...

How to replace newlines/linebreaks with a single space, but only if they are inside of start/end regexes?

regex,linux,shell,unix,replace

You can do it using awk as: awk '/\[x/{f=1} {if(f)printf "%s",$0; else print $0;} /y\]/{print ""; f=0}' Output: [x data1 data2 data3 data4 y] [a data5 data 6 data7 data 8 b> [x data y] You can also simplify to: awk '/\[x/,/y\]/{ORS=""; if(/y\]/) ORS="\n";}{print}' Output: [x data1 data2 data3 data4...

String Replace Java Function

java,string,class,replace,bukkit

Your problem is, most likely, because you expect that your function mutates the original String you passed to the method. Strings are immutable in java, and besides, you cannot modify the original reference you pass to method from that method. To get the result you most likely expect, store returned...

Efficient means of mass converting >600,000 different find and replaces within one file

replace

Python code, assuming your substitutions are stored in subs.csv: import csv subs = dict(csv.reader(open('subs.csv'), delimiter='\t')) source = csv.reader(open('all_snp.map'), delimiter='\t') dest = csv.writer(open('all_snp_out.map', 'wb'), delimiter='\t') for row in source: row[1] = subs.get(row[1], row[1]) dest.writerow(row) The line row[1] = subs.get(row[1], row[1]): row[1] is the Affx column, and it replaces it with a...

Replace string if the string is not part of a larger string using regex in javascript

javascript,php,regex,string,replace

Something like this? ( °_• ) var txt="or some text or before (.)or(.) anywhere Or"; console.log(txt.replace(/\bor\b/gi,"OR")); // "OR some text OR before (.)OR(.) anywhere OR" ...

Regular expression to remove everything but words. java

java,regex,string,replace

public static String filter(String input) { return input.replaceAll("[^A-Za-z0-9' ]", "").replaceAll(" +", " "); } The first replace replaces all characters except alphabetic characters, the single-quote, and spaces. The second replace replaces all instances of one or more spaces, with a single space....

Replace list of emojies in JavaScript

javascript,jquery,regex,replace

join your array and create a single regex, then you can use replace with a callback function (or use the single line replace like in sln's answer) to create the spans Note this assumes all emoji names are between : var emojies = ["smile", "smiley", "grin", "joy"]; //Create a single...

Notepad++ - Find and replace both opening and closing tags while keeping the content intact?

regex,replace,notepad++

Find what: \\section\{(.+)\} Replace with: <h1>\1</h1> Here, the parentheses (.+) define a group that consists of one or more character, and \1 references the contents of the group....

String replace with integer not working [closed]

java,string,replace,integer,replaceall

The replace only works on the first execution. After that, value no longer contains -time-. As a solution, you can use a temporary variable to do your replacement: String displayValue = value.replace("-time-", time + ""); ...

Replacing values in a matrix by specified values

matlab,for-loop,replace

Try it like this: for i=1:nIndices slice = simulatedReturnsEVT1(:,i,:); slice(slice < MinAcceptableVal(i))=MinAcceptableVal(:,i); slice(slice > MaxAcceptableVal(i))=MaxAcceptableVal(:,i); simulatedReturnsEVT1(:,i,:) = slice; end ...

Batch-Script: Replace every “@” in file name with “_” in network drive including subfolders

batch-file,replace,folder,filenames

setsyntax for replacing a string: set "var1=my old hat" set "var2=%var1:old=new%" echo %var1% was better than %var2% To get all txt-files: for %%i in (*.txt) do ( echo %%i rem substitution does not work with special %%i variable type set "oldname=%%i" set "newname=!oldname:@=_!" echo rename "!oldname!" "!newname!" ) Why !...

Xpath for Find & Replace?

xml,xpath,replace

XPath cannot modify an XML file. For that you need XSLT or XQuery. If this really is a global change (that is, if you want to change this text regardless of the context where it appears) then I would be very inclined myself to do it using a text editor:...

Return value based on duplicate columns

mysql,sql,replace,duplicates

You can try with group by: select Firstname , Lastname , case when count(*) > 1 then '**ERROR**' else age end from Table group by Firstname , Lastname , age; Or in case you want to return all rows with duplicates: select t.Firstname , t.Lastname , case when (select count(*)...

Using regex to extract multiple strings

regex,xml,string,replace

Just use parentheses instead of braces. Regex.Replace(str, @"<(jv:(?:FirstName|MiddleInitial|LastName)>).*?</\1, "<$1</$1"); Braces signify matching any character within them one time. Parentheses match the full string....

Replace characters in java string [duplicate]

java,replace

replace doesnt use a regular expression. Just use myString = myString.replace("[merchant]", "newText"); ...

How to Avoid the string from number(for rupees) in c#?

c#,wpf,c#-4.0,replace,decimal

Here you go: string OnlyNumbered = Regex.Match(label1.Content.ToString(), @"\d+").Value; ...

shell script for counting replacements

bash,replace,count

Assuming you want to replace the word 'apple' with 'banana' (exact match) in the contents of the files and not on the names of the files (see my comment above) and that you are using the bash shell: #!/bin/bash COUNTER=0 for file in *.txt ; do COUNTER=$(grep -o "\<apple\>" $file...

Replace string to the target format

.net,regex,vb.net,string,replace

It is impossible to achieve in a single pass. I suggest: Adding parentheses: (\p{Lu}+)\s*(\p{Lu}+)(.*) (replace with $1($2$3)) See demo Then, you can use a regex to find all spaces between numbers and replace them with a comma: (?<=\d+)\s+(?=\d+). See demo (see Context tab). Here is a working VB.NET code: Dim...

Strategy for Processing a Text File with a Header using Reg Exp in Java

java,regex,replace

Assuming you can use java.nio.file.Files (since Java 1.7) and your text file isn't too big, I'd read all lines at once and go for the Matcher: Charset charset = Charset.forName("UTF-8"); List<String> lines = Files.readAllLines(file.toPath(), charset); for (String line : lines) { Matcher matcher = regexpPattern.matcher(line); if (matcher.matches()) { // do...

Delete word from a line in a text file

java,string,file,replace

The replace(...) method doesn't modify the original String, it returns a new modified String. You need to do something like this: line = line.replace(" alle ", " "); And here is a complete solution: Scanner scannerLines = new Scanner(file); boolean alleFound = false; boolean nrFound = false; boolean minFound =...

converting [b] to