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: Last week i found a wonderfull program, which is able to connect and migrate all most used databases against another; its include Access, Excel, dBase

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 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

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 10 ie CR LF 2a/ fields (columns) are separated by byte 172 (which is ASCII 44 comma with high bit set, presumably chosen to simplify parsing of field
link: 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
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

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

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

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: Erel, thanks for your answer, but, I have an .csv with all the info in greek and when I copy to de db only shows me ????? in the fields, I check the l

You can convert a csv file into a SQLite database with this program: csv to SQLite.
link: https://www.b4x.-way-to-import-csv-file-in-sqlite-db.34382/
link: i am new from b4a how to import csv file data to sqlite table. please give some example.
link: Thanks Lucas we will try

Powered by ColBERT