Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Format Phone Numbers at Load Time

Hi all,

I am loading a phone number field into my module and each of the numbers are in a simple xxxxxxxxxx 10-digit format. I would like to change the format to be something more like xxx.xxx.xxxx or (xxx) xxx-xxxx. Is it possible to format this at load time?

Thanks,
Paul

1 Solution

Accepted Solutions
Not applicable
Author

More specific:

=MID(Field,1,3) &  "." & MID(Filed,4,3) & "." & MID(Field,7,4) as PhoneNumber

Stephen

View solution in original post

3 Replies
Not applicable
Author

Use the MID statement.

Stephen

Not applicable
Author

More specific:

=MID(Field,1,3) &  "." & MID(Filed,4,3) & "." & MID(Field,7,4) as PhoneNumber

Stephen

Not applicable
Author

Thanks!