package com.example.mongolearn;
import org.junit.jupiter.api.Test;
import java.io.File;
import java.io.IOException;
import java.time.LocalDate;
import java.time.format.DateTimeFormatter;
import java.util.List;
import java.util.regex.Pattern;
import java.util.stream.Collectors;
import static org.apache.commons.io.FileUtils.readLines;
import static org.apache.commons.io.FileUtils.writeLines;
public class ReadCSV {
@Test
void splitCSV() throws IOException {
File source = new File("E:\\Users\\Aaron\\Desktop\\data\\source.csv");
File legal = new File("E:\\Users\\Aaron\\Desktop\\data\\legal.csv");
File illegal = new File("E:\\Users\\Aaron\\Desktop\\data\\illegal.csv");
writeLines(legal,
legalMapLines(source)
);
writeLines(illegal,
illegalMapLines(source)
);
}
@Test
void fixCSV_fix1() throws IOException {
File source = new File("E:\\Users\\Aaron\\Desktop\\data\\illegal.csv");
File illegal_fix1 = new File("E:\\Users\\Aaron\\Desktop\\data\\illegal_fix1.csv");
writeLines(illegal_fix1,
fixLines_insetComma(source)
);
writeLines(illegal_fix1,
fixLines_trim(source),
true
);
}
@Test
void splitCSV2() throws IOException {
File source = new File("E:\\Users\\Aaron\\Desktop\\data\\illegal_fix1.csv");
File legal = new File("E:\\Users\\Aaron\\Desktop\\data\\legal.csv");
File illegal = new File("E:\\Users\\Aaron\\Desktop\\data\\illegal_v2.csv");
writeLines(legal,
legalMapLines(source),
true
);
writeLines(illegal,
illegalMapLines(source)
);
}
@Test
void choiceByDate() throws IOException {
File source = new File("E:\\Users\\Aaron\\Desktop\\data\\illegal_v2.csv");
File illegal = ne
Java进行CSV文件处理
最新推荐文章于 2023-03-29 15:05:15 发布