function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
sieb4mesieb4me 

covert this

how do i get this "(GMT+04:30) Afghanistan Time (Asia/Kabul)"
to be storedin field like this

+4.30

I want to strip all except the plus sign and digits and ':' to be change to '.'
Thanks.
Best Answer chosen by sieb4me
sieb4mesieb4me
FOUND ANSWER
VALUE(SUBSTITUTE(LPAD(SUBSTITUTE(Name, "(GMT", ""),6),':','.'))

All Answers

sieb4mesieb4me
FOUND ANSWER
VALUE(SUBSTITUTE(LPAD(SUBSTITUTE(Name, "(GMT", ""),6),':','.'))
This was selected as the best answer
Mano sfdcMano sfdc
Hi Sieb,

Can you please explain me breif about this...
Thanks in advance.

Thanks,
Manohar