java - 如何将csv文件内容从一种格式(通常的csv格式)转换为另一种格式(由salesforce支持)？

Question

我正在使用 mule esb 将数据存储到 salesforce 云。所以需要转换以下格式纬度，经度，邻近度

23.2241356,72.629232,0,
23.2241357,72.629233,5,
23.2241358,72.629234,0,
23.2241359,72.629235,5,

转换为以下格式，

 {proximity__c=23.2241361, longitude__c=72.629237, latitude__c=5.0},
 {proximity__c=23.2241362, longitude__c=72.629238, latitude__c=0.0},           
 {proximity__c=23.2241363, longitude__c=72.629239, latitude__c=5.0},         
 {proximity__c=23.2241364, longitude__c=72.62924, latitude__c=0.0},    

如何通过java实现这一点？

Answer 1

以下是可能的解决方案。

 FileWriter writer = new FileWriter(outPutFile);
             br = new BufferedReader(new FileReader(csvFileToRead));
             writer.append("[");
             while ((line = br.readLine()) != null) 
              {
                String[] products = line.split(splitBy);
                writer.append(" {proximity__c= " + products[0] + " , longitude__c="+products[1] +" , latitude__c=" + products[2]  + "},");
                writer.append("\n");     
              }
  writer.append("]");
  writer.flush();
  writer.close();