string manupilation

[chris]

Hi there a receive a string from a recordset which contains a telephone
number.

It looks like: [phone]

How can I manipulate the string, so that the () are deleted.

It should look like this: 03 9888 5566

I also receive a string which contains a mobile number. There should be
another empty space.

It looks like: 0407 566454

But it should look like 0407 566 454

I can't work it out. It drives me nuts :-(

Thanks for your help

Chris

[Dale Preston]

Your first question:

newNumber = oldNumber.Replace("(","").Replace(")","");

And for your second, if you're positive that the incoming string is always
formatted like you have it, then just use

newNumber = oldNumber.Substring(0,8) + " " + oldNumber.Substring(8);

Dale Preston
MCAD, MCDBA, MCSE

"chris" <ch***@discussions.microsoft.com> wrote in message
news:58**********************************@microsof t.com...

Hi there a receive a string from a recordset which contains a telephone
number.

It looks like: [phone]

How can I manipulate the string, so that the () are deleted.

It should look like this: 03 9888 5566

I also receive a string which contains a mobile number. There should be
another empty space.

It looks like: 0407 566454

But it should look like 0407 566 454

I can't work it out. It drives me nuts :-(

Thanks for your help

Chris

[chris]

Thank you Dale. This is amazing.

Cheers

Chris

"Dale Preston" wrote:

Your first question:

newNumber = oldNumber.Replace("(","").Replace(")","");

And for your second, if you're positive that the incoming string is always
formatted like you have it, then just use

newNumber = oldNumber.Substring(0,8) + " " + oldNumber.Substring(8);

Dale Preston
MCAD, MCDBA, MCSE

"chris" <ch***@discussions.microsoft.com> wrote in message
news:58**********************************@microsof t.com...

Hi there a receive a string from a recordset which contains a telephone
number.

It looks like: [phone]

How can I manipulate the string, so that the () are deleted.

It should look like this: 03 9888 5566

I also receive a string which contains a mobile number. There should be
another empty space.

It looks like: 0407 566454

But it should look like 0407 566 454

I can't work it out. It drives me nuts :-(

Thanks for your help

Chris