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>