{"id":2057,"date":"2025-12-17T12:43:31","date_gmt":"2025-12-17T13:43:31","guid":{"rendered":"http:\/\/gogetmuscle.com\/?p=2057"},"modified":"2025-12-17T17:43:18","modified_gmt":"2025-12-17T17:43:18","slug":"convert-line-item-term-to-a-number","status":"publish","type":"post","link":"http:\/\/gogetmuscle.com\/index.php\/2025\/12\/17\/convert-line-item-term-to-a-number\/","title":{"rendered":"Convert Line Item Term to a number"},"content":{"rendered":"<p><P>Now that we can create calculated Line Item properties, I am trying to create a property that uses the Term in the calculation.\u00a0 However the Term property is a string (eg. P12M) rather than a number.\u00a0 I&#8217;ve created a new &#8220;Line Item Term in Months&#8221; property but does anyone have any suggestions on how to convert the Term into a number?\u00a0 I know how to do it in Excel (using the SUBSTITUTE function) but this isnt available in HubSpot calcualted properties. I tried using the String-to-number function but it doesn&#8217;t wok as there are letters in the Term property.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Now that we can create calculated Line Item properties, I am trying to create a property that uses the Term in the calculation.\u00a0 However the Term property is a string (eg. P12M) rather than a number.\u00a0 I&#8217;ve created a new &#8220;Line Item Term in Months&#8221; property but does anyone have any suggestions on how to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[14],"tags":[],"_links":{"self":[{"href":"http:\/\/gogetmuscle.com\/index.php\/wp-json\/wp\/v2\/posts\/2057"}],"collection":[{"href":"http:\/\/gogetmuscle.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/gogetmuscle.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/gogetmuscle.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/gogetmuscle.com\/index.php\/wp-json\/wp\/v2\/comments?post=2057"}],"version-history":[{"count":1,"href":"http:\/\/gogetmuscle.com\/index.php\/wp-json\/wp\/v2\/posts\/2057\/revisions"}],"predecessor-version":[{"id":2058,"href":"http:\/\/gogetmuscle.com\/index.php\/wp-json\/wp\/v2\/posts\/2057\/revisions\/2058"}],"wp:attachment":[{"href":"http:\/\/gogetmuscle.com\/index.php\/wp-json\/wp\/v2\/media?parent=2057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/gogetmuscle.com\/index.php\/wp-json\/wp\/v2\/categories?post=2057"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/gogetmuscle.com\/index.php\/wp-json\/wp\/v2\/tags?post=2057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}