本文介绍了根据列值删除行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我是否可以根据行中包含的值删除行? 例如, 我有一个表格,表格的一列中包含一个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'更多推荐
根据列值删除行
发布评论