{"id":2966,"date":"2018-11-07T15:48:18","date_gmt":"2018-11-07T14:48:18","guid":{"rendered":"https:\/\/app.lib.uliege.be\/alma\/?p=2966"},"modified":"2018-11-07T16:48:36","modified_gmt":"2018-11-07T15:48:36","slug":"afficher-un-seul-isbn-13-par-colonne","status":"publish","type":"post","link":"https:\/\/services.lib.uliege.be\/alma\/afficher-un-seul-isbn-13-par-colonne\/","title":{"rendered":"Afficher un seul ISBN13 par colonne"},"content":{"rendered":"

Par d\u00e9faut, Analytics affiche dans une m\u00eame colonne tous les ISBN pr\u00e9sents dans les diff\u00e9rents champs 020 d’une notice bibliographique et ce, dans leur version ISBN 10 et 13.<\/p>\n

Dans Alma :<\/p>\n

\"\"<\/p>\n

Dans Analytics :<\/p>\n

\"\"<\/p>\n

Pour n’afficher que les ISBN 13 et les isoler dans autant de colonnes qu’il y a d’ISBN13, commencez par remplacer la formule de la colonne ISBN par :<\/p>\n

Evaluate(‘regexp_substr(%1,\u00a0\u00bb[0-9]{13}\u00a0\u00bb,1, 1 )’,\u00a0\u00bbBibliographic Details\u00a0\u00bb.\u00a0\u00bbISBN\u00a0\u00bb)<\/em><\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Puis ajoutez une seconde fois la colonne ISBN dans les crit\u00e8res et modifiez la formule de la m\u00eame mani\u00e8re en ne changeant que le dernier chiffre de l’expression r\u00e9guli\u00e8re (1 devient 2 puis 3 etc.) :<\/p>\n

Evaluate(‘regexp_substr(%1,\u00a0\u00bb[0-9]{13}\u00a0\u00bb,1, 2<\/strong> )’,\u00a0\u00bbBibliographic Details\u00a0\u00bb.\u00a0\u00bbISBN\u00a0\u00bb)<\/em><\/p>\n

Evaluate(‘regexp_substr(%1,\u00a0\u00bb[0-9]{13}\u00a0\u00bb,1, 3<\/b>\u00a0)’,\u00a0\u00bbBibliographic Details\u00a0\u00bb.\u00a0\u00bbISBN\u00a0\u00bb)<\/em><\/p>\n

\"\"<\/p>\n

Si une notice a moins d’ISBN que de colonnes pr\u00e9vues, les colonnes exc\u00e9dentes seront vides.<\/p>\n

Pour chaque colonne, via le m\u00eame onglet \u00ab\u00a0Edit Column Formula\u00a0\u00bb, penser \u00e0 \u00e9diter l’intitul\u00e9 (Column Heading = ISBN1, ISBN2…)<\/p>\n

R\u00e9sultat final obtenu :<\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Par d\u00e9faut, Analytics affiche dans une m\u00eame colonne tous les ISBN pr\u00e9sents dans les diff\u00e9rents champs 020 d’une notice bibliographique et ce, dans leur version ISBN 10 et 13. Dans Alma : Dans Analytics : Pour n’afficher que les ISBN 13 et les isoler dans autant de colonnes qu’il y… Lire l'int\u00e9gralit\u00e9…Afficher un seul ISBN13 par colonne<\/span><\/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":[105],"class_list":["post-2966","post","type-post","status-publish","format-standard","hentry","category-analytics","tag-isbn","content-layout-excerpt-thumb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7rJUv-LQ","_links":{"self":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/2966","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=2966"}],"version-history":[{"count":11,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/2966\/revisions"}],"predecessor-version":[{"id":3013,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/2966\/revisions\/3013"}],"wp:attachment":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/media?parent=2966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/categories?post=2966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/tags?post=2966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}