topic Re: phone number conversation in QlikView

phone number conversation

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

can any one help me?

in phone number field

Phone

19945662237

18546234562

19999999991

18888814587

17777777778

18000879511

so on

Here my requirement is to display only 10 digits numbers in the first five phone numbers delete first 1 and

display tollfree number 18000879511 as it is.

avinashelite — Mon, 14 Mar 2016 10:19:16 GMT

try like this

left(Phone,10) as Phone

avinashelite — Mon, 14 Mar 2016 10:20:27 GMT

do you have the list of the Toll free numbers ?? if so you can use the apply map function

tamilarasu — Mon, 14 Mar 2016 10:30:08 GMT

Hi,

Try like below,

Load *,

If(Not Wildmatch(Mid(PhoneNo,2),'800*','888*','877*','866*','855*','844*'),Mid(PhoneNo,2),PhoneNo) as NewPh;

LOAD * INLINE [

PhoneNo

19945662237

18546234562

19999999991

18888814587

17777777778

18000879511

];

Note: Toll free number may vary based on country. So change the code according to your requirement.

Digvijay_Singh — Mon, 14 Mar 2016 10:41:13 GMT

Use this in list box expression -

=If(len(Phone)>10 and left(Phone,4)<>1800,right(Phone,10),Phone)

Kushal_Chawda — Mon, 14 Mar 2016 10:41:50 GMT

Try below condition

if( wildmatch(Phone,'1800*'),Phone, right(Phone,10)) as NewPhone

bhavvibudagam — Tue, 22 Mar 2016 06:47:49 GMT

Thank you so much Nagaraj.