APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add Zero to a Phone number & Trim spaces

woof777Jun 6 2013 — edited Jun 10 2013

Hi,

I have a large list of Mobile Telephone numbers poorly formatted & I need to tidy them up for matching to other tables.

They have the first '0' missing sometimes & others have spaces between the numbers all inconsistent.

I need to run a regular expression to fix these, can any one supply one & explain how it works? Thanks.

The Normal format would 0412345678 - this is what I want it to change to.

Currently I have these types of formats;

412 34 5678, 0456 789 123, etc etc...

Can you help me Please?

This post has been answered by fac586 on Jun 7 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2013

Added on Jun 6 2013

#apex-discussions

9 comments

1,182 views