phone number conversation

[bhavvibudagam]

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]

try like this

left(Phone,10) as Phone

[avinashelite]

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

[tamilarasu]

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]

Use this in list box expression -

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

[Kushal_Chawda]

Try below condition

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

[bhavvibudagam]

Thank you so much Nagaraj.