All Questions
8
questions
0
votes
1
answer
1k
views
Convert (part of) XML data back to tabular data or CSV/tab separated without using scripting
Is there an easy way to convert (part of) XML data back to tabular data, so comma separated values or tab separated or Excel? I sometimes get XML log files, and for clarity and comparing it more ...
2
votes
0
answers
872
views
Loading UTF8 CSV files generated on a Mac into Excel on Windows: does not recognize encoding
When I generate a UTF8 CSV file in Excel (or some other way) on Windows and then open it n Excel, I expect it to ask me to choose the right encoding.
I got a UTF8 CSV file that was generated on a Mac. ...
0
votes
1
answer
2k
views
Trying to replace multiple strings in Notepad++ from a file
What I am doing is looking at multiple large text files, in these text files are common strings that need to be replaced. If it was a handful of instances I could use the Replace function, but I have ...
1
vote
2
answers
1k
views
How do I copy specific selected data between cells in a CSV file in Excel or Notepad++?
I have to download media file databases on a daily basis and modify metadata from a csv file so that the unique numerical prefix in column B is added as a suffix to the cells in column C.
Is there a ...
0
votes
1
answer
1k
views
Extract all URLs from CSV /Excel file and put it in a separate column
I have a csv file. When I open the csv file in Microsoft excel, I have a column.
Each cell in the column has number of paragraphs. each paragraph has many URLs.
I am looking to extract all URLs in ...
1
vote
1
answer
164
views
Deleting all line breaks between two matching variables in notepad++
So I am trying to ultimately make a table out of a whole bunch of text, but it's giving me a headache. Basically here is an idea of what is going on:
matchingvariablelengthupccode1 ...
0
votes
1
answer
790
views
add space after nth commas in Excel, Notepad++, or emEditor?
Notepad++ 6.8.8
I want to be able to turn several lines that start like this:
0,2,3,45,67,89,01,234,567,890,123,4567,8901
0,7,8,9,0,11,12,13,14,151,162,173,184
x,z,q,r,n,f,t,a,e,f,z,n,a
into
0, 2,...
1
vote
2
answers
3k
views
Changing DateTime format in multiple CSV files
I've got multiple csv files with this structure:
text, text, 01/27/2001 01:00:00 PM
I need to update ALL csv files with this datetime format:
text, text, 27-Jan-2001 13:00:00
Is there a known ...