Excel, tab delimited, and quoted cells/fields

General
1

Excel will enclose any cell that has commas in it in double quotes when exporting the sheet as tab delimited data. I’d like to strip those quotes off the ends of the data. I’m looking at a few ways of doing it. Mostly with regex. Thought I’d check here to see if anyone has done this.

2

Could probably adapt my CSV parser
Second link on http://www.great-white-software.com/REALbasic_Code.html
Or just use CSV and use the code as is

4

Thanks! I’ll look at it now. I switched to tab delimited to avoid and error when there are commas in a cell. And then Excel puts quote around it. Google Docs does not do that.

5

The CSV parser handles all those odd things Excel does like allowing newlines in cells :slight_smile:

6

Awesome piece of work. This solved my issue without a whole lot of modification. The best part is the programming techniques I picked up. Thanks so much.

7

Thanks
And you’re welcome for the code :slight_smile:

Its just a finite state machine that does the parsing :slight_smile: