CSV+truncate leading zero solution
Jyoti Chavan
Greenhorn
Posts: 8
Campbell Ritchie
Sheriff
Posts: 53749
127
posted 5 years ago
Welcome to the Ranch 
You are usually better off searching for CSV parsers than trying to do it yourself. If you want to get that String into a date, I suggest you look at the SimpleDateFormat class. If you want to display it, have a look at the date and time handling in the java.util.Formatter class; String#format and System.out.printf use the same format Strings as shown for Formatter.
You are usually better off searching for CSV parsers than trying to do it yourself. If you want to get that String into a date, I suggest you look at the SimpleDateFormat class. If you want to display it, have a look at the date and time handling in the java.util.Formatter class; String#format and System.out.printf use the same format Strings as shown for Formatter.
Jyoti Chavan
Greenhorn
Posts: 8
Campbell Ritchie
Sheriff
Posts: 53749
127
posted 5 years ago
-
1
-
-
-
-
Not sure I understand the problem. Do you want to include the leading 0s? You can do that if you retain the information in String format. If you change it to an int or Integer or (I think) BigInteger, there will be no record of the leading 0s.
posted 5 years ago
Are you opening the CSV file in Microsoft Excel? This application has a tendency of applying its own formatting. It's easy to change:
- Select the cells (or entire columns).
- Right click
- Select "Format Cells"
- Select the "Custom" category.
- Type in 00000 for the numbers to have at least 5 digits (adding leading zeros), or yyyy-mm-dd for the dates.
- Select the cells (or entire columns).
- Right click
- Select "Format Cells"
- Select the "Custom" category.
- Type in 00000 for the numbers to have at least 5 digits (adding leading zeros), or yyyy-mm-dd for the dates.
SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions How To Answer Questions
posted 5 years ago
Well presumably you must know what it is you're looking at; otherwise there really is no solution. I'd suggest looking at the NumberFormat or DecimalFormat classes.
No; that's not how it works. ShowSomeEffort, and come back if the code you write has problems.
Winston
Jyoti Chavan wrote:but i have this problem is not for date only,e.g i have one field named batch number value is 00001 but when i open csv this value is look like this only single 1 is there it is the problem for all values leading zeros.
Well presumably you must know what it is you're looking at; otherwise there really is no solution. I'd suggest looking at the NumberFormat or DecimalFormat classes.
please give me solution on this.
No; that's not how it works. ShowSomeEffort, and come back if the code you write has problems.
Winston
"Leadership is nature's way of removing morons from the productive flow" - Dogbert
Articles by Winston can be found here
Jyoti Chavan
Greenhorn
Posts: 8
Campbell Ritchie
Sheriff
Posts: 53749
127
Jyoti Chavan
Greenhorn
Posts: 8
posted 5 years ago
Then why use Excel at all? Just use a proper CSV reading library (see AccessingFileFormats) to read the data, and add it to the database directly. My guess is that you're first creating an Excel file and then using JDBC to read from that Excel file. There's absolutely no need for that.
SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions How To Answer Questions
Campbell Ritchie
Sheriff
Posts: 53749
127
Jyoti Chavan
Greenhorn
Posts: 8
Joanne Neal
Rancher
Posts: 3742
16
posted 5 years ago
1. Click on that link.
2. Scroll down to the Excel section - there you will find links to 6 CSV libraries.
3. Click on each of those links and read the documentation and look at any sample code for each library.
4. Once you have decided which one best suits your needs, use it in your code.
Or in other words Show Some Effort
-
3
-
-
-
-
Jyoti Chavan wrote:Help me about this ,I dont know about this CSV reading library (see AccessingFileFormats).
1. Click on that link.
2. Scroll down to the Excel section - there you will find links to 6 CSV libraries.
3. Click on each of those links and read the documentation and look at any sample code for each library.
4. Once you have decided which one best suits your needs, use it in your code.
Or in other words Show Some Effort
Joanne
Jyoti Chavan
Greenhorn
Posts: 8
posted 5 years ago
That's a workaround, not a solution.
SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions How To Answer Questions
Paramesh Korrakuti
Greenhorn
Posts: 1
posted 3 years ago
Append a double quote and tab, problem will rectify. Tab prevent leading zeors truncation and double quote separation of a cell when numbers has comma(,) with in it.
String actualString = "0000012345";
Solution:
"\"\t"+actualString + "\"";
----------------
Paramesh Korrakuti
www.parameshk.blogspot.in
Append a double quote and tab, problem will rectify. Tab prevent leading zeors truncation and double quote separation of a cell when numbers has comma(,) with in it.
String actualString = "0000012345";
Solution:
"\"\t"+actualString + "\"";
----------------
Paramesh Korrakuti
www.parameshk.blogspot.in
