Convert Salesforce record ID to a number?

JSey — Sat, 16 Nov 2024 01:24:41 GMT

For case feed (these essentially are the chatter comments on a case record), I need to export the record ID as a number ID into another system. However, Salesforce ID are letters and numbers that are also case sensitive. Is there a java script transformation code I can use to only convert the last 10 characters from the Salesforce ID into a numberic code?

PS. I cannot create autonumber field in Salesforce on Case Feed as we are not allow to create custom fields on case comment.

Re: Convert Salesforce record ID to a number?

manodwhb — Wed, 23 Sep 2020 04:05:31 GMT

@Johnny Sey , you can try to use the below expression in tMap to take last 10 characters of string and convert it into integer.

Integer.parseInt(row1.col.substring(row1.col.length()-10))

Thanks,

Manohar

topic Re: Convert Salesforce record ID to a number? in Talend Studio

Convert Salesforce record ID to a number?

Re: Convert Salesforce record ID to a number?