'Find' command

Use this forum to post Vensim related questions.
Post Reply
Phill
Senior Member
Posts: 156
Joined: Wed Jun 04, 2014 2:18 pm
Vensim version: DSS

'Find' command

Post by Phill »

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
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: 'Find' command

Post by Administrator »

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.
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
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: 'Find' command

Post by tomfid »

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.
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: 'Find' command

Post by tomfid »

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.
Phill
Senior Member
Posts: 156
Joined: Wed Jun 04, 2014 2:18 pm
Vensim version: DSS

Re: 'Find' command

Post by Phill »

Thanks, F3 is exactly what I was looking for!!
Post Reply