All Questions
998
questions
0
votes
1
answer
45
views
Find/Replace Row number within Formula
I have an Excel formula where I wish to change range row number found in a specific cell.
=SORT(UNIQUE(FILTER(CHECKLIST!K7:K120180,(CHECKLIST!B7:B120180=INVENTORY!H5)*(CHECKLIST!C7:C120180=INVENTORY!...
1
vote
2
answers
28
views
How to put the same character in the beginning of all rows using regex?
I have a list of 10 digit numbers in a txt file.
I want to put the same character in the beginning of all rows using regex, without changing the numbers.
I also want to put the character at the end of ...
- 11
1
vote
0
answers
48
views
Request help marrying two VBA scripts together (Find/Replace)
Attempting to add Find/Replace to existing code
Starting with this piece of code which works to convert a .CSV to an .XLS File:
Sub CSVtoXLS()
'UpdatebyExtendoffice20170814
Dim xFd As FileDialog
...
- 11
0
votes
1
answer
32
views
Find and replace n-th occurrence in VS Code
I have a large data set that I'd like to convert into a workable csv file.
The dataset currently looks like this:
[att1]; [att2]; [att3]; [att1]; (...)
To make this a workable csv-file, I'd need to ...
- 145
0
votes
1
answer
17
views
I'm trying to replace text in all files using FIND
$i%2==0 ? $color="$c[color7]" : $color="$c[color7]";
I'm trying to change all files like this.
$i%2==0 ? $color="$c['color7']" : $color="$c['color7']";
find . -...
- 33
0
votes
0
answers
16
views
How to perform a Find/Replace on a directory of Excel files in VBA [duplicate]
I am wanting to perform a Find/Replace on all the excel files in a single folder
(that I am prompted to select.)
This is the code:
Sub Find_Replace1() Range("A2:A100000").Replace What:="...
- 11
0
votes
1
answer
60
views
Find and replace text in Microsoft Word using an Excel spreadsheet
I have a Word document written in English. The English acronyms need to be translated to French.
I also have an Excel spreadsheet. Sheet1 has the English acronyms in column A, and the French acronyms ...
1
vote
2
answers
91
views
MySQL complex REGEXP find and replace
I want to run a regexp find and replace on a wordpress database, specifically the in wp_posts table, in the post_content column. I have several affiliate URLs scattered in the text of the post_content ...
- 31
1
vote
1
answer
359
views
Find, Replace and adjust image in PDF's using python
I have code in python which is finding and replacing a image in pdfs, but I'm having hard time adjusting the size of the new image so what the code is doing is finding the old image and it's using the ...
- 41
0
votes
1
answer
62
views
Find and Replace Word Doc from Excel Tables
I am trying to create an order form in excel that can be populated, then with the press of a button complete a word-based order form (that will save as PDF) to send to customers.
I know this isn't the ...
1
vote
2
answers
74
views
Add quotation to start and end of each line in Xcode
I have multiple lists (in a .txt file) which I'd like to quickly convert to an array. I've seen this question asked and answered here for Notepad++, but not for Xcode. Is it possible to similarly here?...
- 65
0
votes
1
answer
25
views
Remove the digit(s), the comma and the space at the left part of the line
Sample data:
(17, ' Antonio Moreno Taquería (Restaurant) - 'Page 2' <br> ('4 februari 2024'),
(1, ' Cactus Comidas para llevar (Pizza) - 'Page 45' <br> ('7 april 2023'),
(58679, ' ...
0
votes
1
answer
60
views
AppleScript do shell script find & replace in directory
I’ve already got a fully AppleScript find & replace script but since unix tends to be less process intensive, I’ve been trying to see if there’s a better way to script find & replace for a ...
0
votes
0
answers
16
views
Find and replace function for similar phrases
I have a word doc that’s contains multiple pages of information all listed in a certain format. At the beginning and ends of each separate event/account, there is the following sentence
=== end ...
0
votes
0
answers
43
views
Excel VBA code to Find and Replace not working properly
I wrote a Find and Replace Sub in VBA Macros to find specific strings and replace them with some numbers. There are 30 blocks of code but the block 10 and block 15 does not work. And example of ones ...
