Search Results

0 Then 'save as CSV file format su.SaveCSV(Folder,Filename,",",data...
link: Wow, thank you Erel. I will test it a little later today. Mark...
link: Your code is based on https://www.b4x.com/android/forum/threads/b4x-texteditor-save-and-load-externa...
link: .SaveCSV(Folder,Filename,",",data) 'now read the CSV file bytes Dim b...

I use the SaveCSV to export data from sqlite database (list from DBUtils.ExecuteMemoryTable) and I have a problem in accented letters. Excel don't read correctly this letters and return... Antivirus, using this library. Is there a way to uses the SaveCSV with the correct encoding (ANSI...
link: Thanks. Solved!...
link: The problem is in Excel. StringUtils.SaveCSV uses UTF8 encoding (without BOM). Adding the BOM...

I've mentioned that SaveCSV2 produces quotes and extra LF's. Any reason for that behaviour? This code Dim ExportList As List ExportList.Initialize Dim ExportMap As Map For i=0 To OrderList.Size -1 Dim row(9) As String ExportMap=OrderList.Get...")) su.SaveCSV2(File.DirApp,EFn,";",ExportList,CSVHeaders) with this data...
link: It seems like the LF comes from your data. Fields with new line characters need to be quoted....

Thank you....
link: .html#stringutils_savecsv This info will also be in the comments of your autocomplete menu for StringUtils...
link: () As String) Dim RecData As List, su As StringUtils RecData.Initialize RecData.Add("Fred"...
link: This one: su.SaveCSV(File.DirApp, "MyData.csv",",",RecData) ...

LF is Chr(10)....
link: Awesome answer, thank you for the reply. This is much easier than trying to trick out the library....
link: If the text is not too long then you can read the entire text, replace the end of line character and...
link: I have a question on the StringUtils library / SaveCSV2 output. I can successfully write a file...

Hii alll I'm Using the stringutils.saveCSV2 method to export a table view to a csv file but when i open it i find the arabic letters not shown correctly (gibberish) . how to correct that ?...

Hi Erel, I'm very much pleased to get comments from you! To #1a: The StringUtils.SaveCSV is a great function to export into CSV type file (in combination with StringUtils.SaveCSV2 for the header) . What you need is the table structure as described in the documentation: A List with arrays of strings as items. Each array represents a row. All arrays should be of the same length. This would...
link: (why aren't you using StringUtils.SaveCSV or https://www.b4x.com/android/forum/threads...

CSV is a bit more complicated as there are some characters that need to be escaped. There are two implementations of CSV: StringUtils.SaveCSV CSVParser - CSV parser and generator ...

Otherwise, could you suggest me a clever way to print out a list of arrays? ? StringUtils.SaveCSV...
link: StringUtils.SaveCSV Tryed, but I got an error: java.lang.ClassCastException: class java.util...

","5","6","7")) Dim su As StringUtils su.SaveCSV2(File.DirApp... to class at anywheresoftware.b4a.objects.StringUtils.SaveCSV2(StringUtils.java:74) at java...
link: .Initialize data.Add = row Dim su As StringUtils su.SaveCSV2(File.DirApp, "export.csv...
link: ,"7") data.Initialize data.Add(row) Dim su As StringUtils su.SaveCSV2(File...