{"id":77,"date":"2015-07-16T16:00:26","date_gmt":"2015-07-16T16:00:26","guid":{"rendered":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/"},"modified":"2019-07-10T15:11:11","modified_gmt":"2019-07-10T15:11:11","slug":"how-to-extract-part-of-one-property-into-another-property","status":"publish","type":"post","link":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/","title":{"rendered":"How to extract part of one property into another property"},"content":{"rendered":"

Imagine you have a property that contains a data string, and you need to extract a section of the data into a new property.<\/p>\n

How do you do it without having to manually enter the data into the new property?<\/p>\n

It can be done by using the Substring function of the PLANTDEFINECALCPROPERTIES command:<\/p>\n

So for example, you have a 6 digit property called TagCode<\/strong> for hand valves that includes a text prefix followed by a hyphen and then a number (eg, AA-101) and you would like to extract the number (101) into a new property without including the text prefix.<\/p>\n

This can be achieved using the following syntax "Substring(TagCode,3,3)":<\/p>\n

\"PlantDefineCalcProperties\"<\/a><\/p>\n

The resulting calculated property, is a new property, called TagAnno<\/strong> that only includes the last 3 digits from the TagCode<\/strong> property:<\/p>\n

\"Result\"<\/a><\/p>\n

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

Imagine you have a property that contains a data string, and you need to extract a section of the data into a new property.<\/p>\n

How do you do it without having to manually enter the data into the new property?<\/p>\n

It can be done by using the Substring function of the PLANTDEFINECALCPROPERTIES command:<\/p>\n

So for example,<\/p>\n","protected":false},"author":26873,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[9,4],"tags":[],"class_list":["post-77","post","type-post","status-publish","format-standard","hentry","category-pid","category-plant-3d"],"acf":[],"yoast_head":"\nHow to extract part of one property into another property - In the Pipes<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to extract part of one property into another property - In the Pipes\" \/>\n<meta property=\"og:description\" content=\"Imagine you have a property that contains a data string, and you need to extract a section of the data into a new property. How do you do it without having to manually enter the data into the new property? It can be done by using the Substring function of the PLANTDEFINECALCPROPERTIES command: So for example,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/\" \/>\n<meta property=\"og:site_name\" content=\"In the Pipes\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-16T16:00:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-10T15:11:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/in-the-pipes.typepad.com\/.a\/6a00d835007d0b69e201b7c7af825c970b-800wi\" \/>\n<meta name=\"author\" content=\"Dan Scales\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dan Scales\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/\"},\"author\":{\"name\":\"Dan Scales\",\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/#\\\/schema\\\/person\\\/2d6b9b98759bf623545794bcc03bed08\"},\"headline\":\"How to extract part of one property into another property\",\"datePublished\":\"2015-07-16T16:00:26+00:00\",\"dateModified\":\"2019-07-10T15:11:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/\"},\"wordCount\":140,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/in-the-pipes.typepad.com\\\/.a\\\/6a00d835007d0b69e201b7c7af825c970b-800wi\",\"articleSection\":[\"P&ID\",\"Plant 3D\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/\",\"url\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/\",\"name\":\"How to extract part of one property into another property - In the Pipes\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/in-the-pipes.typepad.com\\\/.a\\\/6a00d835007d0b69e201b7c7af825c970b-800wi\",\"datePublished\":\"2015-07-16T16:00:26+00:00\",\"dateModified\":\"2019-07-10T15:11:11+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/#\\\/schema\\\/person\\\/2d6b9b98759bf623545794bcc03bed08\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/#primaryimage\",\"url\":\"https:\\\/\\\/in-the-pipes.typepad.com\\\/.a\\\/6a00d835007d0b69e201b7c7af825c970b-800wi\",\"contentUrl\":\"https:\\\/\\\/in-the-pipes.typepad.com\\\/.a\\\/6a00d835007d0b69e201b7c7af825c970b-800wi\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/2015\\\/07\\\/16\\\/how-to-extract-part-of-one-property-into-another-property\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to extract part of one property into another property\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/#website\",\"url\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/\",\"name\":\"In the Pipes\",\"description\":\"Tips and Tricks from the Autodesk Product Support Team\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/#\\\/schema\\\/person\\\/2d6b9b98759bf623545794bcc03bed08\",\"name\":\"Dan Scales\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/wp-content\\\/uploads\\\/sites\\\/134\\\/2019\\\/07\\\/DS-1.png\",\"url\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/wp-content\\\/uploads\\\/sites\\\/134\\\/2019\\\/07\\\/DS-1.png\",\"contentUrl\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/wp-content\\\/uploads\\\/sites\\\/134\\\/2019\\\/07\\\/DS-1.png\",\"caption\":\"Dan Scales\"},\"description\":\"Dan studied Construction at Sheffield Hallam University and Building Surveying at Heriot Watt University in Edinburgh. Joining Autodesk in 2000, Dan has provided support for a wide variety of Autodesk products and has been supporting Plant and P&ID since the very first releases. Prior to joining Autodesk, Dan gained experience working as a design draftsman for a number of consulting engineers in and around Edinburgh. Outside of work Dan enjoys riding motorcycles, road bikes and mountain bikes.\",\"url\":\"https:\\\/\\\/blogs.autodesk.com\\\/in-the-pipes\\\/author\\\/danscales\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to extract part of one property into another property - In the Pipes","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/","og_locale":"en_US","og_type":"article","og_title":"How to extract part of one property into another property - In the Pipes","og_description":"Imagine you have a property that contains a data string, and you need to extract a section of the data into a new property. How do you do it without having to manually enter the data into the new property? It can be done by using the Substring function of the PLANTDEFINECALCPROPERTIES command: So for example,","og_url":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/","og_site_name":"In the Pipes","article_published_time":"2015-07-16T16:00:26+00:00","article_modified_time":"2019-07-10T15:11:11+00:00","og_image":[{"url":"https:\/\/in-the-pipes.typepad.com\/.a\/6a00d835007d0b69e201b7c7af825c970b-800wi","type":"","width":"","height":""}],"author":"Dan Scales","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dan Scales","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/#article","isPartOf":{"@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/"},"author":{"name":"Dan Scales","@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/#\/schema\/person\/2d6b9b98759bf623545794bcc03bed08"},"headline":"How to extract part of one property into another property","datePublished":"2015-07-16T16:00:26+00:00","dateModified":"2019-07-10T15:11:11+00:00","mainEntityOfPage":{"@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/"},"wordCount":140,"commentCount":0,"image":{"@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/#primaryimage"},"thumbnailUrl":"https:\/\/in-the-pipes.typepad.com\/.a\/6a00d835007d0b69e201b7c7af825c970b-800wi","articleSection":["P&ID","Plant 3D"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/","url":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/","name":"How to extract part of one property into another property - In the Pipes","isPartOf":{"@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/#primaryimage"},"image":{"@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/#primaryimage"},"thumbnailUrl":"https:\/\/in-the-pipes.typepad.com\/.a\/6a00d835007d0b69e201b7c7af825c970b-800wi","datePublished":"2015-07-16T16:00:26+00:00","dateModified":"2019-07-10T15:11:11+00:00","author":{"@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/#\/schema\/person\/2d6b9b98759bf623545794bcc03bed08"},"breadcrumb":{"@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/#primaryimage","url":"https:\/\/in-the-pipes.typepad.com\/.a\/6a00d835007d0b69e201b7c7af825c970b-800wi","contentUrl":"https:\/\/in-the-pipes.typepad.com\/.a\/6a00d835007d0b69e201b7c7af825c970b-800wi"},{"@type":"BreadcrumbList","@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/2015\/07\/16\/how-to-extract-part-of-one-property-into-another-property\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blogs.autodesk.com\/in-the-pipes\/"},{"@type":"ListItem","position":2,"name":"How to extract part of one property into another property"}]},{"@type":"WebSite","@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/#website","url":"https:\/\/blogs.autodesk.com\/in-the-pipes\/","name":"In the Pipes","description":"Tips and Tricks from the Autodesk Product Support Team","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.autodesk.com\/in-the-pipes\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/#\/schema\/person\/2d6b9b98759bf623545794bcc03bed08","name":"Dan Scales","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blogs.autodesk.com\/in-the-pipes\/wp-content\/uploads\/sites\/134\/2019\/07\/DS-1.png","url":"https:\/\/blogs.autodesk.com\/in-the-pipes\/wp-content\/uploads\/sites\/134\/2019\/07\/DS-1.png","contentUrl":"https:\/\/blogs.autodesk.com\/in-the-pipes\/wp-content\/uploads\/sites\/134\/2019\/07\/DS-1.png","caption":"Dan Scales"},"description":"Dan studied Construction at Sheffield Hallam University and Building Surveying at Heriot Watt University in Edinburgh. Joining Autodesk in 2000, Dan has provided support for a wide variety of Autodesk products and has been supporting Plant and P&ID since the very first releases. Prior to joining Autodesk, Dan gained experience working as a design draftsman for a number of consulting engineers in and around Edinburgh. Outside of work Dan enjoys riding motorcycles, road bikes and mountain bikes.","url":"https:\/\/blogs.autodesk.com\/in-the-pipes\/author\/danscales\/"}]}},"_links":{"self":[{"href":"https:\/\/blogs.autodesk.com\/in-the-pipes\/wp-json\/wp\/v2\/posts\/77","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.autodesk.com\/in-the-pipes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.autodesk.com\/in-the-pipes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.autodesk.com\/in-the-pipes\/wp-json\/wp\/v2\/users\/26873"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.autodesk.com\/in-the-pipes\/wp-json\/wp\/v2\/comments?post=77"}],"version-history":[{"count":0,"href":"https:\/\/blogs.autodesk.com\/in-the-pipes\/wp-json\/wp\/v2\/posts\/77\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.autodesk.com\/in-the-pipes\/wp-json\/wp\/v2\/media?parent=77"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.autodesk.com\/in-the-pipes\/wp-json\/wp\/v2\/categories?post=77"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.autodesk.com\/in-the-pipes\/wp-json\/wp\/v2\/tags?post=77"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}