1,105,644 Community Members

Remove Spaces From VARCHAR2 Using REPACE Function

Member Avatar
dwayned
Light Poster
31 posts since Apr 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi Guys,

I have imported a CSV file into the database and i want to write some functions to ensure that when data is loaded in that all spaces are removed from certain columns.

For Example: In the Phone No column the numbers can appear as follows
07712345678
077 1234 5678
077 12345678
077 12 34 56 78

I want to remove all spaces from the column and have been trying to use the following query;

SELECT replace(PHONE_NO,' ') FROM IMPORTED_DATA_TABLE

However this displays all the results correctly in the results pane, but i want to update the column to remove the spaces. Could someone point me in the right direction or am I going about this the wrong way?

thanks
Dwayne

Member Avatar
dwayned
Light Poster
31 posts since Apr 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi Guys,

Sorry I figured out how to update as below;

UPDATE IMPORTED_DATA_TABLE SET phone_no= replace(phone_no,' ');

thanks anyway.
Dwayne

Question Self-Answered as of 2 Years Ago
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: