# Create a file layout from a CSV file

**URL:** <https://clarionhub.com/t/create-a-file-layout-from-a-csv-file/4232>\
**Category:** code\
**Tags:** csv\
**Created:** [June 12, 2021, 8:36am UTC](https://clarionhub.com/t/create-a-file-layout-from-a-csv-file/4232 "2021-06-12T08:36:03Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![vitesse](https://clarionhub.com/user_avatar/clarionhub.com/vitesse/32/837_2.png) [@vitesse](https://clarionhub.com/u/vitesse)\
**Post date:** [June 13, 2021, 2:03am UTC](https://clarionhub.com/t/create-a-file-layout-from-a-csv-file/4232/3 "2021-06-13T02:03:50Z")

</div>

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 - #7 by CarlBarnes](https://clarionhub.com/t/how-to-import-csv-into-clarion-11-topspeed-file-without-writing-code/3942/7) 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…

---

_[View the full topic](https://clarionhub.com/t/create-a-file-layout-from-a-csv-file/4232)._
