根据列值删除行 [英] DELETE row based on the column value

问题描述

我是否可以根据行中包含的值删除行? 例如， 我有一个表格，表格的一列中包含一个URL值，例如，

Is there a way for me to delete rows based on the value it contains? For example, I have a table with values in one column containing a URL value, for example,

/uk/quitclock/om2.asp

/uk/quitclock/om2.asp

/uk/quitclock/om666.wav

/uk/quitclock/om666.wav

在这里，我需要删除后缀为WAV，GIF或JPEG的行.我怎么做?如果不可能，那么excel中是否有任何公式可以帮助我做到这一点?

Here, I need to delete rows with suffixes ending with WAV, GIF, or JPEG. How do I do that? If it's not possible, then is there any formula in excel that can help me do it?

推荐答案

在数据库上尝试一下

DELETE FROM TABLE 
WHERE UPPER(COLUMN) LIKE '%.WAV' 
      OR UPPER(COLUMN) LIKE '%.GIF' 
      OR UPPER(COLUMN) LIKE '%.JPEG'

这篇关于根据列值删除行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！