My favorite is pipe-delimited, though that would depend on your data of course. Pipes are never used with the data I deal with, and would be a "typo" if they we

My favorite is pipe-delimited, though that would depend on your data of course. Pipes are never used with the data I deal with, and would be a "typo" if they were. I do check for them on import and export, replacing them with %pipe; on any free-form text fields. My data sets aren't that huge, but sometimes do get up to mid 10Ms though frequently is only in the 100Ks. I know it's not a perfect solution but may work for you too.