I think that in many cases there there may already be a predefined set of limits. The dialog screen shot I posted was from UltraEdit (forgot to mention that). I think in many cases people may want to set or adjust the predefined field lengths and even be willing to truncate items like an extra long description. As the fixed with may be predefined in some cases. I do like how UltraEdit will scan a text file, and suggest some lengths then you can adjust or just start with your own lengths.
If curious how UltraEdit handles it you could play with it for their trial period.
My only curiosity is how you would handle an Excel file with a newline int the cell? I have never tested that in XL Toolbox, but have seen CSV files that do have a new line in a cell as long as is surrounded by quotes. In the case of fixed width files it would be best to strip out any CR/LF or just a CR or just an LF.
The other day i helped work though a problem with a CSV file that had CR/LF for end of records, but inside some of the quoted fields were LF (char 10) to create a multi line field. It is still causing us pains.
Hope you will consider this feature
Oh, if you update the webpage to info about the CSV Export options be sure and also a a link on the front page to the change long. Noticed it can be hard to find.
One feature of your CSV export is that some may not realize is it seems to support full Unicode Export (not sure if there is a BOM). I learned a long time ago that Excel’s default would mess up some characters Chinese characters.
Keep up the good work