Search found 3 matches

by indigo.bunting
Mon Mar 05, 2018 4:08 pm
Forum: Data Manipulation
Topic: Importing/joining data without headers
Replies: 5
Views: 6039

Re: Importing/joining data without headers

Ok, great. If my files are larger than 2GB, notepad won't open them. Do you know of a text editor that will allow for files larger than 2GB?
by indigo.bunting
Mon Mar 05, 2018 9:44 am
Forum: Data Manipulation
Topic: Importing/joining data without headers
Replies: 5
Views: 6039

Re: Importing/joining data without headers

Steve, Thank you for your response! I like your suggestion of using Command Prompt to concatenate my files. In regards to the carriage return at the end of the last line, do I simply open each of the text files and put a \r (highlighted in yellow below ) and save before running the cmd command? Capt...
by indigo.bunting
Fri Mar 02, 2018 4:10 pm
Forum: Data Manipulation
Topic: Importing/joining data without headers
Replies: 5
Views: 6039

Importing/joining data without headers

I have two data sets I'm working with. Each has 70 files (quarterly data from 2000-present), and each file has several hundred thousand to a million observations. Each data set is vertical bar delimited and does not have headers. The headers are given in a PDF, so I'll have to manually enter those i...

Go to advanced search