| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV - no delimiter at end of line
If I have a spreadsheet like this:
fred joe harry And I save it as a CSV I get this: fred,joe,harry Now I want to import the file into a database that requires this e.g. there is a delimiter after the last field: fred,joe,harry, Can I make Excel do this without using a dummy column? The dummy column solution: e.g. fred joe harry dummy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CSV - no delimiter at end of line
Try putting a space (hit the space bar once) in the last column first row and
copy down the same...before saving to csv -- Jacob "cats_five" wrote: If I have a spreadsheet like this: fred joe harry And I save it as a CSV I get this: fred,joe,harry Now I want to import the file into a database that requires this e.g. there is a delimiter after the last field: fred,joe,harry, Can I make Excel do this without using a dummy column? The dummy column solution: e.g. fred joe harry dummy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to split data where line breaks are the delimiter | Excel Worksheet Functions | |||
| point as delimiter | Excel Discussion (Misc queries) | |||
| Delimiter in CSV files | Excel Discussion (Misc queries) | |||
| Comma delimiter | Excel Worksheet Functions | |||
| Tab Delimiter File | Excel Discussion (Misc queries) | |||
Linear Mode
