Tag Archives: parsing

Parsing CSV file where encapsulator in content ain't escaped properly

Questions: Hi I have a CSV File where the encapsulator character is not escaped properly. Example uerf@einf.erf,”uhrege gerjhhg er<span style=”background-color: rgb(0,153,0);”>eriueiru kernger</span><font color=”#009900″><span style=”background-color: rgb(255,255,255);”> weiufhuweifbw fhew fibwefbw</span></font><div><font color=”#009900″><span style=”background-color: rgb(255,255,255);”>wekifbwe fewf</span></font></div><div><font color=”#009900″><span style=”background-color: rgb(255,255,255);”>weiuifgewbfjew f</span></font></div>”,18-Oct-2016, Delimiter -> , Encapsulator -> “ It breaks when I try to read using commons-csv reader , throws a ‘… Read More »

Parsing a string as an array in Excel 2010 (without VBscript)

Questions: I’ve got a whole bunch of cells containing arbitrary length arrays stored as semicolon-delimited strings, ranging in length from 1 to 65 entries, like: pcmsh15(232);pcmsh16(232);pcmsh17(136); pcmsh12(40); pcmsh12(40); pcmsh12(5);pcmsh15(20); I want a way to sum up the numbers in the parenthesis in Excel 2010 without using VBA, keeping in mind that they are arbitrary length… Read More »

Excel parsing using jxl

Questions: I use jxl to read .xls file, The following is my code to parse the xls file. It works fine, but the problem is when i insert date fields, it only reads last two digits of the year. For example if i put 12/13/2088, and 12/13/1988. It both will read as 12/13/88. Is there… Read More »

Decimal parsing differences on separate environments

Questions: Evening, I’m bashing my head against a wall with the following problem: I’m loading numbers from cells from a Number column with size=16 and decimal places = 2 inside adBase III .dbf file. These numbers, when viewed with a DbfViewer appear as: 12345.12, where there is no thousands separator and the decimal separator is… Read More »

Parsing Excel sheet using javascript

Questions: I’m using SheetJS in order to parse Excel sheets however I run into the following error: “Uncaught TypeError: jszip is not a function” When executing the following code: var url = “/test-files/test.xlsx”; var oReq = new XMLHttpRequest(); oReq.open(“GET”, url, true); oReq.responseType = “arraybuffer”; oReq.onload = function(e) { var arraybuffer = oReq.response; var data =… Read More »