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
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;


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?


Hi Guys,

Sorry I figured out how to update as below;

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

thanks anyway.

Be a part of the DaniWeb community

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