Formating Telephone numbers

[#1]

Hi all. I got a problem. I'm new to Qlikview but I would like to know if there is some way to edit the number format when it has already been put into Qlikview as i do not have the raw data anymore. If so, please explain how but remember as I mentioned, I am new to Qlikview

Thanks so much

chris@obi.co.za

[Miguel_Angel_Baeyens]

Hello Chris,

You may use within a chart or as calculated dimension something like (example)

Num(PhoneNumberField, '(##) ## - ####')

Hope that helps

[#3]

Hey man.

Thanks for the reply but unfortunately I've tried that and it doesn't work. Got any other ideas?

[#4]

If I use the calculated dimension you mentioned, I get this...

[Miguel_Angel_Baeyens]

Chris,

I was wrong then, you will have to divide your figure, kind of

='(' & Left(PhoneField, 2) & ') ' & Mid(PhoneField, 3, 3) & ' - ' & Right(PhoneField, 4)

[#6]

Miguel

Nope thats also not working. Theres no numbers at all only brackets.

[#7]

Hi

='(' & left(PhoneNumber,2) & ') ' & right(left(PhoneNumber,4),2) & ' ' & right(left(PhoneNumber,6),2) & ' - ' & right(left(PhoneNumber,10),4)

Will change 1234567890 (12) 34 56-7890

Anders

[#8]

Hi Ansch

Well that worked. Thanks for the help

[#9]

Theres just on more lil issue with that formula though, it makes a double of the 7th number and cnt seem to get it to subtract one. got any ideas?

Thanks

[Miguel_Angel_Baeyens]

Hello,

Can you please show us one original phone number and how the result would look like? It would be very useful.