+ 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