This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
All the excels have the data in the first column using semi colon as delimiter as seen above.
I can format the excel using the Data -> Text to Column -> Delimited(Selecting Semicolon as the delimiter) and then saving the formatted excel. This procedure puts the semicolon seperated values in different columns as needed.
However,I have a few thousands excel sheets to be formatted.This is not very convenient thing to be performed manually.
I was wondering if this can be done using Java code.