Getting the phone number from Google Contacts pack

[Jannis]

Hi guys,

im trying to get a phone number in the following format “+491606001XXX” so i can use it for some actions… But i don’t know how to format it the right way…

Sincerely
Jannis

[Scott_Collier-Weir]

First, pull out the actual text value of the phone number.

Do this by saying: phoneNumberColumn.phoneNumber

Essentially chain it out.

Then, It looks like the number is in the format you need already, except for the spaces right?

If so, you can say: regexReplace(“\s”, “”)

If it’s any more complex that you can use the phone numbers pack which will format numbers into a variety or proper phone number formats.

[Jannis]

@Scott_Collier-Weir Thank you very much dude
I’ve been trying to get it working for a while but couldn’t get it.

Really appreciate it!

Sincerely
Jannis