How to remove leading zeros in table box column?

[#1]

Hi,

I have a phone number as below in table box.

0064524542444285

+2861244285

How can I change this to 64524542444285  and 2861244285.

can anyone suggest me please?

Thanks.

[#2]

Thanks.

01 0432482349

01 4973579

00353 (0) 87533453452

062 64444

044 343224540

087-7000208

059 9700021119

+872662083

I need to remove only first zero. I have to keep the zeros in middle and in last. Please suggest me how to set this?

Thanks.

[#3 · Accepted solution]

You Can Try this

[#4]

Give that a try

Num(Trim(PurgeChar([Field1],'-+()')))

[ashfaq_haseeb]

Try like this

Load *,

PurgeChar(Replace(Ltrim(replace(Value,0,'-')),'-',0),'+') as New_Value1,

replace(ltrim(replace(Value, '0', '-')), '-', 0) as New_Value;

load * Inline [

Value

01 0432482349

01 4973579

00353 (0) 87533453452

062 64444

044 343224540

087-7000208

059 9700021119

+872662083

];

Regards

ASHFAQ