Hey guys,

needed a way to convert from a 15 digit ID to an 18 digit one.

Found the javascript version for just such an action here: http://community.salesforce.com/sforce/board/message?board.id=general_development&message.id=13148

tried to make my own apex version but the last digit keeps coming out wrong.  Any Ideas?

Thank's

String id = '001Q0000002NXad'; //a sample id

String suffix = '';

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

Integer flags = 0;

for(integer j=0;j<5;j++){
String c = id.substring(i*5+j,i*5+j+1);

if(c >= 'A' && c <='Z'){

flags += 1 << j;
}
}

if (flags <= 25) {

suffix += 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'.substring(flags,flags+1);

}else suffix += '012345'.substring(flags-26,flags-26+1);
}

System.debug('15-DIGIT:'+Id);
System.debug('18-DIGIT:'+Id + suffix);

I have been unable to ascertain how to use the Excel Connector to turn 15 character IDs in an Excel spreadsheet into 18 character IDs, which is something I read was possible on a forum post. I've watched the videos and searched the forums. I know the function "FixID" is involved, but I'm unable to make it work. I've installed the toolkit and correctlt installed the connector, but that's as far as I've gotten.

Could someone please dumb this down for me with step by step instructions?