topic Re: Format Phone Numbers at Load Time in QlikView

Format Phone Numbers at Load Time

Tue, 11 Jun 2013 18:13:45 GMT

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

Re: Format Phone Numbers at Load Time

Tue, 11 Jun 2013 18:17:53 GMT

Use the MID statement.

Stephen

Re: Format Phone Numbers at Load Time

Tue, 11 Jun 2013 18:24:47 GMT

More specific:

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

Stephen

Re: Format Phone Numbers at Load Time

Tue, 11 Jun 2013 18:27:07 GMT

Thanks!