Skip to content

Instantly share code, notes, and snippets.

@paolorevillosa
Last active February 2, 2021 09:17
Show Gist options
  • Save paolorevillosa/460798dcfbab28a119e0a184d20ead6a to your computer and use it in GitHub Desktop.
Save paolorevillosa/460798dcfbab28a119e0a184d20ead6a to your computer and use it in GitHub Desktop.
just a simple csv resource file converter
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("&","&amp;")
.replace("'","\\\'");
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment