CSV to JSON using jFiles

[CarlBarnes]

The Clarion DCT has great support for creating a Basic File Specification by reading a CSV. Then you can wizard a Process to read them all and code for JFiles. I would think Json.Save(CsvFile:Record,…more). I do not use jFile. You can also create a Report or Browse.

You can read CSV files string StringTheory but it does not handle quoted strings any where near as well as the BASIC driver without a bunch of odd code.

Here is some discussion:

How to import CSV into Clarion 11 TopSpeed file without writing code

I thought that might be non 13,10 line endings so I tried a Unix (10) and MAC (13) file. The Wizard shows warnings below. The Mac file does not work and make a DCT file. The Unix file works, but did not set the Driver options to /ENDOFRECORD=10 /FIRSTROWHEADER=ON . [image] [image] Even though I config the Driver for 10 the Data Browser only shows the Header: (Edit: this was wrong, should have been /EndOfRecord=1,10 then everything worked.) [image] [image] The 13,10 file works [image…

Create a file layout from a CSV file

Over on the Clarion 11 newsgroup Steve asked: Is there a quick way to get the file layout of a .csv file? I want to do some data processing on the csv and a .tps file. A couple of people quickly mentioned you could just import the file into the dictionary, although when setting the column widths it only checks the first 100 rows. Wolfgang mentioned: if you know the columns and if you know the delimiter, you could write a tiny tool with StringTheory, which parses the .CSV in advance an t…