java - 从 csv 文件的 1 列中删除前导零

Question

我正在寻找一种快速方法来删除 CSV 文件第一列中的前导零，以便另一个程序可以很好地使用它。如果可能的话，最好将其从逗号分隔转换为制表符分隔，但这可能必须是一个单独的问题。

以下是标题名称(只需从学生 ID 中去掉前导 (2) 个零):

"Student ID","School Name","Contact Relation","Contact First Name","Contact Last Name","Salutation"," Home Phone Number","Address Line 1","Address Line 2","City","State","Zip","Zip + 4","Work Phone","Cell Phone","Pager","Residential Status","Custodial Status"

这里有一些示例数据，用于查看其格式:

"004000031","Local High School","Mother","FirstName","LastName","","555-5557773","555 Old Midlothian Tpke","Lot77","Richmond","VA","23222","","","","","","Y"

Answer 1

这一行应该做到这一点:

String[] tokens = String.join("\t", csv.replaceFirst("^\"0*", "\"").split(","));