This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Beginning Java and the fly likes Remove unwanted chars (new line,tab) in java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "Remove unwanted chars (new line,tab) in java" Watch "Remove unwanted chars (new line,tab) in java" New topic

Remove unwanted chars (new line,tab) in java

sujith delpachithra

Joined: Oct 14, 2008
Posts: 12
i am using informix server as my database. i have some data in it with dirty values like new line chars,tab chars etc.

i want to remove those from my database.

Please, reply.
Arka Guhathakurta
Ranch Hand

Joined: Mar 01, 2009
Posts: 46
copy the content to a string variable and then use trim method to remove unwanted spaces from either side of the string.
Note that trim will not remove whitespace chars inside the string between words.
I hope it helps.

Ankit Garg

Joined: Aug 03, 2008
Posts: 9291

If you want to remove the spaces from the middle of the string too, you can use the replaceAll method of String class with a regex like \s to replace all the space characters with anything that you like. This method would be a little slow if you want to update all the records. You should try a bulk update query specific to your database to achieve that...

SCJP 6 | SCWCD 5 | Javaranch SCJP FAQ | SCWCD Links
I agree. Here's the link:
subject: Remove unwanted chars (new line,tab) in java
Similar Threads
Best strategy for handling actions across multiple windows?
removing lines
Find Hex chars in a file
delete and insert chars inside a along string
Problem While storing Chinese Chars In db.