AnsweredAssumed Answered

Substitute Double Quotes on Import and Format Phone Number properly (Partially Solved)

Question asked by spudmw on Feb 10, 2018
Latest reply on Feb 11, 2018 by philmodjunk

Hello all,

 

I am currently trying to find a way to substitute double quotes and equal signs on my imports, but also format the phone number properly.  I have an auto-enter calc that replaces the double quotes and equal signs with a simple substitute, but I am unclear on how to then format the phone number to (XXX) XXX-XXXX  right now the numbers are all jumbled.  I figured maybe a let would work, but im not sure how to do the substitute calc with the let function.

 

Thank you for any help.

Outcomes