{"id":1550,"date":"2016-01-29T12:17:57","date_gmt":"2016-01-29T11:17:57","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=1550"},"modified":"2022-11-21T11:05:10","modified_gmt":"2022-11-21T10:05:10","slug":"filemaker-extraire-des-donnees-dune-rubrique-multivaluee","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2016\/01\/filemaker-extraire-des-donnees-dune-rubrique-multivaluee\/","title":{"rendered":"FileMaker &#8211; Extraire des donn\u00e9es d&rsquo;une rubrique multivalu\u00e9e"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Dans votre base de donn\u00e9es, vous disposez d&rsquo;une rubrique (appel\u00e9e \u00ab\u00a0Cat\u00e9gories\u00a0\u00bb) multivalu\u00e9e de 10 valeurs et vous souhaitez pr\u00e9senter ces valeurs dans une autre rubrique. Les valeurs doivent donc \u00eatre extraites et plac\u00e9es \u00e0 la suite les unes des autres dans une seule rubrique. Pour des raisons esth\u00e9tiques, vous aimeriez ajouter un b\u00e2ton entre les valeurs ainsi qu&rsquo;une majuscule en d\u00e9but de chaque mot.<\/p>\n<h4><strong>Solution<\/strong><\/h4>\n<ul>\n<li>Cr\u00e9ez une nouvelle rubrique appel\u00e9e \u00ab\u00a0Toutes les cat\u00e9gories\u00a0\u00bb de type Calcul<\/li>\n<li>Saisissez le calcul suivant dans la rubrique<br \/>\n(si la premi\u00e8re valeur de la rubrique Cat\u00e9gories est diff\u00e9rent de vide, alors obtenir la valeur, l&rsquo;\u00e9crire avec une majuscule en d\u00e9but de mot, faire suivre la valeur d&rsquo;un b\u00e2ton, sinon ne rien inscrire, puis ajouter la 2\u00e8me valeur&#8230;) :<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1715 size-full\" src=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2016\/01\/calcul.png\" alt=\"calcul\" width=\"697\" height=\"271\" srcset=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2016\/01\/calcul.png 697w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2016\/01\/calcul-300x117.png 300w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2016\/01\/calcul-624x243.png 624w\" sizes=\"auto, (max-width: 697px) 100vw, 697px\" \/><\/p>\n<ul>\n<li>Ins\u00e9rez cette nouvelle rubrique dans votre mod\u00e8le afin d&rsquo;obtenir le r\u00e9sultat suivant :<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1714 size-full\" src=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2016\/01\/rubrique-multi.png\" alt=\"rubrique multi\" width=\"625\" height=\"167\" srcset=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2016\/01\/rubrique-multi.png 625w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2016\/01\/rubrique-multi-300x80.png 300w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2016\/01\/rubrique-multi-624x167.png 624w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Dans votre base de donn\u00e9es, vous disposez d&rsquo;une rubrique (appel\u00e9e \u00ab\u00a0Cat\u00e9gories\u00a0\u00bb) multivalu\u00e9e de 10 valeurs et vous souhaitez pr\u00e9senter ces valeurs dans une autre rubrique. Les valeurs&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":[74,10],"class_list":{"0":"post-1550","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-filemaker","8":"tag-calcul","9":"tag-rubrique"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/1550","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=1550"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/1550\/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=1550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=1550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=1550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}