<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Handle title casing company names without breaking acronyms? in Data Hub</title>
    <link>https://community.hubspot.com/t5/Data-Hub/Handle-title-casing-company-names-without-breaking-acronyms/m-p/1241923#M3353</link>
    <description>&lt;P&gt;Hey&amp;nbsp;&lt;a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/96622"&gt;@Alexander-tmp&lt;/a&gt;&amp;nbsp;- an interesting question for sure. I haven't personally solved this as I don't manage the CRM data like that anymore. However, one thing I was thinking of is something I heard about once. Let's see if I can explain it. You could layer in “original name” and audit trail in a custom property.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Here's what that looks like:&lt;/SPAN&gt;&lt;/P&gt;
&lt;OL&gt;
&lt;LI&gt;&lt;SPAN&gt;Create Original company name and copy inbound values there once, before any formatting workflows touch them.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI&gt;Only ever manipulate a working “Formatted company name,” then overwrite Company name once you’re happy.&lt;/LI&gt;
&lt;LI&gt;Add a small metadata field like “Last formatting workflow run date” so you can isolate records impacted by a bad rule and fix them in bulk later.&lt;/LI&gt;
&lt;/OL&gt;
&lt;P&gt;​This pattern is especially helpful when integrating multiple sources. It's a bit manual and requires regular auditing, but could help when your workflow fires when it shouldn't.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Another solution I found while poking around was also pretty manual, but may help with it. If you were to maintain an exceptions or accepted acronyms list, you could add a branch to your workflow. Here's how that could play out.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Acronym flag property:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Boolean: “Company name includes protected acronym”.&lt;/LI&gt;
&lt;LI&gt;Use workflow branches: if flag is true, skip title case; if false, format.​&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;Acronyms text property:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Store values like AMT; IBM; NASA.&lt;/LI&gt;
&lt;LI&gt;Use a workflow that only formats names when Company name does not contain any of those strings (contains none of “ AMT ”, “ IBM ”, etc.); maintain this list over time.​&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;Manual corrections queue:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Use a view filtered on “Recently updated by formatting workflow = true” AND “Name contains known acronym fragments,” and have a light-touch review step, rather than proofreading every company.​&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;It's a bit of work and not totally automatic, but does give you guardrails without deep engineering. Otherwise you might look into how Data Hub&amp;nbsp;(fka Operations Hub) could help you with custom formulas/custom code.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Curious to see if anyone else has ideas to solve as well!&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Thu, 15 Jan 2026 13:43:36 GMT</pubDate>
    <dc:creator>danmoyle</dc:creator>
    <dc:date>2026-01-15T13:43:36Z</dc:date>
    <item>
      <title>Handle title casing company names without breaking acronyms?</title>
      <link>https://community.hubspot.com/t5/Data-Hub/Handle-title-casing-company-names-without-breaking-acronyms/m-p/1240966#M3346</link>
      <description>&lt;P data-start="270" data-end="372"&gt;I’m looking for advice on a CRM automation challenge I’ve run into around &lt;STRONG data-start="344" data-end="371"&gt;company name formatting&lt;/STRONG&gt;.&lt;/P&gt;
