Member Avatar for dwayned

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

Edited by dwayned because: n/a
  • 1 Contributor
  • 1 Reply
  • 168 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by dwayned
Member Avatar for dwayned

Hi Guys,

Sorry I figured out how to update as below;

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

thanks anyway.
Dwayne

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.