Search Results

Attached you find a small project to convert csv files to a SQLite database. The program: - detects automatically between the two separator characters ',' ';'. - determines, on request, the data type for each column (TEXT, REAL, INREGER), these can be changed. - the column names are the values of th
link: The problem is that your original data is encoded with ASCII and not UTF-8. If you load the person.csv file you see under Peter KRAUSE Kurfürstendamm,
link: Thank you for the link. I am old fashioned, I like my own tools, I did not google to find something existing.
link: The CsvToSQLite program has been updated to version 1.4. Removes invalid characters in Table names. Added: Number of rows / Time to load csv / Time to

In this B4J application you can load and view CSV text files. A CSV file is a Comma-Separated Values text file. Each value from one line is separated by a delimiter. This delimiter can be a comma ( , ), a semi-colon ( ; ), an equal-sign ( = ), a colon ( : ), a tab character or any other character yo
link: You can find the scrolling grid tutorial via this link: Scrolling grid Indeed, it is a useful tool. I have also made a SQLite DB viewer tool using th

CSV - comma separated values format. The various StringUtils libraries include methods for loading and saving CSV files. However these methods have a few drawbacks: - They work with files instead of strings. This is especially problematic if the input is not UTF8 encoded. - As they are implemente
link: Any reason it is called CLVParser instead of CSVParser (title)?
link: I have thought the same. :)
link: I wrote, some time ago, a CSV parser too and I can't recall the times I miswrote those simple three letters :D (CVS was my 'favourite') #ItIsACurse

As I am an "old school" programmer I would say that datas never have to do anything with views. A CSV-file is a text file with lines for the rows and the cells ("columns") are strings in these lines separated by a "special character". So you have to scan the CSV by iterating through all the lines, t
link: Don't parse CSV like this. It will not work with real CSV. Use StringUtils or CSVParser - CSV parser and generator Dim Table As List = table fro
link: "your code, will fail to parse this CSV string, which is made of a single cell"
link: I have used us_country.csv in table view exm. but I can't use only single column instead of unusing other colm. Secondly storeing selected Item to tex

A CSV is a TEXTfile which does not contains any binary data.

CSV (comma separated values) files are made of rows with multiple fields. Excel will show it as a table. You cannot change the formatting. Note that Excel doesn't properly handle non-ASCII text in CSV files.
link: When you export CSV in first line (before any data) add this sep=, This tell excel to use comma as separator. http://superuser.com/a/686415
link: hi i have just tried to create a csv file and send it via MailComposer from my app. everything works but when i open my file (with Open Office) i get
link: There is no Excel library for B4i. You can create CSV files with StringUtils.

Firstly, Thanks you Emexes, Mcqueccu and Andrew. Emexes, thanks for you help. The . csv file is not the definitive one. It is actually a file linked to another Google Sheets sheet with the "IMPORTRANGE" function. I have tried your solution with the final file and it works perfectly. I would never ha
link: DownloadFile is a resumable Sub. You need to Wait For it to complete before running "leer" or move leer to the end of Downloadfile.
link: 1. Put a sleep(0) between the download and the leer. I think the file is not fully written before its read. 2. Take a look at csv parser https://www.b
link: Hello! I have a problem with my App. It is very simple: 1- Download a Google Sheet (public). 2- Read data. Dear jvrh_1 I've just completed a very s

I'm afraid that your .csv file is encoded with Windows-1253 and not UTF-8. Try to convert it with notepad++.
link: Upload the CSV file.
link: My excuses EREL, you are ok and I'm wrong. It's the csv that convert all characters from greek to ??????. So please tell me how can I pass directly fr
link: Thanks for your answer, I have all ok in the xls file, but if I try to convert to csv something happens and change all the characters to ??????, same

How are you expecting LoadTableFromCSV will save something? It loads a CSV and creates a html-Table from it´s content. A CSV is a Textfile. You can create it with the File Methods. Or with StringUtils su.SaveCSV2(File.DirInternal, "1.csv", ",", data, Array("Column 1", "Column 2", "Column 3"))
link: i'm creating an application on B4A that using csv excel file. i do not know how to save the file on android phone. im used LoadTableFromCSV(File.DirAs

Here is a B4J and B4A program that takes the following steps: It loads the csv file directly from the specified URL (from the hospital overview) into "temp.csv" It replaces the separator with a tab value and writes the record to "temp2.csv" It reads the file "temp2.csv" in the database test.db in t
link: I downloaded and looked directly at the clinics data file clinics.csv, and this is what it is: 1/ lines are terminated with the two byte sequence 13
link: That file (SCL.csv) looks indeed a bit more complex: Bytes ordered asc by value: -110 10 -106 20 -96 1 -84 593649 -55 2 -37
link: I just opened the file as .txt or .csv and processed that, but you are right the files in the mentioned link are Excel files. I know how to read these

Powered by ColBERT