{"id":3855,"date":"2017-08-21T14:34:13","date_gmt":"2017-08-21T14:34:13","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-extract-the-last-segment-of-a-netsuite-job-id-from-entity-id-2\/"},"modified":"2026-07-28T18:26:11","modified_gmt":"2026-07-28T18:26:11","slug":"comment-extraire-le-dernier-segment-dun-identifiant-de-tache-netsuite-a-partir-de-lidentifiant-dentite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-extraire-le-dernier-segment-dun-identifiant-de-tache-netsuite-a-partir-de-lidentifiant-dentite\/","title":{"rendered":"Comment extraire le dernier segment d&rsquo;un identifiant de t\u00e2che NetSuite \u00e0 partir de l&rsquo;identifiant d&rsquo;entit\u00e9 ?"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"D\u00e9couvrez comment cr\u00e9er un champ de formule permettant d\u2019isoler l\u2019identifiant sp\u00e9cifique d\u2019un projet ou d\u2019une mission lorsque le champ \u00ab entityid \u00bb contient des valeurs hi\u00e9rarchiques s\u00e9par\u00e9es par des deux-points.","ga_short_answer":"Pour extraire le segment final d\u2019un identifiant de t\u00e2che NetSuite \u00e0 partir du champ \u00ab entityid \u00bb, en particulier lorsqu\u2019il est structur\u00e9 hi\u00e9rarchiquement \u00e0 l\u2019aide de deux-points, utilisez une formule combinant les fonctions SUBSTR et INSTR. Cette approche permet de localiser pr\u00e9cis\u00e9ment le dernier deux-points et d\u2019extraire les caract\u00e8res qui suivent, garantissant ainsi que seul l\u2019identifiant de t\u00e2che sp\u00e9cifique soit renvoy\u00e9 \u00e0 des fins de reporting ou de remplissage de champs personnalis\u00e9s.","ga_scenario":"Les utilisateurs de NetSuite rencontrent souvent des champs \u00ab entityid \u00bb pour des projets ou des missions qui contiennent plusieurs segments s\u00e9par\u00e9s par des deux-points (par exemple, \u00ab Projet parent : Sous-projet : ID de mission \u00bb). Lors de la cr\u00e9ation de rapports ou de l\u2019int\u00e9gration, il est n\u00e9cessaire d\u2019extraire uniquement l\u2019identifiant de mission final, le plus sp\u00e9cifique, de cette cha\u00eene hi\u00e9rarchique, plut\u00f4t que l\u2019int\u00e9gralit\u00e9 de l\u2019\u00ab entityid \u00bb.","ga_solution":"Pour extraire le dernier segment d\u2019un identifiant de t\u00e2che NetSuite \u00e0 partir du champ \u00ab entityid \u00bb, une formule peut \u00eatre impl\u00e9ment\u00e9e dans un <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-access-child-record-values-in-a-netsuite-saved-search\/\">champ personnalis\u00e9 ou une recherche enregistr\u00e9e<\/a>\n\n. Cette formule utilise la fonction INSTR pour d\u00e9terminer la position du dernier deux-points, puis la fonction SUBSTR pour extraire les caract\u00e8res qui le suivent imm\u00e9diatement, y compris un espace suppos\u00e9. La formule corrig\u00e9e, garantissant que tous les param\u00e8tres requis pour la fonction SUBSTR sont fournis, est la suivante :\n\n```\nSUBSTR({entityid}, INSTR({entityid}, ':', -1) + 2, LENGTH({entityid}) - (INSTR({entityid}, ':', -1) + 2) + 1)\n```\n\n. Cette formule renverra le num\u00e9ro de t\u00e2che sp\u00e9cifique, en supprimant ainsi efficacement tout identifiant de projet hi\u00e9rarchique pr\u00e9c\u00e9dent.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:34:13-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"get the list of all job id in NetSuite","ga_ans_id":"ANS-0196","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The SUBSTR function in NetSuite's formula engine typically requires three parameters (string, start position, length), but the provided formula only includes two, which is syntactically incomplete.","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3855","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-administrateur-netsuite","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":91,"label":"Recherches enregistr\u00e9es et formules"},{"value":3,"label":"Saved Searches & Formulas"},{"value":91,"label":"Recherches enregistr\u00e9es et formules"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":92,"label":"Niveau interm\u00e9diaire"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3855","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3855\/revisions"}],"predecessor-version":[{"id":5776,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3855\/revisions\/5776"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3855"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3855"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3855"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}