quote:

---

Originally posted by Clairekun


It's working! I wasn't sure if you could assign a string to a range, I initially thought it was solely for integers. It's good to know. I also forgot you could use if == 0, silly me.

I would like to understand a few things, if you were so nice to clarify them for me:

1. What's the difference between looping forwards or backwards?
2. Could you explain why you used (int i = wks.ncols; i >= 1; i--) instead of (int i = 1; i >= wks.ncols; i--), as I normally see it in help files (or point me where I can read about it)? I don't quite see the difference, but obviously the latter doesn't work.

Thank you!

---

------------------------------------------
       Be The Change
             You Want To See
                   In The World
------------------------------------------

quote:

---

See if the following works for you.

This is an example of removing columns if its name is NOT one of "Sample", "Temperature", "Pressure" or "Viscosity":

StringArray KeepCols = {"Sample", "Temperature", "Pressure", "Viscosity"};
for(int i = wks.ncols; i >= 1; i--)
{
    range rr = $(i);
    int nFound = KeepCols.Find(rr.LName$);
    if(nFound == 0)
    {
        delete rr;
    }
}

---

quote:

---

Originally posted by Clairekun

quote:

---

Originally posted by Castiel

1. find one column to be deleted
2. store the column index in a dataset or store the column short name in a stringarray
3. goto 1 untill no more columns found
4. define a range according to colum index/name from 2 in backward order
5. delete the range from 4
6. goto 4 until all found columns are deleted

---

Okay, please excuse me if I'm saying something stupid since my LT knowledge is very limited.

To get column short names, I wrote:

stringarray KeepCols;
KeepCols.add("Sample");
KeepCols.add("Temperature");
KeepCols.add("Pressure");
KeepCols.add("Viscosity");
loop(ii,1,KeepCols.GetSize()) 
{
string KeepLN$ = KeepCols.GetAt(ii)$;
	for(int jj = 1; jj <=wks.ncols; jj++)	
	{		
	if (col(jj)[L]$ == KeepLN$) type "Column index is col(jj)[G]$"

} 

}

Basically, I tried to say... "if any of these columns has any of those long names, return the column index of said column" just to see if it worked. However, it returns nothing. I also tried %(KeepLN$), with and without quotations, to no avail.

What am I doing wrong?

Next step would be defining a new string array to store said short names, and changing the script from If function to something that stores the short names there (which I think I can do). The rest, I will definitively need help with.

Also, I think I have read somewhere, although I cannot find where, that you can use ! in If commands to find the items that do not match that condition. This would be ideal, since what I really need is to delete all other columns. Is this true? I might use Else instead, if that was not the case.

Thank you.

---

StringArray KeepCols = {"Sample", "Temperature", "Pressure", "Viscosity"};
for(int i = wks.ncols; i >= 1; i--)
{
    range rr = $(i);
    int nFound = KeepCols.Find(rr.LName$);
    if(nFound == 0)
    {
        delete rr;
    }
}

------------------------------------------
       Be The Change
             You Want To See
                   In The World
------------------------------------------

quote:

---

Originally posted by Castiel

1. find one column to be deleted
2. store the column index in a dataset or store the column short name in a stringarray
3. goto 1 untill no more columns found
4. define a range according to colum index/name from 2 in backward order
5. delete the range from 4
6. goto 4 until all found columns are deleted

---

stringarray KeepCols;
KeepCols.add("Sample");
KeepCols.add("Temperature");
KeepCols.add("Pressure");
KeepCols.add("Viscosity");
loop(ii,1,KeepCols.GetSize()) 
{
string KeepLN$ = KeepCols.GetAt(ii)$;
	for(int jj = 1; jj <=wks.ncols; jj++)	
	{		
	if (col(jj)[L]$ == KeepLN$) type "Column index is col(jj)[G]$"

} 

}

quote:

---

Originally posted by Clairekun

The thing is, everything I find needs to select columns to delete with column number.

In my case, I always have the same 4 columns and others that are not always the same. Neither the constant nor the additional columns share the same column number among worksheets or workbooks, that's why I need to specify long names.

Unless I'm understanding it wrongly, the code you suggested deals with colum numbers only, which wouldn't suit my needs.

---

------------------------------------------
       Be The Change
             You Want To See
                   In The World
------------------------------------------

quote:

---

Originally posted by Clairekun

Origin Ver. and Service Release (Select Help-->About Origin): 2018b
Operating System: Windows 10

Hello,

I am trying to delete multiple columns using a range. I have been browsing the help files, but nothing is addressing what I need exactly. I would need to delete all columns that do not match the specified long names.

Is there any way to achieve this?

---

range rr = 1;
delete rr;

------------------------------------------
       Be The Change
             You Want To See
                   In The World
------------------------------------------