&lt;P data-start="270" data-end="372"&gt;&amp;nbsp;&lt;/P&gt;
&lt;P data-start="374" data-end="636"&gt;We create company records from multiple sources — integrations, imports, and manual entry — so keeping organisation names consistent is important for reporting and data quality. To help with this, I’ve been using workflow actions like &lt;STRONG data-start="609" data-end="636"&gt;“change to title case.”&lt;/STRONG&gt;&lt;/P&gt;
&lt;P data-start="374" data-end="636"&gt;&amp;nbsp;&lt;/P&gt;
&lt;P data-start="638" data-end="692"&gt;In most cases, this works perfectly…&lt;/P&gt;
&lt;P data-start="638" data-end="692"&gt;&amp;nbsp;&lt;/P&gt;
&lt;P data-start="694" data-end="804"&gt;The issue shows up when a company name &lt;EM data-start="733" data-end="748"&gt;intentionally&lt;/EM&gt; includes capitalised acronyms or segments, for example:&lt;/P&gt;
&lt;P data-start="694" data-end="804"&gt;&amp;nbsp;&lt;/P&gt;
&lt;BLOCKQUOTE data-start="806" data-end="832"&gt;
&lt;P data-start="808" data-end="832"&gt;&lt;STRONG data-start="808" data-end="832"&gt;AMT Global Solutions&lt;/STRONG&gt;&lt;/P&gt;
&lt;/BLOCKQUOTE&gt;
&lt;P data-start="834" data-end="967"&gt;A standard title-casing rule improves consistency, but it also converts names like this into something inaccurate, which isn’t ideal.&lt;/P&gt;
&lt;P data-start="834" data-end="967"&gt;&amp;nbsp;&lt;/P&gt;
&lt;P data-start="969" data-end="1021"&gt;I’m curious how others are handling this in HubSpot:&lt;/P&gt;
&lt;P data-start="969" data-end="1021"&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL data-start="1023" data-end="1271"&gt;
&lt;LI data-start="1023" data-end="1093"&gt;
&lt;P data-start="1025" data-end="1093"&gt;Are you using any &lt;STRONG data-start="1043" data-end="1079"&gt;workarounds or conditional logic&lt;/STRONG&gt; in workflows?&lt;/P&gt;
&lt;/LI&gt;
&lt;LI data-start="1094" data-end="1175"&gt;
&lt;P data-start="1096" data-end="1175"&gt;Do you rely on &lt;STRONG data-start="1111" data-end="1174"&gt;exceptions lists, custom properties, or manual review steps&lt;/STRONG&gt;?&lt;/P&gt;
&lt;/LI&gt;
&lt;LI data-start="1176" data-end="1271"&gt;
&lt;P data-start="1178" data-end="1271"&gt;Has anyone found a way to preserve intended capitalisation while still enforcing consistency?&lt;/P&gt;
&lt;/LI&gt;
&lt;/UL&gt;</description>
      <pubDate>Tue, 13 Jan 2026 08:56:35 GMT</pubDate>
      <guid>https://community.hubspot.com/t5/Data-Hub/Handle-title-casing-company-names-without-breaking-acronyms/m-p/1240966#M3346</guid>
      <dc:creator>Alexander-tmp</dc:creator>
      <dc:date>2026-01-13T08:56:35Z</dc:date>
    </item>
    <item>
      <title>Re: Handle title casing company names without breaking acronyms?</title>
      <link>https://community.hubspot.com/t5/Data-Hub/Handle-title-casing-company-names-without-breaking-acronyms/m-p/1241057#M3347</link>
      <description>&lt;P&gt;Hey &lt;SPAN style="background: var(--ck-color-mention-background); color: var(--ck-color-mention-text);"&gt;&lt;a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/96622"&gt;@Alexander-tmp&lt;/a&gt;&lt;/SPAN&gt; and thanks so much for your thoughtful question!&lt;BR /&gt;&lt;BR /&gt;I’d love to connect you with some of our Top Experts for their insights! Hi &lt;SPAN style="background: var(--ck-color-mention-background); color: var(--ck-color-mention-text);"&gt;&lt;a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/123775"&gt;@danmoyle&lt;/a&gt;&lt;/SPAN&gt;, &lt;SPAN style="background: var(--ck-color-mention-background); color: var(--ck-color-mention-text);"&gt;&lt;a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/53340"&gt;@jforte&lt;/a&gt;&lt;/SPAN&gt; and &lt;a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/2062"&gt;@Josh&lt;/a&gt;, do you have any suggestions or best practices you could share with &lt;SPAN style="background: var(--ck-color-mention-background); color: var(--ck-color-mention-text);"&gt;&lt;a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/96622"&gt;@Alexander-tmp&lt;/a&gt;&lt;/SPAN&gt; on this topic? Your expertise is always so valuable!&lt;BR /&gt;&lt;BR /&gt;Thanks so much in advance and have a wonderful day!&lt;BR /&gt;Bérangère&lt;/P&gt;</description>
      <pubDate>Tue, 13 Jan 2026 13:02:11 GMT</pubDate>
      <guid>https://community.hubspot.com/t5/Data-Hub/Handle-title-casing-company-names-without-breaking-acronyms/m-p/1241057#M3347</guid>
      <dc:creator>BérangèreL</dc:creator>
      <dc:date>2026-01-13T13:02:11Z</dc:date>
    </item>
    <item>
      <title>Re: Handle title casing company names without breaking acronyms?</title>
      <link>https://community.hubspot.com/t5/Data-Hub/Handle-title-casing-company-names-without-breaking-acronyms/m-p/1241923#M3353</link>
      <description>&lt;P&gt;Hey&amp;nbsp;&lt;a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/96622"&gt;@Alexander-tmp&lt;/a&gt;&amp;nbsp;- an interesting question for sure. I haven't personally solved this as I don't manage the CRM data like that anymore. However, one thing I was thinking of is something I heard about once. Let's see if I can explain it. You could layer in “original name” and audit trail in a custom property.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Here's what that looks like:&lt;/SPAN&gt;&lt;/P&gt;
&lt;OL&gt;
&lt;LI&gt;&lt;SPAN&gt;Create Original company name and copy inbound values there once, before any formatting workflows touch them.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI&gt;Only ever manipulate a working “Formatted company name,” then overwrite Company name once you’re happy.&lt;/LI&gt;
&lt;LI&gt;Add a small metadata field like “Last formatting workflow run date” so you can isolate records impacted by a bad rule and fix them in bulk later.&lt;/LI&gt;
&lt;/OL&gt;
&lt;P&gt;​This pattern is especially helpful when integrating multiple sources. It's a bit manual and requires regular auditing, but could help when your workflow fires when it shouldn't.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Another solution I found while poking around was also pretty manual, but may help with it. If you were to maintain an exceptions or accepted acronyms list, you could add a branch to your workflow. Here's how that could play out.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Acronym flag property:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Boolean: “Company name includes protected acronym”.&lt;/LI&gt;
&lt;LI&gt;Use workflow branches: if flag is true, skip title case; if false, format.​&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;Acronyms text property:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Store values like AMT; IBM; NASA.&lt;/LI&gt;
&lt;LI&gt;Use a workflow that only formats names when Company name does not contain any of those strings (contains none of “ AMT ”, “ IBM ”, etc.); maintain this list over time.​&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;Manual corrections queue:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Use a view filtered on “Recently updated by formatting workflow = true” AND “Name contains known acronym fragments,” and have a light-touch review step, rather than proofreading every company.​&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;It's a bit of work and not totally automatic, but does give you guardrails without deep engineering. Otherwise you might look into how Data Hub&amp;nbsp;(fka Operations Hub) could help you with custom formulas/custom code.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Curious to see if anyone else has ideas to solve as well!&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 15 Jan 2026 13:43:36 GMT</pubDate>
      <guid>https://community.hubspot.com/t5/Data-Hub/Handle-title-casing-company-names-without-breaking-acronyms/m-p/1241923#M3353</guid>
      <dc:creator>danmoyle</dc:creator>
      <dc:date>2026-01-15T13:43:36Z</dc:date>
    </item>
  </channel>
</rss>

