java解析csv文件

   最近项目中，需要处理大量的CSV文件，需要将这些文件转换成txt格式，并以|进行分隔。最郁闷的是：这些文件数据格式好多都是不规范的。
由于项目使用的是JDK1.4，String的新特性没法用，写了个StringUtil类
今天又遇到新的问题，无语，重新修改了下程序
  此代码可以解决字段中出现分隔符，双引号等等。。。

/**
	 * 对于文件中字段包含逗号的文件的特殊处理 （同时可以去除掉双引号）处理完以后会在相同的路径下输出相同文件名的TXT文件
	 * 
	 * @throws Exception
	 */
	public static void specialChar(String filePath,int starRow) throws Exception {

		BufferedReader br = null;
		File f = new File(filePath);
		String fileName = f.getName();

		if (!fileName.substring(fileName.indexOf(".") + 1).equals("csv")) {
			throw new Exception(filePath + "不是一个CSV文件");
		}
		File file = new File(StringUtil.replace(f.getPath(), "csv", "txt"));
		FileWriter filewriter = null;
		try {
			br = new BufferedReader(new InputStreamReader(
					new FileInputStream(f), "utf-8"));
			filewriter = new FileWriter(file, false);
			SimpleDateFormat sd = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");

			System.out.println(sd.format(new Date()));
			String tempString = null;
			int i = 0;
			while ((tempString = br.readLine()) != null) {
				if (i < starRow-1) {
					i++;
					continue;
				}
				if(tempString.trim().equals(""))
					break;
				if (StringUtil.contains(tempString, "\"")) {
					tempString = deepParser(tempString,filePath);
				} else
					tempString = StringUtil.replace(tempString, ",", "|");
//				System.out.println(tempString);
				filewriter.write(stringTrim(tempString, "\\|") + "\r\n");
				i++;
			}
			System.out.println(sd.format(new Date()));
		} catch (Throwable e) {
			log.warn("解析文件：【" + filePath + "】出错", e);
			e.printStackTrace();
		} finally {
			try {
				br.close();
				filewriter.close();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}

	}

	public static String deepParser(String str,String filePath) {
		System.out.println(str);
		String temp = str;
                          str = str+",";
		StringBuffer sb = new StringBuffer();
		try {
			int from = 0;
			int end = str.length();
			int i = 0;
			while (StringUtil.contains((str = str.substring(from)), "\"")) {
				from = str.indexOf("\"");
				end = str.indexOf("\"", from + 1);
				sb.append(StringUtil.replace(str.substring(0, from), ",", "|"));
				sb.append(str.substring(from + 1, end));
				from = end + 1;
				i++;
			}
			sb.append(StringUtil.replace(str, ",", "|"));
		} catch (Throwable e) {
			log.warn("解析文件：【" + filePath + "】出错,一下数据有问题："+temp, e);
			e.printStackTrace();
		}
                       String s = sb.toString();
		     s = s.substring(0, s.lastIndexOf("|"));
		     return s;
	}


	//去除字段2边空格，可以指定分隔符
	public static String stringTrim(String str, String regex) {
		str = str+" ";
		String[] strs = str.split(regex);
		StringBuffer sb = new StringBuffer();

		for (int i = 0; i < strs.length; i++) {
			sb.append(strs[i].trim() + "|");
		}

		return sb.toString().substring(0, sb.toString().lastIndexOf("|"));
	}