import excel files with wildcard in names

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

bcchen
Posts: 31
Joined: Tue May 02, 2017 8:34 am

import excel files with wildcard in names

Postby bcchen » Wed Nov 28, 2018 10:37 am

Hi EVIEWS GURUS,

I have many excel file in a folder that I want to import all of them to EVIEWS. The name of the excel files vary, but all end with "reviewed". Is that possible to write a program:
1. pick out all the excel files in a certain folder and import them(then I will remove those excel I don't want);
2. or even better: pick out all the excel files in certain path with a wildcard in names, like *reviewed.xls?

Thanks!
BC

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

Re: import excel files with wildcard in names

Postby EViews Gareth » Wed Nov 28, 2018 10:43 am

Use the @wdir function
Follow us on Twitter @IHSEViews

bcchen
Posts: 31
Joined: Tue May 02, 2017 8:34 am

Re: import excel files with wildcard in names

Postby bcchen » Tue Dec 04, 2018 11:24 am

Thank you very much Gareth! it works like a charm!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 9 guests