{"id":922,"date":"2014-11-10T11:40:59","date_gmt":"2014-11-10T10:40:59","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=922"},"modified":"2022-11-21T11:16:43","modified_gmt":"2022-11-21T10:16:43","slug":"filemaker-extraire-des-donnees-dune-rubrique","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/11\/filemaker-extraire-des-donnees-dune-rubrique\/","title":{"rendered":"FileMaker &#8211; Extraire des donn\u00e9es d&rsquo;une rubrique"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Vous disposez d&rsquo;une base de donn\u00e9es dont une rubrique sert \u00e0 stocker des codes d&rsquo;articles. Ce code est compos\u00e9 d&rsquo;un nombre diff\u00e9rent de caract\u00e8res alphanum\u00e9riques et contient \u00e9galement plusieurs points servant \u00e0 s\u00e9parer les donn\u00e9es, par ex. XYZ.1.070.9001.50 ou XYZ.1.060.9001.2580.<\/p>\n<p>Vous aimeriez s\u00e9parer les donn\u00e9es de ce code afin d&rsquo;obtenir 2 rubriques distinctes (d\u00e9but de code et fin de code). Le d\u00e9but du code va jusqu&rsquo;au 10\u00e8me caract\u00e8re (XYZ.1.060.) et la fin du code d\u00e9marre au 11\u00e8me caract\u00e8re jusqu&rsquo;au dernier (sachant que le nombre de caract\u00e8res composant la fin du code peut compter de 8 \u00e0 10 caract\u00e8res).<\/p>\n<h4><strong>Solution<\/strong><\/h4>\n<ul>\n<li>Cr\u00e9ez 2 rubriques suppl\u00e9mentaires de type Calcul appel\u00e9e D\u00e9butCode et FinCode<\/li>\n<li>La rubrique D\u00e9butCode aura comme formule : Extrait ( Code ; 1 ; 9 )<\/li>\n<li>La rubrique FinCode aura comme formule : Extrait ( Code ; 11; 10 )<\/li>\n<\/ul>\n<p>La formule Extrait ( Code ; 1 ; 9 ) fonctionne de cette fa\u00e7on : FileMaker extrait de gauche \u00e0 droite 9 caract\u00e8res de la rubrique Code en partant du 1er caract\u00e8re. La formule Extrait (Code ; 11; 10 ) extrait 10 caract\u00e8res (ou moins) en partant du 11\u00e8me caract\u00e8re du code.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous disposez d&rsquo;une base de donn\u00e9es dont une rubrique sert \u00e0 stocker des codes d&rsquo;articles. Ce code est compos\u00e9 d&rsquo;un nombre diff\u00e9rent de caract\u00e8res alphanum\u00e9riques et contient&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3498,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[5],"tags":[43,10],"class_list":{"0":"post-922","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-filemaker","8":"tag-fonction","9":"tag-rubrique"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=922"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/922\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3498"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}