java csv 引号_字符串CSV双引号解析以及双引号和括号转义

package sdaf;

import java.util.ArrayList;

import java.util.List;

public class Test {

public String transferBracket(String str){

return str.replaceAll("\\(", "\\(\\(").replaceAll("\\)", "\\)\\)");

}

public String[] splitAndDeleteTransferBrancket(String str){

char[] charArray = str.toCharArray();

int index = 0;

for(int i = 1; i < charArray.length-1; i++){

if('(' == charArray[i-1] || '(' == charArray[i+1]){

continue;

}

if('(' == charArray[i]){

index = i;

break;

}

}

String[] result = new String[2];

if(index == 0){

result[0] = str;

return result;

}

result[0] = str.substring(0, index).replaceAll("\\(\\(", "\\(").replaceAll("\\)\\)", "\\)");

result[1] = str.substring(index+1, str.length()-1).replaceAll("\\(\\(", "\\(").replaceAll("\\)\\)", "\\)");

return result;

}

public static String[] dealWithDoubleQuota(String elementStr){

String[] result =  elementStr.split("," + "(?=([^\"]*\"[^\"]*\")*[^\"]*$)");

for(int i = 0; i < result.length; i++){

String s = result[i];

s = s.replaceAll("\"\"", "\"");

if(s.startsWith("\"")){

s = s.substring(1, s.length() - 1);

}

result[i] = s;

}

return result;

}

public static String[] dealWithDoubleQuota1(String elementStr){

String[] result =  elementStr.split("," + "(?=([^\"]*\"[^\"]*\")*[^\"]*$)");

for(int i = 0; i < result.length; i++){

String s = result[i];

s = s.replaceAll("\"\"", "\"");

if(s.startsWith("\"")){

s = s.substring(0, s.length());

}

result[i] = s;

}

return result;

}

public static void main(String[] args){

/*String elementStr = "sdaf,\"ab,adc\",\"123\",12\",sdf";

String reg="\"(.*?)\"";

Pattern pattern = Pattern.compile(reg);

Matcher matcher = pattern.matcher(elementStr);

while(matcher.find()){

System.out.println(matcher.group());

}*/

/*String elementStr = "sdaf,\"ab,adc\",\"123\"\",12\",sdf";

String[] ss =dealWithDoubleQuota(elementStr);

for (String s : ss){

System.out.println(s);

}*/

/*String a = new Test().transferBracket("rr((,TT)");

String a1 = new Test().transferBracket("U((,S)");

String a2 = new Test().transferBracket("");

for(String s : new Test().splitAndDeleteTransferBrancket(a+"("+a1+")")){

System.out.println(s);

}*/

String elementStr =  "\"Government of ,(Austria)\",BRITISH LAND INT'L.,\"WEST\"\", PAC.\",123(123),\"WEST\"\", PAC.\"(\"13\"\",sd\"), ";

//elementStr = "sdaf,\"ab,adc\",\"123\"\",12\",sdf";

String[] ss =dealWithDoubleQuota1(elementStr);

for (String s : ss){

System.out.println(s);

}

}

}