Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
You Can Try this
Give that a try
Num(Trim(PurgeChar([Field1],'-+()')))
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