All Questions
87
questions
0
votes
0
answers
49
views
Is $ the equivalent of \ in the replace string of a RegEx match (using Notepad++)?
I used some Excel formulas to generate 172 lines of SQL code for a query. I paste Excel stuff into Notepad++ to clean up anything that needs cleaning up before pasting it into SSMS. When pasted into ...
0
votes
4
answers
66
views
Notepad++/Excel - how to copy each value x times in the list and keep the order
Hello i have this simple question:
i have a list of values in column, for example
apple
banana
orange
i want copy each value x times and keep the order, for example 3 times, and list will look like ...
-1
votes
2
answers
1k
views
Trying to edit massive 1.5 GB CSV File
I have been trying to make changes to a csv invoice that my company gets on a monthly basis. However, the File is 1.5 GB in size and contains over 1.500.000 rows with 36 columns. While I can open the ...
0
votes
1
answer
48
views
There is a method to convert these column in data format like this dd/mm/aaaa hh:mm:ss [closed]
I need to convert these 3 column in one column with this format(gg/mm/aaaa hh:mm:ss)
I have tried with notepad++ but i fail
for example the final result will be 28/12/2022 16:54:00 or 2022.12.28 16:...
0
votes
1
answer
73
views
How can I remove all blank spaces per line from either Excel and/or Notepad++, without merging all lines into one single line?
First post here on stackoverflow, tried to search across the web but couldn't find the solution. If the question has already been answered, sorry!
I'm trying to do the following in either or both ...
-1
votes
3
answers
77
views
Add special characther in notepad++/excel
I Need to replace a string like this:
20211201153000
In date format like this
2021/12/01 15:30:00 (yyyy/MM/GG hh:mm:ss)
Any solution?
1
vote
1
answer
193
views
How to make a macro that replace string in Excel
Does anyone know how to make a macro in Excel that convert strings ?
I want to convert all strings existing in one column respecting this transformation :
initial
result of macro
first_name
$...
0
votes
1
answer
57
views
Retrieve the value of multiple cells and opening files in Excell
I am trying to copy the content of 2 separate cells together with a command to launch the Notepad++ to open 2 files for visual comparison in Excell 2016 on Windows 10.
e.g. cell [1,A] - C:\Comparison\...
0
votes
1
answer
142
views
Excel columns to SQL statement
This question is on turning the copy pasted columns from Excel into a SQL statement. My current process includes manually replacing things. After using some notepad++ functionality to control h to ...
0
votes
3
answers
133
views
Replace double commas with last group of alphanumeric characters in the line
Long story... I have a CSV that looks, symbolically, something like this:
Source CSV.
I have been trying to get Excel to fill each blank cell in each column with the value above it or below it. For ...
0
votes
1
answer
37
views
How to be able to find / replace whatever content is on a certain line in several pages when the content in the pages is not the same for that line? [closed]
I need a script, bat, or even done in NOTEPAD++ or MS Exel with a plugin or etc.
Let's say I have multiple pages opened in NOTEPAD++ or in a sub-folder in Windows.
As an example:
All the pages have 5 ...
1
vote
1
answer
950
views
Copy paste from excel to notepad++ issue
I am trying to copy data from excel and paste it in Notepad++.
When pasting in NPP, it is automatically inserting carriage return and the cursor goes on to the next line.
Is there any way to avoid ...
0
votes
1
answer
682
views
How can i copy columns to one column
Hope someone can help in coping more than 500 columns from excel to notepad in one column .. when i used the usual coping it did but beside each other. i need to copy them in one column .. i tried to ...
0
votes
1
answer
265
views
How to put all lines starting with a specific character combination on the previous line in Excel or Notepad++?
I'm trying to import the following CSV data set into Excel. I'm using the Text Import Wizard to set the right delimiters. So far, I used the ";" and "," delimiters.
Here is the ...
0
votes
0
answers
406
views
Problems came up in the following areas during loading : Excel Name
So I am building a report in Progress ABL to open in Excel afterwards. Nothing complicated, simple < TABLE> with each < TR> having 7 < TD> data column. Then I open excel using ...