{"id":142,"date":"2014-01-11T22:18:33","date_gmt":"2014-01-12T03:18:33","guid":{"rendered":"http:\/\/access-diva.com\/blog\/?p=142"},"modified":"2015-12-30T22:52:33","modified_gmt":"2015-12-31T03:52:33","slug":"combining-fields","status":"publish","type":"post","link":"https:\/\/access-diva.com\/blog\/?p=142","title":{"rendered":"Combining Fields"},"content":{"rendered":"

Combining fields is easy enough BUT when there’s a chance one of the fields might be blank (empty), well, that presents an issue.\u00a0 Especially, when you don’t want the comma, period\u00a0or dash to show if the adjoining\u00a0field is blank (empty), ie: Jane . Doe (no Middle Inital\u00a0so only the period shows) or 9999- (no Order Line Number so only the dash shows).<\/p>\n

Below are examples of how to combine the fields taking into account the adjoining field might be empty leaving off the perios, comma or dash (or any other symbol you might be using).<\/p>\n

1.\u00a0\u00a0Jane A. Doe<\/strong> and if no middle initial Jane Doe<\/strong> use…<\/p>\n

\r\n[cpFirstName] & (" " + [cpMiddleInitial] + ".") & (" " + [cpLastName])\r\n<\/pre>\n
2.\u00a0\u00a0Doe, Jane A.<\/strong>; and if no Middle Initial, Doe, Jane<\/strong>; and if no Last Name Jane, A.<\/strong> use…<\/p>\n
\r\n([cpLastName] + ", ")\u00a0 & [cpFirstName] & (" " + [cpMiddleInitial] + ".")\r\n<\/pre>\n
3.\u00a0\u00a0 Doe, Jane<\/strong> and leaving either First Name or Last Name blank will not result in an empty space before or after the name using…<\/p>\n
\r\n([cpLastName] + ", ") & [cpFirstName] OR [cpLastName] & (", " + [cpFirstName])\r\n<\/pre>\n
4.\u00a0\u00a0Doe Jane<\/strong> and leaving either First Name or Last Name blank will not result in an empty space before or after the name using…<\/p>\n
\r\n([cpLastName]+" ") & [cpFirstName]\r\n<\/pre>\n
5.\u00a0\u00a0Jane Doe<\/strong> and leaving either First Name or Last Name blank will not result in an empty space before or after the name using…<\/p>\n
\r\n[cpFirstName] & (" "+[cpLastName])\r\n<\/pre>\n
6.\u00a0\u00a09999-1<\/strong> and if there is no Order Line Number 9999<\/strong> use…<\/p>\n
\r\n[odOrderID] & ("-"+[odOrderLineNumber])\r\n<\/pre>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Combining fields is easy enough BUT when there’s a chance one of the fields might be blank (empty), well, that presents an issue. Especially, when you don’t want the comma, period or dash to show if the adjoining field is blank (empty), ie: Jane . Doe (no Middle Inital so only the period shows) or […]<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,38,29],"tags":[75,77],"class_list":["post-142","post","type-post","status-publish","format-standard","hentry","category-access-tips","category-fields","category-strings","tag-fields","tag-strings","odd"],"_links":{"self":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=142"}],"version-history":[{"count":5,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/142\/revisions"}],"predecessor-version":[{"id":305,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/142\/revisions\/305"}],"wp:attachment":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}