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
Author

Remove unwanted chars (new line,tab) in java

sujith delpachithra
Greenhorn

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.


regards,
Arka
Ankit Garg
Sheriff

Joined: Aug 03, 2008
Posts: 9291
    
  17

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: http://aspose.com/file-tools
 
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.