Last active
February 2, 2021 09:17
-
-
Save paolorevillosa/460798dcfbab28a119e0a184d20ead6a to your computer and use it in GitHub Desktop.
just a simple csv resource file converter
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import java.io.BufferedReader; | |
import java.io.FileReader; | |
import java.io.FileInputStream; | |
import java.io.InputStream; | |
import java.io.InputStreamReader; | |
import java.io.FileWriter; | |
import java.util.List; | |
import java.util.Arrays; | |
import java.util.ArrayList; | |
public class CsvResourceConverted{ | |
public static void main(String[] args) { | |
try{ | |
List<List<String>> toExportData = new ArrayList<>(); | |
BufferedReader csvReader = new BufferedReader(new FileReader("/home/pc-name/Desktop/data.csv")); | |
String row = ""; | |
while ((row = csvReader.readLine()) != null) { | |
String[] data = row.split(","); | |
toExportData.add(generatedData(data[0],data[1])); | |
} | |
csvReader.close(); | |
exportToText2(toExportData); | |
}catch(Exception e){ | |
//e.printStacktrace(); | |
} | |
} | |
private static List<String> generatedData(String barCode, String name){ | |
return Arrays.asList(barCode,name); | |
} | |
private static void exportToText(List<List<String>> allData) throws Exception{ | |
FileWriter csvWriter = new FileWriter("new.xml"); | |
for(List<String> data : allData){ | |
csvWriter.append("<string name='PL" + data.get(0) + "'>\"" +especialCharacterReplacer(data.get(1)) + "\"</string>\n"); | |
} | |
csvWriter.flush(); | |
csvWriter.close(); | |
} | |
private static void exportToText2(List<List<String>> allData) throws Exception{ | |
FileWriter csvWriter = new FileWriter("insert.txt"); | |
for(List<String> data : allData){ | |
csvWriter.append("('" + data.get(0) + "',\"" + data.get(1) + "\"),\n"); | |
} | |
csvWriter.flush(); | |
csvWriter.close(); | |
} | |
private static String especialCharacterReplacer(String data){ | |
return data | |
.replace("&","&") | |
.replace("'","\\\'"); | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment