{"id":10420,"date":"2022-11-11T16:28:59","date_gmt":"2022-11-11T15:28:59","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10420"},"modified":"2023-01-07T20:51:07","modified_gmt":"2023-01-07T19:51:07","slug":"les-caracteres-generiques-jokers","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10420","title":{"rendered":"Les caract\u00e8res g\u00e9n\u00e9riques (\u00ab\u00a0jokers\u00a0\u00bb)"},"content":{"rendered":"<p style=\"text-align: justify;\">Un caract\u00e8re g\u00e9n\u00e9rique remplace un ou plusieurs caract\u00e8res dans une recherche ou une requ\u00eate.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10421\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/JOKERS.png\" alt=\"JOKERS\" width=\"583\" height=\"307\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/JOKERS.png 583w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/JOKERS-300x158.png 300w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/p>\n<p style=\"text-align: justify;\">Les caract\u00e8res g\u00e9n\u00e9riques sont :<\/p>\n<ul>\n<li style=\"text-align: justify;\">l\u2019ast\u00e9risque (*) qui correspond \u00e0 une s\u00e9quence de caract\u00e8res<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"text-align: justify;\">Exemples :<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"text-align: justify;\">CALV* : cha\u00eene commen\u00e7ant par CALV comme CALVADOS, CALVITIE\u2026<\/li>\n<li style=\"text-align: justify;\">*DIE : cha\u00eene se terminant par DIE comme NORMANDIE, COMEDIE\u2026<\/li>\n<li style=\"text-align: justify;\">*RAN* : cha\u00eene comprenant la cha\u00eene RAN comme FRANCE, CRANE\u2026<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"text-align: justify;\">le point d\u2019interrogation (?) qui correspond \u00e0 un caract\u00e8re.&nbsp;<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Exemples :<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>CO?PTE : COMPTE, COOPTE\u2026<\/li>\n<li>C??PTE : COMPTE, COOPTE, CRYPTE\u2026<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Les deux jokers * et ? sont utilisables conjointement dans la m\u00eame s\u00e9quence de recherche.<\/p>\n<p style=\"text-align: justify;\">Pour rechercher un v\u00e9ritable point d\u2019interrogation ou ast\u00e9risque, taper un tilde (~) avant ce caract\u00e8re.<\/p>\n<p style=\"text-align: justify;\">Les caract\u00e8res g\u00e9n\u00e9riques sont utilisables dans les contextes suivants :<\/p>\n<ul>\n<li style=\"text-align: justify;\">Excel : filtres, <a href=\"https:\/\/www.auditsi.eu\/?tag=tcd\">tableau crois\u00e9 dynamique<\/a>, RECHERCHEV\u2026 ;<\/li>\n<li style=\"text-align: justify;\">ACCESS : filtres ;<\/li>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/?tag=requete-sql\">Requ\u00eates SQL<\/a> (exemple : <a href=\"https:\/\/www.auditsi.eu\/?p=9624\">op\u00e9rateur de comparaison LIKE<\/a>).<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet : <a href=\"https:\/\/www.auditsi.eu\/?cat=2765\">Analyse de donn\u00e9es et automatisation<\/a> \/ <a href=\"https:\/\/www.auditsi.eu\/?glossary=excel\">Tout savoir sur Excel<\/a>&nbsp;\/&nbsp;<a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"https:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a><\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Les%20caract%C3%A8res%20g%C3%A9n%C3%A9riques%20%28%C2%AB%C2%A0jokers%C2%A0%C2%BB%29\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Un caract\u00e8re g\u00e9n\u00e9rique remplace un ou plusieurs caract\u00e8res dans une recherche ou une requ\u00eate. Les caract\u00e8res g\u00e9n\u00e9riques sont : l\u2019ast\u00e9risque (*) qui correspond \u00e0 une s\u00e9quence de caract\u00e8res Exemples : CALV* : cha\u00eene commen\u00e7ant par CALV comme CALVADOS, CALVITIE\u2026 *DIE : cha\u00eene se terminant par DIE comme NORMANDIE, COMEDIE\u2026 *RAN* : cha\u00eene comprenant la cha\u00eene &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10420\" class=\"more-link\">Continue reading &lsquo;Les caract\u00e8res g\u00e9n\u00e9riques (\u00ab\u00a0jokers\u00a0\u00bb)&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Les%20caract%C3%A8res%20g%C3%A9n%C3%A9riques%20%28%C2%AB%C2%A0jokers%C2%A0%C2%BB%29\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[48,282],"tags":[2768,2024,294,2025,1976,57,182,2026],"class_list":["post-10420","post","type-post","status-publish","format-standard","hentry","category-excel","category-sql","tag-asterisque","tag-caractere-generique","tag-filtres","tag-joker","tag-like","tag-requete-sql","tag-tcd","tag-tilde"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10420"}],"version-history":[{"count":5,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10420\/revisions"}],"predecessor-version":[{"id":10463,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10420\/revisions\/10463"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}