I feel I am missing a simple trick here! I needed to change all the 'GET XLS' commands in a rather large Vensim model, so that the files Vensim fetches are 'xlsx', rather than 'xls'. So, I used the 'Edit' - 'Find' command the look for the relevant variables in Text view. But I can't find a 'Next' option for the 'Find' dialogue. The search locates the first line containing 'GET XLS', but I can't see a way to move on, although i'm sure there must be one. Can anyone point it out to me, please?
Incidentally, I tried copying the entire text into Notepad++, making the replacements there and copying it back, but when i tried to save the edited file I got a 'Vensim Stop - syntax error' warning. I presume Notepad++ adds something or alters the formatting, but I would have thought it should work.
Phill
'Find' command
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
Re: 'Find' command
You can use the F3 button to find the next occurance.
Notepad++ should have been ok, if you can paste in here what Vensim was complaining about I can take a look.
Notepad++ should have been ok, if you can paste in here what Vensim was complaining about I can take a look.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Re: 'Find' command
Notepad++ definitely should have worked - I use it all the time.
Another option is to do this in the text editor (View>As Text) and use the Replace or Replace String command.
Another option is to do this in the text editor (View>As Text) and use the Replace or Replace String command.
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Re: 'Find' command
Also, rather than:
GET XLS( 'mydata.xlsx', ... )
you can use
GET XLS( '?my data', ... )
when Vensim encounters the ? it will query for the data file location, and store it for future use. Thereafter, you can manage the data pointer via Model>Settings>XLS Files.
GET XLS( 'mydata.xlsx', ... )
you can use
GET XLS( '?my data', ... )
when Vensim encounters the ? it will query for the data file location, and store it for future use. Thereafter, you can manage the data pointer via Model>Settings>XLS Files.
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Re: 'Find' command
Thanks, F3 is exactly what I was looking for!!