Create a file layout from a CSV file

thanks Carl!

I wish I had re-read your post that you mentioned at How to import CSV into Clarion 11 TopSpeed file without writing code earlier as I had completely forgotten that the dct import of CSV detected types and could get the names!

I see the dct import uses underscores as word separators rather than the Capitalization approach that I took. That would actually be technically simpler to do as you could just replace embedded spaces and other invalid characters with underscores. Anyway I did mention that “you could easily change this if you prefer to use underscores between words” so perhaps I can make that an option. I can see some might prefer the underscore approach with columns like “Max FTE Salary” which would currently be converted to “MaxFteSalary” as opposed to “Max_FTE_Salary”.

thanks also for your type detection code - I will look at incorporating that (or something similar) and will then post an update…