Windows 10: I have a very large file in Notepad consisting of 3 columns and 36,000 rows. I would like...

I have a very large file in Notepad consisting of 3 columns and 36,000 rows. I would like to copy this data to Quatro Pro so I can plot it. How can I do that?

:)

 

Combine multiple CSV files by column, not by row

I have ~100 CSV files that I want to combine into one single Excel spreadsheet (everything in one tab, not in separate tabs). These CSV files are identical in format: each contains 4,000 rows and 2 columns with header, about 60 KB in size.

All solutions I've found so far append the next CSV at the end of the last row of the active tab. I haven't seen one that can append new CSVs to the columns immediate to the right of last column.

Here're some examples.

1. DOS copy method: copy *.csv merge.txt
   
2. This solution. (VBA script.)
   
3. Using Excel's Data>New Query>From File>From Folder (Excel 2013) .
   

There are also examples with Windows Powershell scripts to merge CSV files on the internet.

All of the above create a single Excel spreadsheet with about 400,000 rows of data, which is useless to me.

I'd appreciate suggestions to solve this problem. Thanks!

Edit. An easy solution is found: using r's cbind() to combine the data in a data frame and then write it to a csv. The entire process took ~3 seconds. Right tool for the job!

Thanks to everyone for contributing. Cheers,

--tcollar

 

User.000 issue after updating to 1909

I'm one of the many people suffering from issues with user profiles after applying Update 1909 to Windows 10. I've read all the threads I can find on the topic here and have followed the suggestions, all to no avail. Any other thoughts are appreciated.

After applying Update 1909, the ProfileImagePath was changed to c:\users\User.000
One file that was always in use and couldn't be removed was left in c:\users\User (can't recall or find the exact file now), so I could never rename or remove the c:\user\User directory.

I followed the multiple suggestions from Brink and others:

• Rebooted at least 6 times
• Enabled hidden Administrator
• Booted into Safe Mode
• Changed ProfileImagePath
• Tried to rename c:\users\User but couldn't because a file was still in use
• Copied all data from c:\users\User.000 into c:\users\User
• Rebooted and had temporary profile
• Followed steps in Brink tutorial to change ImageProfilePath; rebooted with no change
• Restored using Restore Point from before Update 1909 - returned to single profile state (User.000)
• Removed each update that was installed individually and rebooted after each update removal - profile state never changed
• After all updates were removed, repeated the steps above with hidden Administrator, changing profile, etc. - same issue with file in use in c:\users\User
• Followed all steps above with hidden Administrator but without copying files from User.000 to User - same results

Any suggestions are greatly appreciated!

 

Wordpad ? Notepad ++ ? Why like this ?

Turn word wrap off in Notepad and it works fine for script editing. Turn word wrap on and it works fine for text editing. Yes, it is very simple software so it isn't really suitible for complex file operations (find/replace, column select, binary files etc.) but it works great for batch files or touching up some source code.