Create a new CSV file using Java

Question

I have to create a new CSV file and write data to that file. Here's my code snippet

String path = "D:\\cradius-data-local\\files\\webapps\\vcm";
String javaPath = path.replace("\\", "/");
String tempFolderPath = "zips"+File.separator+dto.getFileName();
File csvFile = null;
CSVWriter csvWriter = null;
csvFile = new File(javaPath+File.separator+tempFolderPath+File.separator+dto.getFileName()+".csv");
if(!csvFile.getParentFile().exists()){
    csvFile.getParentFile().mkdirs();
}
csvWriter = new CSVWriter(new FileWriter(csvFile), ',');

But when I'm trying to execute the above code, I'm getting the below error

java.io.IOException: The system cannot find the path specified

The location where I want to create my new csv file is

javaPath+File.separator+tempFolderPath+File.separator+dto.getFileName()+".csv"

Which evaluates to

D:/cradius-data-local/files/webapps/vcm\ocr_zips\AMIT_COOL_123\AMIT_COOL_123.csv

D:/cradius-data-local/files/webapps/vcm\ocr_zips\AMIT_COOL_123\AMIT_COOL_123.csv mixes both forward and backward slashes. You don't need to do any replacement. Let Java do the work for you. Or, ever better, use the Path API rather than the mostly obsoltete File API. — Boris the Spider
– Boris the Spider, Commented Jun 17, 2018 at 19:38

Timur Levadny · Accepted Answer · 2018-06-17 20:37:23Z

1

As Boris wrote in the comment, you can let Java do the work for you. Consider following snippet:

String path = "D:\\cradius-data-local\\files\\webapps\\vcm";
File file = Paths.get(path, "zips", dto.getFileName() + ".csv").toFile();

edited Jun 17, 2018 at 20:37

answered Jun 17, 2018 at 20:19

Timur Levadny

5304 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user7791786 · Accepted Answer · 2018-06-17 19:33:27Z

-1

use this:
String javaPath = path.replace("\\", "\"); // Create a new variable
instead of:
String javaPath = path.replace("\\", "/"); // Create a new variable

answered Jun 17, 2018 at 19:33

user7791786

33 bronze badges

Collectives™ on Stack Overflow

Create a new CSV file using Java

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related