quote:

---

I imported the data and checked the option "Rename worksheet to data file name", all the usderscores were still there and even the first character is number.

---

quote:

---

I imported the data and checked the option "Rename worksheet to data file name", all the usderscores were still there and even the first character is number.

---

quote:

---

Here's an example using the Custom Routine button. Find Custom.ogs in the program folder and edit its [Main] section in Notepad or CodeBuilder to look like this...

[Main]
stat= @KC + 2 * @KS;
if(stat==1) %L="";
if(stat==2) %L=%L %H;
if(stat) return;
ty -a %L;
// type -b $General.Userbutton;

---

The code doesn't work here and I am trying to find the reason.

quote:

---

Bad idea to use _ in a worksheet or column name. That's certain to lead to glitches like this. Not only that... underscores are not allowed in wks or col names. How did you get the second _ in your dataset name?

---

Now I know it's a bad idea to use _ in a worksheet name.
I imported the data and checked the option "Rename worksheet to data file name", all the usderscores were still there and even the first character is number. Of course, when I tried to rename the worksheets with underscore or start with a number, I failed.

Thank you very much for your codes and explanation!

quote:

---

The question is that whether the OC can recognise the worksheets which are highlighted?

---

string wks_names()
{
	string sWks,sList;
	StringArray sa(0);
	GraphLayer gl = Project.ActiveLayer();
	int nPlots = gl.DataPlots.Count();
	if( !nPlots ) return "";
	foreach (DataPlot dp in gl.DataPlots)
	{
		sWks = dp.GetDatasetName(); // dataset name
		sWks = sWks.GetToken(0,'_'); // wks name
		sa.Add(sWks); // add to string array
	}
	sList = sa[0]; // now strip duplicates (may not be necessary)
	for(int i=1;i<sa.GetSize();i++)
		if( sList.Find(sa[i])==-1 )
			sList.Format("%s, %s",sList,sa[i]);
		
	return sList;
}

void my_legend()
{
	string sWks,sLegend;
	GraphLayer gl = Project.ActiveLayer();
	int nPlots = gl.DataPlots.Count();
	if( !nPlots ) return;
	int i;
	foreach (DataPlot dp in gl.DataPlots)
	{
		i++;
		sWks = dp.GetDatasetName(); // dataset name
		sWks = sWks.GetToken(0,'_'); // wks name
		if( i==1 )
			sLegend = "\l(1) " + sWks; // first line
		else
			sLegend.Format("%s\n\l(%d) %s",sLegend,i,sWks)
	}
	gl.LT_execute("legend"); // create legend
	GraphObject goLegend = gl.GraphObjects("legend");
	if( goLegend.IsValid() )
		goLegend.Text = sLegend; // replace the text
}