根据列值删除行

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,

有没有办法根据它包含的值删除行?例如,我有一个表,其中包含一个包含URL值的列,例如,

/uk/quitclock/om2.asp

/uk/quitclock/om666.wav

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?

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

2 个解决方案

#1

Try this on Database

在数据库上试试吧

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

#2

for excel:

=OR(RIGHT(A1,3)="wav",RIGHT(A1,3)="gif",RIGHT(A1,4)="jpeg")

delete the TRUEs

删除TRUE

#1