Ad:

MySQL Discussion Thread
Unsolved
Views: 2346

Jun 2nd, 2009

How to remove extra spaces in a row??

Expand Post »

Hi,

I have a table like this:

MySQL Syntax (Toggle Plain Text)
 
name
+------------------------------------+
| name                               |
+------------------------------------+
| This IS an rna-binding     protein. The data which IS useful       IS available FROM the desired             location.  |
+------------------------------------+
1 row IN SET (0.00 sec)
name
+------------------------------------+
| name                               |
+------------------------------------+
| This is an rna-binding     protein. The data which is useful       is available from the desired             location.  |
+------------------------------------+
1 row in set (0.00 sec)

I want to remove extra space i.e in between binding and protein, desired and location, useful and this.

I tried with trim function but that didn't remove these spaces.

There should be only one space in between binding and protein, desired and location, useful and this.

Output should be like this:

MySQL Syntax (Toggle Plain Text)
 
SELECT * FROM remove;
 
+--------------------------------+
| name                           |
+--------------------------------+
| This IS an rna-binding protein. The data which IS useful IS available FROM the desired location |
+--------------------------------+
1 row IN SET (0.00 sec)
select * from remove;

+--------------------------------+
| name                           |
+--------------------------------+
| This is an rna-binding protein. The data which is useful is available from the desired location |
+--------------------------------+
1 row in set (0.00 sec)

How can i remove extra spaces???

Any suggestions??

Regards
Vanditha

Last edited by Vandithar; Jun 2nd, 2009 at 6:41 am.

Similar Threads

remove extra blank spaces in a text file in C++
Using isspace with white spaces in C++
trying to remove extra white spaces in data file in IT Professionals' Lounge
This ought to be simple - extra spaces in PHP

Vandithar

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

37 posts
since Aug 2008

Permalink

Jun 2nd, 2009

-1

Re: How to remove extra spaces in a row??

Hi,

Could you copy and paste your code? Have you used any css?

Thanks

k8f1

Reputation Points: 11

Solved Threads: 1

Newbie Poster

Offline

13 posts
since Nov 2007

Permalink

Jun 2nd, 2009

Re: How to remove extra spaces in a row??

Click to Expand / Collapse Quote originally posted by k8f1 ...

Hi,

Could you copy and paste your code? Have you used any css?

Thanks

Hi,

I am not using css!

This is the data i.e in my table.

MySQL Syntax (Toggle Plain Text)
name
+------------------------------------+
| name                               |
+------------------------------------+
| This IS an rna-binding     protein. The data which IS useful       IS available FROM the desired             location.  |
+------------------------------------+
1 row IN SET (0.00 sec)
name
+------------------------------------+
| name                               |
+------------------------------------+
| This is an rna-binding     protein. The data which is useful       is available from the desired             location.  |
+------------------------------------+
1 row in set (0.00 sec)

I tried with trim function like this:

MySQL Syntax (Toggle Plain Text)
UPDATE remove SET name = TRIM(name);
update remove set name = trim(name);

but didn't work!!!

How can i remove these spaces??

Regards
Vanditha

Vandithar

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

37 posts
since Aug 2008

Permalink

Jun 2nd, 2009

Re: How to remove extra spaces in a row??

Click to Expand / Collapse Quote originally posted by Vandithar ...

Hi,

I am not using css!

This is the data i.e in my table.
MySQL Syntax (Toggle Plain Text)
name
+------------------------------------+
| name                               |
+------------------------------------+
| This IS an rna-binding     protein. The data which IS useful       IS available FROM the desired             location.  |
+------------------------------------+
1 row IN SET (0.00 sec)
name +------------------------------------+ | name | +------------------------------------+ | This is an rna-binding protein. The data which is useful is available from the desired location. | +------------------------------------+ 1 row in set (0.00 sec)
I tried with trim function like this:
MySQL Syntax (Toggle Plain Text)
UPDATE remove SET name = TRIM(name);
update remove set name = trim(name);
but didn't work!!!

How can i remove these spaces??

Regards
Vanditha

Hi Vanditha

you are right when u used the trim it's not worked because trim is used only when the white space in left side or right side. so use regexp for this issue.

Regards
Saurav Prasad

saurav.prasad28

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

11 posts
since Apr 2009

Permalink

Jun 3rd, 2009

Re: How to remove extra spaces in a row??

Quote ...

Could you copy and paste your code? Have you used any css?

Quote ...

so use regexp for this issue.

Whats code got to do with it ? And what the hell is the css doing there in a question related to MySQL ? And how are you going to use regex Mr. ? If you don't know the answer don't post there's no point in pointing someone in the wrong direction or even asking unnecessary questions.

@OP : Use the REPLACE function in MySQL.
http://dev.mysql.com/doc/refman/5.0/en/replace.html

verruckt24

Reputation Points: 485

Solved Threads: 89

Posting Shark

Offline

944 posts
since Nov 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: SQL Query Help Required

Next Thread in MySQL Forum Timeline: MySQL Importable file required for country and state

DaniWeb Message

Cancel Changes

User Name
Password