csv

B4A What is the most convenient way to save APP settings? Is it similar to the Windows INI file or using SQLITE? For a very small amount of data, does it take up too much memory to use a database? If reading or writing is closed immediately, will the APP increase the memory? Asked CHATGPT AI, he...

Hello everyone, I’d like to share with you a tool I’ve developed called liteCsvParse. It’s a lightweight library I created to make working with CSV files easier, especially on older devices or those with limited resources. The library consists of two main functions: CsvToList: This function...

B4XLib library that adds useful functionalities to B4XTable. Please, see: https://www.b4x.com/android/forum/threads/b4x-lmb4xtableext.158817/

B4XLib library that adds useful functionalities to B4XTable. Currently for B4A and B4J. Note that this library is NOT my custom version of the official and original B4XTable View, it does not replace it. It can be used together with the B4XTable View to add functionalities to the B4XTable View...

I do not have enough experience with B4J. I am currently saving a list of arrays having multiple string items as a CSV like this: 1. Iterate over the list having arrays 2. Read array elements one by one 3. Create a string with array elements and commas in between 4. Add that string to new list...

Escribí un pequeño programa para probar si puedo leer y mostrar los datos contenidos en un archivo CSV. Todo parece funcionar hasta que la ejecución del programa llega a la línea Log("Fecha: " & subList.Get(0)) El error que arroja B4J es: He casteado los datos de la siguiente forma...

Greetings community, Below is the code I use to export my data from my B4xTable to csv and it works for me. But now, i want to be able to export specific columns. Lets say, i want to export all the columns ["USERNAME", "ID","FULLNAME","DATE OF...

Ciao a tutti. Devo caricare un csv composto da 140.000 righe in una tabella. Ci riesco ma il caricamento è molto lento. Ho provato con la libreria DBUTILS ma mi dà l'errore : Uncaught translation error: min-sdk-version >= 26) Esiste un metodo rapido e veloce per caricare tutti i dati? Al...

Hi, I'm trying to load a CSV file from: https://data.covid19india.org/csv/latest/districts.csv Dim j As HttpJob j.Initialize("", Me) j.Download("https://data.covid19india.org/csv/latest/districts.csv") Wait For (j) JobDone(j As HttpJob) If j.Success Then...

I am dealing with large and often misformed .csv files and StringUtils.LoadCSV is not flexible enough to cope with all these, so wrote a parsing function in B4A, having the same output (list holding 1D string arrays). This seems to work all fine, but it is about 3-4x slower that...

Hi, i have a csv file with 1.000.000 and more records. My initially idea is read and copy the records into my sqlite database, because i want my records locally, but the file is too big and the app crash (450 mb). What is the best way to copy locally or it's better to read remotely this file...

Is there a recommended way of detecting/reading non-UTF8 text files? One of my apps lets users import CSV files. Recently a German user reported that the import wasn't working, and we think we've narrowed it to the file encoding. Encoding: He's saving his CSV file in "normal" encoding for...

After 2 days of bafflement, I'm asking for fresh eyes. o_O I'm exporting data to a CSV file, but it seems to be losing the last few lines of the data. There are 190 rows of data, but I'm only seeing 170 in the resulting file. The last line in the file is incomplete (missing part of a value in...

Ola Lesson 8.1 Lesson 8.2 Lesson 8.3 Lesson 8.4 As per subject matter this lesson is about a data-table with a pager and also functionality to export its contents to PNG, PDF, CSV and XLSX. It's so amazing that with just a few object (map) settings and then a few simple calls webix does...