My CSV file look like this
"Gates Nissan of Richmond" , "L2T Media, Llc" , "7000000", "--"
I want to remove comma(,) from this "L2T Media, Llc" in CSV
so that, my output will be "L2T Media Llc"
How can I do this in Java coding?
-
by writing code that does so. replaceAll comes to mind. Or, write your own algorithm, using the split methodStultuske– Stultuske2016-04-07 08:54:18 +00:00Commented Apr 7, 2016 at 8:54
-
You can try splitting using quotes instead of commas.Amber Beriwal– Amber Beriwal2016-04-07 09:16:53 +00:00Commented Apr 7, 2016 at 9:16
-
i just need to remove the comma inside double quotes in the csv file. thats itRaghul PR– Raghul PR2016-04-07 09:25:23 +00:00Commented Apr 7, 2016 at 9:25
-
1May I ask why you want to remove the comma? - I just ask because it is a completely well-formed CSV line to me. And I get the idea that eliminating the comma is just a workaround for not fixing the CSV parsing in the consuming software.Alexander– Alexander2016-04-07 09:58:52 +00:00Commented Apr 7, 2016 at 9:58
-
use split method and spilt using double quotes eg. String[] stringList = strTest.split("\",");Rohit RC– Rohit RC2022-05-26 09:30:55 +00:00Commented May 26, 2022 at 9:30
Add a comment
|
2 Answers
You could try something like this:
String str = "\"Gates Nissan of Richmond\" , \"L2T Media, Llc\" , \"7000000\", \"--\"";
List<String> items = new ArrayList<String>();
for(String item : Arrays.asList(str.substring(1, str.length()-1).split("\"+\\s*,\\s*\"+")))
items.add("\"" + item.replace(",", "") + "\"");
System.out.println(items);
Output:
["Gates Nissan of Richmond", "L2T Media Llc", "7000000", "--"]
Comments
Based on this answer:
public static void main(String[] args) {
String s = "\"Gates Nissan of Richmond\" , \"L2T Media, Llc\" , \"7000000\", \"--\"";
String[] splitted = s.split(",(?=([^\"]*\"[^\"]*\")*[^\"]*$)");
for(String item : splitted) {
item.replaceAll(",", "");
}
}
1 Comment
slartidan
Will this work with escaped quotation marks as well?
