https://mycommunity.validity.com/t5/demandtools/standardization-of-country-names-and-usa-state-names/m-p/2609#M1462 <P>Does DTV offer any pre-built solutions to standardize country names or the names of US states?</P> Wed, 26 Mar 2025 14:01:36 GMT jkolterman 2025-03-26T14:01:36Z https://mycommunity.validity.com/t5/demandtools/standardization-of-country-names-and-usa-state-names/m-p/2609#M1462 <P>Does DTV offer any pre-built solutions to standardize country names or the names of US states?</P> Wed, 26 Mar 2025 14:01:36 GMT https://mycommunity.validity.com/t5/demandtools/standardization-of-country-names-and-usa-state-names/m-p/2609#M1462 jkolterman 2025-03-26T14:01:36Z https://mycommunity.validity.com/t5/demandtools/standardization-of-country-names-and-usa-state-names/m-p/2611#M1464 <P>Hey&nbsp;<a href="https://mycommunity.validity.com/t5/user/viewprofilepage/user-id/729">@jkolterman</a>&nbsp;- Absolutely, there are several ways to utilize these methods across Modify, Tune &amp; Import with our <A href="https://knowledge.validity.com/s/articles/Import-Transform-Formulas?language=en_US" target="_self">Transform Functions</A> and <A href="https://knowledge.validity.com/s/articles/DemandTools-Modify-Formula-Dictionary?language=en_US" target="_self">Formulas</A>.&nbsp;</P> <UL> <LI><A href="https://knowledge.validity.com/s/articles/Modify-Using-Formulas?language=en_US" target="_self">Using Formulas in Modify</A></LI> <LI><A href="https://knowledge.validity.com/s/articles/Import-Transform-Formulas?language=en_US" target="_self">Transform Operations in Import</A></LI> <LI><A href="https://knowledge.validity.com/s/articles/Tune?language=en_US" target="_self">Tune Transformations</A></LI> </UL> <P>&nbsp;</P> <UL> <LI class="lia-align-left">Country Name&nbsp;Formulas:&nbsp;<SPAN>CountryMatchReturn3CharacterName,&nbsp;CountryMatchReturnISONumber,&nbsp;CountryMatchReturnLongName</SPAN></LI> <LI class="lia-align-left"><SPAN>State Name Formulas:&nbsp;<SPAN>StateMatchShortName,&nbsp;StateMatchLongName</SPAN></SPAN></LI> </UL> Wed, 26 Mar 2025 17:13:41 GMT https://mycommunity.validity.com/t5/demandtools/standardization-of-country-names-and-usa-state-names/m-p/2611#M1464 Pugs_Validity 2025-03-26T17:13:41Z