{"id":4834,"date":"2019-07-04T11:22:37","date_gmt":"2019-07-04T09:22:37","guid":{"rendered":"https:\/\/app.lib.uliege.be\/alma\/?p=4834"},"modified":"2019-07-04T11:22:44","modified_gmt":"2019-07-04T09:22:44","slug":"convertir-une-donnee-texte-en-donnee-numerique-combiner-differentes-formules-entre-elles","status":"publish","type":"post","link":"https:\/\/services.lib.uliege.be\/alma\/convertir-une-donnee-texte-en-donnee-numerique-combiner-differentes-formules-entre-elles\/","title":{"rendered":"Convertir une donn\u00e9e texte en donn\u00e9e num\u00e9rique (+ combiner diff\u00e9rentes formules entre elles)"},"content":{"rendered":"<p>Admettons que l&rsquo;on dispose d&rsquo;un champ texte contenant des donn\u00e9es chiffr\u00e9es que l&rsquo;on aimerait pouvoir exploiter via des filtres ou en combinaison avec d&rsquo;autres valeurs.<\/p>\n<p>Ex : le champ \u00ab\u00a0Physical Item Details\u00a0\u00bb.\u00a0\u00bbStatistics Note 2&Prime; contient pour chaque item le nombre total de pr\u00eats dans notre pr\u00e9c\u00e9dent SIGB (Aleph) et la date du dernier pr\u00eat. Les donn\u00e9es se pr\u00e9sentent sous la forme suivante :<\/p>\n<p>No. Loans: 000 | LastDateReturn: 00000000<\/p>\n<p>Si l&rsquo;on souhaite par exemple exploiter le nombre de pr\u00eats, cela va passer par 3 \u00e9tapes qui constitueront au final une seule et unique formule.<\/p>\n<p>Etape 1 &gt; ne conserver que les 14 premiers caract\u00e8res<\/p>\n<pre>Formule : LEFT(\"Physical Item Details\".\"Statistics Note 2\", 14)\nR\u00e9sultats : \"No. Loans: 000\"<\/pre>\n<p>Etape 2 &gt; supprimer la chaine de caract\u00e8re \u00ab\u00a0No. Loans: \u00a0\u00bb<\/p>\n<pre>Formule : REPLACE(\"Physical Item Details\".\"Statistics Note 2\",'No. Loans: ','')\u00a0\nR\u00e9sultat : \"000\"<\/pre>\n<p>Etape 3 : convertir le r\u00e9sultat obtenu (donn\u00e9e texte) en donn\u00e9e num\u00e9rique. Note : Ceci n&rsquo;est pas possible via le menu d&rsquo;\u00e9dition des propri\u00e9t\u00e9s de la colonne.<\/p>\n<pre>Formule : CAST(\"Physical Item Details\".\"Statistics Note 2\" AS NUMERIC)\nR\u00e9sultat : \"000\"<\/pre>\n<p>Toutes ces \u00e9tapes doivent bien sur \u00eatre cumul\u00e9es pour arriver au r\u00e9sultat voulu. La formule compl\u00e8te prend alors la forme suivante :<\/p>\n<pre>CAST(REPLACE(LEFT(\"Physical Item Details\".\"Statistics Note 2\", 14),'No. Loans: ','') AS NUMERIC)<\/pre>\n<p>La valeur num\u00e9rique ainsi obtenue peut d\u00e9sormais \u00eatre exploit\u00e9e via des filtres, des tris etc. On pourra par exemple cr\u00e9er une nouvelle colonne de toute pi\u00e8ce qui additionnera les valeurs de pr\u00eats dans les 2 SIGB gr\u00e2ce \u00e0 la formule suivante :<\/p>\n<pre>\"Physical Item Details\".\"Num of Loans (Not In House)\"+CAST(REPLACE(LEFT(\"Physical Item Details\".\"Statistics Note 2\", 14),'No. Loans: ','') AS NUMERIC)<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Admettons que l&rsquo;on dispose d&rsquo;un champ texte contenant des donn\u00e9es chiffr\u00e9es que l&rsquo;on aimerait pouvoir exploiter via des filtres ou en combinaison avec d&rsquo;autres valeurs. Ex : le champ \u00ab\u00a0Physical Item Details\u00a0\u00bb.\u00a0\u00bbStatistics Note 2&Prime; contient pour chaque item le nombre total de pr\u00eats dans notre pr\u00e9c\u00e9dent SIGB (Aleph) et la&#8230; <a href=\"https:\/\/services.lib.uliege.be\/alma\/convertir-une-donnee-texte-en-donnee-numerique-combiner-differentes-formules-entre-elles\/\" class=\"readmore\">Lire l&#039;int\u00e9gralit\u00e9&#8230;<span class=\"screen-reader-text\">Convertir une donn\u00e9e texte en donn\u00e9e num\u00e9rique (+ combiner diff\u00e9rentes formules entre elles)<\/span><span class=\"fa fa-angle-double-right\" aria-hidden=\"true\"><\/span><\/a><\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[3],"tags":[76,101],"class_list":["post-4834","post","type-post","status-publish","format-standard","hentry","category-analytics","tag-combiner-concatener","tag-formules","content-layout-excerpt-thumb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7rJUv-1fY","_links":{"self":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/4834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/comments?post=4834"}],"version-history":[{"count":11,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/4834\/revisions"}],"predecessor-version":[{"id":4846,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/4834\/revisions\/4846"}],"wp:attachment":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/media?parent=4834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/categories?post=4834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/tags?post=4834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}