Remove First Two Characters of a Number

[cldb2016]

I originally asked for help with this problem back in 2016 and I received a reply that worked at the time. But now for some reason it does not work anymore and I could use some help. I have a telephone number formatted as follows:

+17035551212 and it is in a field named [mobilenumber]

I want to remove the first two characters so the number looks like:

7035551212

and then insert this number in a field called [mobilenumberten].

For some reason I just cannot get it to work anymore on my submission form datapage. Any suggestions would be helpful. Thanks in advance.

[Vitalikssssss]

Hi cldb2016,

Perhaps you can utilize formula field with substring function instead of custom JavaScript Solution.

Here are some links to articles about formula field and its function:

https://howto.caspio.com/tables-and-views/data-types/formula-fields/

https://howto.caspio.com/function-reference/

Regards,

vitalikssssss

[MayMusic]

You can try to add this formula field to your table:

 

CASE WHEN Charindex( '+1',[@field:Phone]) > 0 THEN Substring([@field:Phone],3, 10) ELSE [@field:Phone] END

Phone is the name of the field you have for phone number in your table. It is always recommended to select the fields from picker