Getting the phone number from Google Contacts pack

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…

Bildschirmfoto 2023-07-03 um 16.40.49


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.


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

Really appreciate it!


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.