My do file that imports a text file was working fine without need for any delimiter specification as below:
insheet using ".\Richter Research - Clean Data.txt"
I added some data into the excel and overwrote the above text file and saved/replaced with the exact file name in that directory. But now the do file stops and asks for delimiter. I added ", tab" at the end and then it has stopped recognizing any variable names and imports an empty file.
I have nearly 500 lines of do file cleaning data and would hate to redo things. I do have an cleaned file saved as a dta but it will affect the process of adding more excel data --> txt -->do-->clean dta since I dont want to hand the dta file back to student to add more entries.
Sorry I am unable to share using dataex since it has some identifiers.
insheet using ".\Richter Research - Clean Data.txt"
I added some data into the excel and overwrote the above text file and saved/replaced with the exact file name in that directory. But now the do file stops and asks for delimiter. I added ", tab" at the end and then it has stopped recognizing any variable names and imports an empty file.
I have nearly 500 lines of do file cleaning data and would hate to redo things. I do have an cleaned file saved as a dta but it will affect the process of adding more excel data --> txt -->do-->clean dta since I dont want to hand the dta file back to student to add more entries.
Sorry I am unable to share using dataex since it has some identifiers.
