how can i get polylines from csv file?

Question

I want to split values in CSV file (JAVA). Example of my data;

1. row 1 : T1,B,1408039037,[[-8.585676,41.148522],[-8.585712,41.148639],[-8.585685,41.148855]]...
2. row 2 : T22,A,1408039009,[[-8.612757,41.137722],[-8.612658,41.137785],[-8.612631,41.137812],[-8.61246,41.137866]]...

(All polylines have different number of member.) I split rows seperated by comma using split method in Java. It gets polylines elements seperately with "[" (beacause of comma) but I must get all elements in a one polyline variable. What i want for first row is below;

• elem1 = T1
• elem2 = B
• elem3 = 1408039037
• elem4 =[[-8.585676,41.148522],[-8.585712,41.148639],[-8.585685,41.148855]]...

how can i handle this?

Answer 1

You could construct a scanner with the file to be read, then set its delimiter to some regular expression that excludes any comma in your 'polylines'. It looks like you want to ignore commas if they're preceded by a single closing square bracket, but allow them otherwise.