Page 1 of 1

importing data that is merged into one column

Posted: Mon Jan 18, 2021 6:12 am
by edatae
Could be an elementary question, but I was provided with data that was in the form of one column and can't figure out how to import it.
In the excel files tags like "age, employement, education, retirement, insurance" are merged, so a cell could look like "30,1,1,0,1".
Any solution would be appreciated :)

Re: importing data that is merged into one column

Posted: Mon Jan 18, 2021 7:05 am
by startz
Try saving the Excel file as a csv file for a txt file. Drag-and-drop it onto EViews. When going through the screens, unclick "Don't split quoted fields" That should get you most of the way, although there may still be some extraneous quote marks left around.

Re: importing data that is merged into one column

Posted: Mon Jan 18, 2021 7:32 am
by edatae
@startz thanks, saving it as a text file allowed me to bypass the problem as eviews is compatible with .txt.
appreciate it a bunch :)