按顺序将CSV文件转换为变量。我一直在尝试读取一个CSV文件,它包含两列,一个标题,然后是一个条目列表。
目前,我一直在使用LinkedHashMap;使用以下循环来读取、拆分和创建LinkedHashMap。
然而,它现在卡在我的CSV的第5行。下面是当前的读取循环:
public static LinkedHashMap<String, ArrayList<String>> runningOrderMap(String filename) throws IOException {
LinkedHashMap<String, ArrayList<String>> linkedHashMap = new LinkedHashMap<>(50);
String currentLine = ""; //init iterator variable
String[] valuesTMP;
try {
bufferedReader = new BufferedReader(new FileReader(filename));
} catch (FileNotFoundException e) {
e.printStackTrace();
}
while((currentLine = bufferedReader.readLine()) != null){
valuesTMP = currentLine.split(", ");
ArrayList<String> values = new ArrayList<>();
String key = valuesTMP[0].split("\t")[0].trim();
values.add(valuesTMP[0].split("\t")[1].trim());
for(int i = 1; i < valuesTMP.length; i++){
values.add(valuesTMP[i]);
System.out.println(valuesTMP[i]);
linkedHashMap.put(key, values);
}
}
System.out.println("linked hashmap:"+linkedHashMap.keySet().size());
return linkedHashMap;
}
示例数据的格式是这样的,标题长度可变,一个制表符,然后内容条目列表如下:
title content, content2
title example content, content2, content3
title example three content, content2
title example content, content2
这个数据持续了大约20行,但是LinkedHashMap不会超过第5行:
title example two content
我需要保留数组中的行顺序。
发布于 2018-12-13 02:32:08
似乎我知道哪里出了问题)
尝试将行linkedHashMap.put(key, values);
移出内部for
循环,如下所示:
public static LinkedHashMap<String, ArrayList<String>> runningOrderMap(String filename) throws IOException {
LinkedHashMap<String, ArrayList<String>> linkedHashMap = new LinkedHashMap<>(50);
String currentLine = ""; //init iterator variable
String[] valuesTMP;
try {
bufferedReader = new BufferedReader(new FileReader(filename));
} catch (FileNotFoundException e) {
e.printStackTrace();
}
while((currentLine = bufferedReader.readLine()) != null){
valuesTMP = currentLine.split(", ");
ArrayList<String> values = new ArrayList<>();
String key = valuesTMP[0].split("\t")[0].trim();
values.add(valuesTMP[0].split("\t")[1].trim());
for(int i = 1; i < valuesTMP.length; i++){
values.add(valuesTMP[i]);
System.out.println(valuesTMP[i]);
}
linkedHashMap.put(key, values); // <--this line was moved out from internal for loop
}
System.out.println("linked hashmap:"+linkedHashMap.keySet().size());
return linkedHashMap;
}
因为,您可以看到,只有当内容有多个部分时,才会执行这个内部for
循环
https://stackoverflow.com/questions/53748597
复制相似问题