", "answerCount": 1, "upvoteCount": 0, "datePublished": "2022-05-18T03:13:47.000Z", "author": { "@type": "Person", "name": "Angela He", "url": "https://trailblazers.salesforce.com/profileView?u=0053A00000FUSkdQAH", "affiliation": { "@type": "Organization", "name": "Angela's business" } }, "suggestedAnswer": [ { "@type": "Answer", "text": "@Angela He https://trailblazers.salesforce.com/profileView?u=0053A00000FUSkdQAH , try those links link 1 link 2 link 3", "upvoteCount": 0, "url": "https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000H2uRSSAZ", "datePublished": "2022-05-19T12:36:43.000Z", "author": { "@type": "Person", "name": "Mauricio Alexandre Silva", "url": "https://trailblazers.salesforce.com/profileView?u=0053000000A7FJUAA3", "affiliation": { "@type": "Organization", "name": "DVLPRBR" } } } ] } } Skip to main content

Hi I wrote a simple snippet to convert 15 digits ID into 18 digits.  Could anyone have a look if there is any error about my code.   Thank you so much.

 

For converting 15digits ID into 18 digits part,  I refered to the source. :How to Convert 15-character Salesforce IDs to 18-character IDs - Classic Connector for Salesforce & Jira (servicerocket.com)

The forth point.

<script runat="server">

Platform.Load("core", "1.1");

var eventsDE = DataExtension.Init('8FBE0DD9-FA36-49B6-83B9-00C9E4FC84AA');

var evenRows = eventsDE.Rows.Retrieve();

try {

for (var i=0; i < eventRows.length; i++) {

var value = data[i].['Account_FID'];

if (value.length == 15){

var convertedID = "";

for (var i = 0; i < 3; i++){

var baseTwo=0;

for (var j = 0; j < 5; j++){

var character = value.charAt(i*5+j);

if(character >= "A" && character<="Z"){

baseTwo+=1<<j;

}

}

convertedID+="ABCDEFGHIJKLMNOPQRSTUVWXYZ012345".charAt(baseTwo);

}

}

var updRows = Platform.Function.InsertDa }

}

</script>

1 个回答