1,151 reputation
411
bio website
location Paris, France
age
visits member for 1 year, 8 months
seen Dec 2 at 8:36

Oct
25
awarded  Enlightened
Oct
25
awarded  Nice Answer
Apr
9
awarded  Yearling
Oct
10
awarded  Critic
Jun
19
comment How do I remove empty lines in Notepad++ after pasting in data from Excel?
@Sammy Since regex are not specific to Notepad++, you can learn it anywhere (regexone.com seems to be a nice starting point). You should also take a look at what kind of regex Notepad++ actually support.
Jun
19
revised How do I remove empty lines in Notepad++ after pasting in data from Excel?
added 2 characters in body
Jun
19
comment How do I remove empty lines in Notepad++ after pasting in data from Excel?
@Sammy Sorry my mistake, \R is only supposed to be in the find part, not the replace with part. See my last edit. And to answer your question, those were VIM syntax for substitution : s/find what/replace with/.
Jun
19
revised How do I remove empty lines in Notepad++ after pasting in data from Excel?
deleted 96 characters in body
Jun
19
comment How do I remove empty lines in Notepad++ after pasting in data from Excel?
@Sammy This method is indeed simpler, but it only works because you always have only one tab in your empty line. The regex approach would be able to handle any kind of empty lines.
Jun
19
comment How do I remove empty lines in Notepad++ after pasting in data from Excel?
@Sammy I was just improving the regex to be simpler and less specific. But s/\R(\s*\R)+/\R/ should work as well as s/\R([\t]*\R)+/\R/ and s/\r\n([\t]*\r\n)+/\r\n/.
Jun
19
revised How do I remove empty lines in Notepad++ after pasting in data from Excel?
added 129 characters in body
Jun
19
revised How do I remove empty lines in Notepad++ after pasting in data from Excel?
added 129 characters in body
Jun
19
revised How do I remove empty lines in Notepad++ after pasting in data from Excel?
added 36 characters in body
Jun
19
revised How do I remove empty lines in Notepad++ after pasting in data from Excel?
added 160 characters in body
Jun
19
answered How do I remove empty lines in Notepad++ after pasting in data from Excel?
Jun
12
awarded  Guru
Jun
11
comment How to get Excel to interpret the comma as a default delimiter in CSV files?
@Szabolcs Since you're on OSX and not on Windows, I updated my answer to be less specific, and I included your suggestion for potential future visitors.
Jun
11
revised How to get Excel to interpret the comma as a default delimiter in CSV files?
added 324 characters in body
Jun
11
revised How to get Excel to interpret the comma as a default delimiter in CSV files?
added 324 characters in body
Jun
11
comment How to get Excel to interpret the comma as a default delimiter in CSV files?
@Szabolcs Excel won't try to detect the delimiter while opening a CSV file (using file->open or the explorer), it will just use the system setting. It will however manage to detect automatically the delimiter (tab, comma, semicolon or space) while using the import feature.