Or make a formula in native Quickbase.
var text Tel = ToText([Mobile for Drug test Notifications]);
var text RemoveBracketOne = SearchAndReplace($Tel,"(","");
var text RemoveBracketTwo = SearchAndReplace($RemoveBracketOne,")","");
SearchAndReplace($RemoveBracketTwo,"-","")
I have not tried to change a phone number format in a Pipeline but here is the article on transforming data.
https://helpv2.quickbase.com/hc/en-us/articles/4473004144660-Transforming-your-data
I suspect you need to change it to a string. That would look something like
{a.phone|string()}
I have not tested that one but will give it a look.
Qrew LegendOr make a formula in native Quickbase.
var text Tel = ToText([Mobile for Drug test Notifications]);
var text RemoveBracketOne = SearchAndReplace($Tel,"(","");
var text RemoveBracketTwo = SearchAndReplace($RemoveBracketOne,")","");
SearchAndReplace($RemoveBracketTwo,"-","")
