選擇，刪除和顏色好的新項目，我在最後一個項目上仍然有一些未完成的問題，但它們更具美感而非優先級。無論如何，這是任務;我有一個excel表，其中包含一周內所有事件的日誌，我想刪除與該任務無關的所有事件，然後為包含與問題相關的常見已知問題或事件的其他行著色，以便他們'很容易挑選出來。第三列包含事件數據，第1列包含工具數據，如果可能的話，我希望通過工具分解剩下的數據，但一次只能一步！
我瀏覽了一下，發現一個看起來可能會處理部分進程的腳本，刪除已知的變量，但它無法正常工作。所以... 這就是我得到的。
Names Default To Here( 1 );
dt = Open ();
column_list = {"Alarm ID"
};
For( i = N Items( column_list ), i > 0, i--,
dt << Select Where( as column(column_list[i]) ="'00000018", "'0000000E", "'000000B9", "'000000C1", "'000000CC", "'000000DF", "'000000E2",
"'0000023B", "'00000D15", "'00000D16", "'00000D1A", "'00000DEF", "'00000DF0", "'00000DF3", "'00000E6A",
"'00000E6D", "'00000EB2", "'00000ED6", "'00000F1A" );
dt << delete rows;
);提前致謝！
Re：選擇，刪除和顏色好的，又回來了，我得到了一些結果，但是我有一個問題導致我的大腦比我的腳疼得多。
dt << New Column ( "Row State 1",
Row State,
Set Formula ( If( :Alarm ID == "'00000D06", Color State(70))),
);
這個位用於設置包含我想要的ID的特定行的標記顏色，但是當我開始相乘時，它將停止能夠設置行狀態顏色本身。它確實在側面標籤中生成行狀態，我可以單獨應用狀態，但顯然我正在嘗試減少手動輸入的數量，所以有人知道更有效的方法嗎？我已經輸入了一公噸的值，但這是我到目前為止所提供的片段。
Names Default To Here( 1 );
dt = Open ();
column_list = {"Alarm ID"
};
For( i = N Items( column_list ), i > 0, i--,
dt << Select Where(
as column(column_list[i]) == "'00000018" |
as column(column_list[i]) == "'0000000E" |
as column(column_list[i]) == "'000000B9" |
as column(column_list[i]) == "'000000C1" |
as column(column_list[i]) == "'000000CC" |
as column(column_list[i]) == "'000000DF" |
as column(column_list[i]) == "'000000E2" |
as column(column_list[i]) == "'0000023B" |
as column(column_list[i]) == "'00000D15" |
as column(column_list[i]) == "'00000D16" |
as column(column_list[i]) == "'00000D1A" |
as column(column_list[i]) == "'00000DEF" |
as column(column_list[i]) == "'00000DF0" |
as column(column_list[i]) == "'00000DF3" |
as column(column_list[i]) == "'00000E6A" |
as column(column_list[i]) == "'00000E6D" |
as column(column_list[i]) == "'00000EB2" |
as column(column_list[i]) == "'00000ED6" |
as column(column_list[i]) == "'00000F1A" );
dt << delete rows;
);
dt << New Column ( "Row State 1",
Row State,
Set Formula ( If( :Alarm ID == "'00000D06", Color State(70))),
);
dt << New Column ( "Row State 2",
Row State,
Set Formula ( If( :Alarm ID == "'000000B2", Color State(6))),
);
dt << New Column ( "Row State 3",
Row State,
Set Formula ( If( :Alarm ID == "'000000BE", Color State(6))),
);
dt << New Column ( "Row State 4",
Row State,
Set Formula ( If( :Alarm ID == "'0000013C", Color State(6))),
);
dt << New Column ( "Row State 5",
Row State,
Set Formula ( If( :Alarm ID == "'00000D3B", Color State(73))),
);
Re：選擇，刪除和顏色太棒了，是的，這並不令人驚訝，好吧，這非常有幫助，我會玩這個，看看我能不能弄清楚剩下的，謝謝！
Re：選擇，刪除和顏色Where子句的語法不正確。 它應該是：
Names Default To Here( 1 );
dt = Open ();
column_list = {"Alarm ID"
};
For( i = N Items( column_list ), i > 0, i--,
dt << Select Where(
as column(column_list[i]) == "'00000018" |
as column(column_list[i]) == "'0000000E" |
as column(column_list[i]) == "'000000B9" |
as column(column_list[i]) == "'000000C1" |
as column(column_list[i]) == "'000000CC" |
as column(column_list[i]) == "'000000DF" |
as column(column_list[i]) == "'000000E2" |
as column(column_list[i]) == "'0000023B" |
as column(column_list[i]) == "'00000D15" |
as column(column_list[i]) == "'00000D16" |
as column(column_list[i]) == "'00000D1A" |
as column(column_list[i]) == "'00000DEF" |
as column(column_list[i]) == "'00000DF0" |
as column(column_list[i]) == "'00000DF3" |
as column(column_list[i]) == "'00000E6A" |
as column(column_list[i]) == "'00000E6D" |
as column(column_list[i]) == "'00000EB2" |
as column(column_list[i]) == "'00000ED6" |
as column(column_list[i]) == "'00000F1A" );
dt << delete rows;
);
