pcsoft.us.windevCopyright 2026, PC SOFT23 Jan 2015 15:55:24 Z21 Jan 2015 09:19:47 ZHi guys, I have the need to correctly split the following string coming from a csv file: POO0132,MN2111AB,"02 - 03","167,66","391,44","61,15","405,95","61,97","174,35","73,27","250,93","0,84","0,85","0,35","20,42","1,04","0,21","0,57","0,75","0,7788","0,46","567,4",17,0,0,1,0,"0,34","1310,1","0,31","0,02",0,0,"7,54","5,76","41,48","44,81","0,08","-107,19","-107,4",-108,"23,96","2,52","26,48","8,6","12,5","118833,3","51100,8","0,02","0,01","0,05","0,93","0,58","0,16","0,7","0,03",4,5,"9,51","1,33","3105,1","445,1","118,7","3549,4","47,9" As we can see the comma ( , ) is used as the separator for the columns but it also is used as the separator for the decimals. The columns where the numeric values are located are identified with the double quote. If I open this file in Microsoft Excel it automatically opens it in the correct way. Is there any built in function in Windev 19 that does the same thing? My need is to extract some specific values from this string but if I use ExtractString using the comma as separator I don't get the correct values (except the first two sub-strings). I have written a small routine that converts the original string in a way that I can use ExtractString with no problems but I need to cycle on the whole string and this takes a very long time to parse the file because I have almost 100000 rows. Any alternative way? Kindest Regards, Antonino30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)antonino.neripcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-50042/read.awp23 Jan 2015 15:55:24 ZHi Fabrice, actually the file I need to parse has 91000 rows and its size is, more or less, 45 MB. So according your post I m…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-50042/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-50042/read.awpSplit a stringfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-50037/read.awp23 Jan 2015 11:45:28 ZHi Antonino believe me when I say that you are barking up the wrong tree... Your speed problem is the freadline, NOT the pr…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-50037/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-50037/read.awpSplit a stringantonino.neripcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-50028/read.awp23 Jan 2015 10:07:02 ZHi Fabrice, once again thanks for your care. In fact I am one of those who make the mistake you are talking about. At the…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-50028/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-50028/read.awpSplit a stringfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-50001/read.awp22 Jan 2015 10:58:41 ZHi Antonino I do not know how you implemented your process, so, just in case... A mistake that lots of people are doing wh…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-50001/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-50001/read.awpSplit a stringantonino.neripcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-49997/read.awp22 Jan 2015 09:36:49 ZHi Fabrice, thanks a lot for yourcare and for your idea. I'll try to implement it in hope it reduces the computational time. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-49997/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-49997/read.awpSplit a stringfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-49988/read.awp21 Jan 2015 20:03:21 ZHi Antonino if the first two columns are the only one without commas, you can do extractstring on commas twice, then extrac…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-49988/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49981-split-string-49988/read.awpSplit a string