首页 \ 问答 \ 捕获包含字母+数字的字段中的字母(Capture letters in field containing letters+numbers)

捕获包含字母+数字的字段中的字母(Capture letters in field containing letters+numbers)

 我正在尝试清理数据库中的一些数据。  
 我有一个包含字母和数字的列。  
 我想构建一个查询，它将捕获连续超过4个字母的所有字段。  
1293.8093CHINA34324            -- (YES)
MY32498VN34983-294TH32498PH    -- (NO)
WORLD_3244932                  -- (YES)
9HEY850249.243943              -- (NO)
32484359-78049                 -- (NO)
3294832.49234PROGRAMMATION     -- (YES)
 
 非常感谢你的帮助。 

I am trying to clean some data in my database. 
I have a column that contains both letters and numbers. 
I would like to build a query that will catch all the field for which there is more than 4 letters in a row. 
1293.8093CHINA34324            -- (YES)
MY32498VN34983-294TH32498PH    -- (NO)
WORLD_3244932                  -- (YES)
9HEY850249.243943              -- (NO)
32484359-78049                 -- (NO)
3294832.49234PROGRAMMATION     -- (YES)
 
Thx a lot for your help.

原文：https://stackoverflow.com/questions/41376095

更新时间：2023-04-08 22:04

最满意答案

 试试这个，你的javascript序列不正确。  
<head>
 <script src="http://code.jquery.com/jquery-1.7.1.min.js" type="text/javascript"></script>
 <script src="http://gsgd.co.uk/sandbox/jquery/easing/jquery.easing.1.3.js" type="text/javascript" ></script>
 <script src="http://www.google.com/jsapi" type="text/javascript"></script>
 <script type="text/javascript">
   $(document).ready(function(){
      $('.topnav li').find('a[href]').parent().each(function() {
        var li = $(this),
        a = li.find('a'),
        div = $('<div>' + '<\/div>');

        li.hover(function() {
        a.stop().animate({marginTop: '-64'}, 600, "easeOutBack");
      },
      function() {
        a.stop().animate({marginTop: '0'}, 500, "easeOutBack");
      })
      .append(div);
    });
  });
 </script>
</head>
 
 我在当地测试过，（见屏幕截图）  
 
 希望对你有效。 

Try this, your sequence of including javascript was incorrect. 
<head>
 <script src="http://code.jquery.com/jquery-1.7.1.min.js" type="text/javascript"></script>
 <script src="http://gsgd.co.uk/sandbox/jquery/easing/jquery.easing.1.3.js" type="text/javascript" ></script>
 <script src="http://www.google.com/jsapi" type="text/javascript"></script>
 <script type="text/javascript">
   $(document).ready(function(){
      $('.topnav li').find('a[href]').parent().each(function() {
        var li = $(this),
        a = li.find('a'),
        div = $('<div>' + '<\/div>');

        li.hover(function() {
        a.stop().animate({marginTop: '-64'}, 600, "easeOutBack");
      },
      function() {
        a.stop().animate({marginTop: '0'}, 500, "easeOutBack");
      })
      .append(div);
    });
  });
 </script>
</head>
 
I have tested locally, (see the screen shot) 
 
Hope it works for you.

捕获包含字母+数字的字段中的字母(Capture letters in field containing letters+numbers)

最满意答案

相关问答

代码适用于JSFiddle，但不适用于本地文件(code works on JSFiddle but not in local file)[2022-07-22]

Jquery代码适用于JsFiddle，但不再适用于我的计算机(Jquery code works on JsFiddle, but not on my computer anymore)[2023-05-23]

根据下拉选择显示文本（代码适用于jsfiddle但不适用于网站？）[关闭](Display text based on drop down selection (code works on jsfiddle but not website?) [closed])[2023-01-10]

HTML代码适用于JSFiddle，但不适用于网站？(HTML code works in JSFiddle but not on website?)[2022-09-06]