Cleaning URLs

Find the formula to clean up your website URLs from "http://" or "www" for your Salesforce CRM connection to Primer.

Do your website URLs contain "http://" or "www."? If so, you'll need to clean them up with the formula below:

SUBSTITUTE( IF( FIND("/", IF( FIND("www.", {!$Record.Website}) > 0, IF( FIND("//", {!$Record.Website}) > 0, SUBSTITUTE( {!$Record.Website}, LEFT( {!$Record.Website}, FIND("//www.", {!$Record.Website}) + 5), NULL ), {!$Record.Website} ), IF( FIND("//", {!$Record.Website}) > 0, SUBSTITUTE( {!$Record.Website}, LEFT( {!$Record.Website}, FIND("//", {!$Record.Website}) + 1), NULL), {!$Record.Website} ) ) ) > 0, LEFT( IF( FIND("www.",{!$Record.Website})>0, IF( FIND("//",{!$Record.Website})>0, SUBSTITUTE( {!$Record.Website}, LEFT( {!$Record.Website}, FIND("//www.",{!$Record.Website}) + 5 ), NULL), {!$Record.Website} ), IF( FIND("//",{!$Record.Website})>0, SUBSTITUTE( {!$Record.Website}, LEFT( {!$Record.Website}, FIND("//",{!$Record.Website}) + 1 ), NULL ), {!$Record.Website} ) ), FIND("/", IF( FIND("www.",{!$Record.Website})>0, IF( FIND("//",{!$Record.Website})>0, SUBSTITUTE( {!$Record.Website}, LEFT( {!$Record.Website}, FIND("//www.", {!$Record.Website}) + 5 ), NULL ), {!$Record.Website}), IF( FIND("//",{!$Record.Website}) > 0, SUBSTITUTE( {!$Record.Website}, LEFT( {!$Record.Website}, FIND("//",{!$Record.Website}) + 1 ), NULL ), {!$Record.Website} ) ) ) -1 ), IF( FIND("www.",{!$Record.Website})>0, IF( FIND("//",{!$Record.Website})>0, SUBSTITUTE( {!$Record.Website}, LEFT( {!$Record.Website}, FIND("//www.",{!$Record.Website})+5), NULL ), {!$Record.Website} ), IF( FIND("//",{!$Record.Website})>0, SUBSTITUTE( {!$Record.Website}, LEFT( {!$Record.Website}, FIND( "//", {!$Record.Website}) + 1 ), NULL ), {!$Record.Website}) ) ), 'www.', '' )// Some code