You need to sign in to do that
Don't have an account?

Will i always get 15 digit id if i delete 3 characters from 18 digit id.
Hello,
Id can be on 15 or 18 digits.
If i delete the last 3 characters from my 18 digits id, will i always get the 15 digits id.
thank you for replly
Id can be on 15 or 18 digits.
If i delete the last 3 characters from my 18 digits id, will i always get the 15 digits id.
thank you for replly
You can try to trim not delete the last 3 digits of 18 digit id.
Something like below.
TRIM(LEFT(Id Field, 15))
https://help.salesforce.com/articleView?id=bi_integrate_data_prep_recipe_formula_field_stringFunctions_trim.htm&type=5
Thanks,
Vinay Kumar
All Answers
Can you explain the context in this scenario?
You can use 15 digit id and that should be problem even if you truncate last 3 digits in 18 digit id.
Thanks,
Vinay Kumar
I didnt understand.
If i delete last 3 characters from 18 digit will i get the 15 digit id
You can try to trim not delete the last 3 digits of 18 digit id.
Something like below.
TRIM(LEFT(Id Field, 15))
https://help.salesforce.com/articleView?id=bi_integrate_data_prep_recipe_formula_field_stringFunctions_trim.htm&type=5
Thanks,
Vinay Kumar