Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: Format Phone Numbers at Load Time

More specific:

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

Stephen

3 Replies
Not applicable

Re: Format Phone Numbers at Load Time

Use the MID statement.

Stephen

Not applicable

Re: Format Phone Numbers at Load Time

More specific:

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

Stephen

Not applicable

Re: Format Phone Numbers at Load Time

Thanks!

Community Browser