Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting tab-delimiter file - 16 rows
Excel 2003:
1. Create 3 column headers a1, a2 and a3 2. Populate column a1 and a2 only, updating say 30 rows 3. Export as a Tab delimiter file. 4. Only the first 16 rows have the correct number of expected delimiters e.g a1<taba2<taba3<tab a<tabb<tab <- As expected 2 tabs c<tabb<tab 17th row p<tabb <--Missing Tab The 2nd tab does not exist from row 17 onwards. Anybody have any ideas why Only the first 16 rows??? Cheers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting tab-delimiter file - 16 rows
This doesn't seem to be an exact match since it deals with commas, not tabs.
But it sure sounds like the same situation to me: Saved from a previous post: This might describe the problem of too many commas in CSV files: http://support.microsoft.com/default.aspx?scid=77295 Column Delimiters Missing in Spreadsheet Saved as Text (It actually describes missing delimiter, but if some are "missing", maybe the ones appearing are "extra".) (But a lot of programs (excel included) don't care about those extra columns. Maybe you don't have to care, either???) Maybe you could write your own exporting program that would behave exactly the way you want: Here are three sites that you could steal some code from: Earl Kiosterud's Text Write program: www.smokeylake.com/excel (or directly: http://www.smokeylake.com/excel/text_write_program.htm) Chip Pearson's: http://www.cpearson.com/excel/imptext.htm notmrexcel wrote: Excel 2003: 1. Create 3 column headers a1, a2 and a3 2. Populate column a1 and a2 only, updating say 30 rows 3. Export as a Tab delimiter file. 4. Only the first 16 rows have the correct number of expected delimiters e.g a1<taba2<taba3<tab a<tabb<tab <- As expected 2 tabs c<tabb<tab 17th row p<tabb <--Missing Tab The 2nd tab does not exist from row 17 onwards. Anybody have any ideas why Only the first 16 rows??? Cheers -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flat File with @ as delimiter | Excel Discussion (Misc queries) | |||
Need Help Importing Text File Using Two or More Spaces as the Delimiter | Excel Discussion (Misc queries) | |||
Tab Delimiter File | Excel Discussion (Misc queries) | |||
export excel file as csv with text delimiter of " | Excel Discussion (Misc queries) | |||
How do I specify a specific char delimiter for my file, when I sa. | Excel Discussion (Misc queries) |