Taking a 10 digital number and formatting for phone

#1

Not sure how to take for example 2167752324 and format as (216)775-2324.

#2

Hey @tagresti,

Are you familiar with EasyMorph expressions / functions? You can achieve this by using the “Modify Column(s)” action and building an expression that uses the following functions:

And then concatenating everything (using &) and also adding the parenthesis/dash in the concatenation.

Let me know if you need more detail.

1 Like
#3

gotcha. Thanks!