Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aworrall
New Contributor II

Number Formatting - Telephone Number

I have a telephone number in a list of contacts that I would like formatted as a phone number.  The data includes international and mobile numbers.  Does anyone have any ideas on how to make this look good?  Many thanks

1 Solution

Accepted Solutions
tomasz_tru
Valued Contributor

Re: Number Formatting - Telephone Number

If the data is clean, you can use string concatenation and left(), mid(), right() functions. If not, maybe purgechar() could help.

Tomasz

3 Replies
OmarBenSalem
Esteemed Contributor

Re: Number Formatting - Telephone Number

Can you give us a sample of what you have and what you want to have (the output) ?

tomasz_tru
Valued Contributor

Re: Number Formatting - Telephone Number

If the data is clean, you can use string concatenation and left(), mid(), right() functions. If not, maybe purgechar() could help.

Tomasz

vinieme12
Esteemed Contributor II

Re: Number Formatting - Telephone Number

we can't see what you are looking at; providing a sample will let the people here help you better

How to get answers to your post?

Community Browser