{"id":1483,"date":"2019-01-22T10:06:39","date_gmt":"2019-01-22T16:06:39","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1483"},"modified":"2019-01-22T10:06:39","modified_gmt":"2019-01-22T16:06:39","slug":"fixed-length-id","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1483","title":{"rendered":"Fixed length ID"},"content":{"rendered":"<p>I needed few months back to make a fixed-length ID iut if none-fixed-length numbers.<\/p>\n<p>SO I used the function REPT with RIGHT to force all numbers to be converted into fixed-length ID (mainly having leading zeros)<\/p>\n<p>And here is the formula<\/p>\n<p><!--more--><\/p>\n<p><code>=Right(Rept(\"0\", 12)&amp;J5, 12)<br \/>\n<\/code><\/p>\n<p>J5 is where the ID can be found<\/p>\n<p>12 is the length of the ID we wanted<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"  wp-image-1488 aligncenter\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2019\/01\/Rept.jpg\" alt=\"Rept\" width=\"694\" height=\"1178\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I needed few months back to make a fixed-length ID iut if none-fixed-length numbers. SO I used the function REPT with RIGHT to force all numbers to be converted into fixed-length ID (mainly having leading zeros) And here is the formula<\/p>\n","protected":false},"author":1,"featured_media":1498,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,49,50,8],"tags":[179,181],"class_list":["post-1483","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas","category-rept","category-right","category-texts-and-strings","tag-rept","tag-right"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1483"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1483\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1498"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}