This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
i run tiktok lead generation and leads (phone number and email) automatically imported to google sheet, unlike facebook lead ads, the phone number from tiktok lead generation always with hyphen, dash and bracket, so i use formatter by zapier try to clearn phone number before zapier send to google sheet.
the example phone number is: +1 xxx-xxx-xxxx
I tried text to replace with h^0-9+], it failed.
i tried number to format phone number under transform to use E164 format, failed.
i tried to format in google sheet, still, failed.
does anyone have same issue? and how to fix it? it drives me crazy, below are the screenshot, thank you very much.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/4e1814cb-807e-46c3-8fba-3f50aa29958c.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/812b830f-797f-42e1-a408-5b4b3a913906.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/2f10ad4d-49b1-4c5b-bc63-0e67aa07d382.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/f4736901-1c35-494e-84dd-b86c4593eb6d.png)