importing data that is merged into one column

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

edatae
Posts: 2
Joined: Mon Jan 18, 2021 6:05 am

importing data that is merged into one column

Postby edatae » Mon Jan 18, 2021 6:12 am

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 :)

startz
Non-normality and collinearity are NOT problems!
Posts: 3775
Joined: Wed Sep 17, 2008 2:25 pm

Re: importing data that is merged into one column

Postby startz » Mon Jan 18, 2021 7:05 am

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.

edatae
Posts: 2
Joined: Mon Jan 18, 2021 6:05 am

Re: importing data that is merged into one column

Postby edatae » Mon Jan 18, 2021 7:32 am

@startz thanks, saving it as a text file allowed me to bypass the problem as eviews is compatible with .txt.
appreciate it a bunch :)


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 17 guests