All Forums  Origin Forum  Origin Forum  String expresssion problem

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by JonasKlim[/i] [br]Origin Ver. and Service Release (Select Help-->About Origin): Origin Student 2018 Operating System: Win10 Hello, I am writing script for automatic plotting of graphs. The script runs through summary table and looks for lines where name of graph is written (col "G" or "7"). If cell is empty script goes to next cell. Everything works fine until first name (MVvsB)is found, assigned to grname$ and graph is plotted. Then, regardless if next name cell is empty of full, the "str expression error" is generated. It looks like the problem is caused by the program jumping to plot data table while performing "plotxy iy:=" function. Please see the script and log below. What work-around I could use? Best regards, Jonas string grname$= ""; string bkname$= ""; string lent$= ""; int nn=0; //run through summary table with 72 lines//; for(ii=1; ii<=72; ii++) {; ii=; grname$= col(7)[ii]$; //get name for chart//; //grname$=; nn= Len(grname$); if (nn!=0) {; lent$= col(5)[ii]$; //get name of data worksheet//; //lent$=; bkname$=col(6)[ii]$;// get name for data book//; plotxy iy:=[bkname$]lent$!(1,9) plot:=200; //plot graph//; grname$=; //string grname$= ""; //nn=; }; }; ii=1 ii=2 ii=3 ii=4 ii=5 ii=6 ii=7 ii=8 ii=9 ii=10 ii=11 ii=12 ii=13 ii=14 ii=15 ii=16 ii=17 ii=18 ii=19 MVvsB ii=20 col(7)[ii]$: str expression error col(5)[ii]$: str expression error col(6)[ii]$: str expression error Failed to resolve range string, VarName = iy, VarValue = [bkname$]lent$!(1,9) #Command Error! [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.