Spaces in export file name

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

theagney
Posts: 4
Joined: Tue Oct 16, 2018 10:15 pm

Spaces in export file name

Postby theagney » Wed Oct 17, 2018 5:21 pm

Hi there,

Is there any way to incorporate spaces into the file name when exporting data from Eviews into an Excel workbook?

Thanks!

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11875
Joined: Tue Sep 16, 2008 5:38 pm

Re: Spaces in export file name

Postby EViews Gareth » Wed Oct 17, 2018 7:25 pm

Yes. When you save the file, use the space bar where you want a space.
Follow us on Twitter @IHSEViews

theagney
Posts: 4
Joined: Tue Oct 16, 2018 10:15 pm

Re: Spaces in export file name

Postby theagney » Wed Oct 17, 2018 10:51 pm

If I have a space in the Excel file name, as follows;

wfsave(type = excel, mode = update) National Coredata.xls range="Eviews!a1" byrow @keep trns_1_*

I get the following error;

Syntax error: unexpected character '.' in file option settings in
"WFSAVE(TYPE = EXCEL, MODE = UPDATE) NATIONAL
COREDATA.XLS RANGE="EVIEWS!A1" BYROW @KEEP
TRNS_1_*"

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11875
Joined: Tue Sep 16, 2008 5:38 pm

Re: Spaces in export file name

Postby EViews Gareth » Thu Oct 18, 2018 3:05 am

Ah, you didn’t mention you were saving via command.

Enclose the path/filename in quotes.
Follow us on Twitter @IHSEViews

theagney
Posts: 4
Joined: Tue Oct 16, 2018 10:15 pm

Re: Spaces in export file name

Postby theagney » Thu Oct 18, 2018 9:39 pm

Thanks Eviews Gareth :D

theagney
Posts: 4
Joined: Tue Oct 16, 2018 10:15 pm

Re: Spaces in export file name

Postby theagney » Sun Nov 11, 2018 9:24 pm

The workbook doesn't seem to update properly when making this change to the path.

Any ideas as to why?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11875
Joined: Tue Sep 16, 2008 5:38 pm

Re: Spaces in export file name

Postby EViews Gareth » Mon Nov 12, 2018 12:05 am

Not without more details.
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 52 guests