How split a text with a expression use in values

Question

I try split values of sql for modify values (DATE, boolean, ...). For example, I have the values:

('im a value','im a second value with, test',478,20/05/2010 16:56:32)

How i can split the value for had only 4 values:

and not 5 values:

Thanks

edit:

new exemple:

  INSERT INTO ACCES (id,type,com, date,make) VALUES (478,'action','test commentaire, new test',20/05/2010 16:56:3,False);

result

 INSERT INTO ACCES (id,type,com, date,make) VALUES (478,'action','test commentaire, new test',1274367363,0);

Not sure what you mean, there are only two values, the comma is part of the second value. The apostrophe in SQL is a field delimiter. — twoleggedhorse, Jan 07 '13 at 13:25
It's like he's getting it all as a String and trying to `split` on the `,`, effectively chopping off at the comma in-between the `'` too. — karllindmark, Jan 07 '13 at 13:33
We need more details about your problem. How / where are stored those values (uniaue string, database etc)? — Miloš, Jan 07 '13 at 13:35

score 1 · Accepted Answer · edited May 23 '17 at 12:18

1

You can do this iteratively, or you can do it this way:

In short, you split with a regular expression:

line.split(",(?=([^\"]*\"[^\"]*\")*[^\"]*$)");

edited May 23 '17 at 12:18

Community

answered Jan 07 '13 at 13:46

wentam

tanks for me the regular expression is ",(?=([^\']*\'[^\']*\')*[^\']*$)" – user1238096 Jan 07 '13 at 14:13

score 0 · Answer 2 · answered Jan 07 '13 at 13:39

0

I know only one way to do that.

Split input string by "," to array
If I string starts with "'" and (I+1) string end with "'" then combine it to I element
Remove I+1 element

If you need realisation, I can write it later

answered Jan 07 '13 at 13:39

Spyric

your idea is interessant, i need realisation a value can contains more one ","... – user1238096 Jan 07 '13 at 14:09

2 Answers2