All Questions
104
questions
0
votes
0
answers
17
views
Extract content from Notepad++
Hi I am trying to extract mcc and mnc along with their values from a log file defined under "userLocationinfo: class UserLocation{" Can anyone help with that? The overall file is big and lot ...
-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
247
views
Regex Search and Replace specific text on a csv using Notepad++
I need to do a search and replace on a csv file using regex on Notepad++ or TextPad to replace the text on a specific column if another text is met. For example, I have this line:
Search for price 50....
1
vote
2
answers
2k
views
Remove a column from CSV file in Notepad++
First of all, I'm a newbie in Notepad++. I'm trying to edit this dataset in Notepad++, which is stored in CSV. I can't open this file in Excel as there are some cells containing digits longer than 15 ...
0
votes
1
answer
1k
views
In Notepad++ in a csv file, is there a way to highlight the header name of the column you're working in?
I could have sworn I saw someone do this in the past.
If I have a .csv column and I click into the data, is there a way to have the header row of the column I am working in be highlighted?
If not, is ...
0
votes
3
answers
415
views
Extract only first occurrence of strings from each line
I have a CSV file, around 5k lines, with the following example:
apple,tea,salt,fish
apple,oranges,ketchup
...
salad,oreo,lemon
salad,soda,water
I need to extract only first line matching apple or ...
0
votes
2
answers
296
views
Finding numbers with a specific length from csv file
I'm working with a csv file from a customer, which holds a large amount of data. The data is extracted from an SQL database and the commas therefore signify the different columns. In one of these ...
-2
votes
3
answers
268
views
Trim values of CSV using Notepad++ only if the value is not blank
I have the following CSV:
COLUMN_A;COLUMN_B;COLUMN_C;COLUMN_D;COLUMN_E;COLUMN_F;COLUMN_G;COLUMN_H;COLUMN_I;COLUMN_L;
01234;AB ;00001; ;100000001; ;ABC;+0000000000099998,080;XYZ ;
I would ...
2
votes
1
answer
3k
views
Converting a column to row CSV in Notepad++
I have 1 column of characters, they are stock ticker symbols, and each is on its own line. I need to convert this to 1 row with each ticker separated by a comma.
From something like:
mmm
axp
.
.
.
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
0
answers
2k
views
How to change the Windows-1251 encoding in a csv file with the actual UTF-8
I'm trying to translate "hieroglyphs" into Russian letters. I took a dataset (RUvideos.csv file), uploaded it via pandas:
import pandas as pd
data=pd.read_csv('RUvideos.csv',encoding = "...
2
votes
1
answer
322
views
How to replace double quotes from csv inside a tag using Regex
I have a csv file which contains double quotes within a tag and enclosed with double quote. Needs to replace double quote inside a tag with some other character.
Eg.
"id"|"Name"|&...
1
vote
0
answers
773
views
Failing to convert a CSV file to UTF-8 BOM(w/ Notepad++) in order to migrate it to SQL w/ SSIS and keep regional(Polish) letters
I have a CSV in Polish that I want to get into SQL w/ SSIS.
I open it in Notepad++ and it says UTF 8.
If it doesn't actually say UTF-8-BOM in the status bar then Notepad++ is only guessing the ...
2
votes
1
answer
6k
views
How to vertically align tabulator separated values in Notepad++
I have a txt file with 406'000 lines (100MB size) and would like to view it with Notepad++ instead of Excel, because it's much faster.
How can I separate columns with a tabulator delimiter?
I'm ...
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 ...