CSV - no delimiter at end of line

  • Follow


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

0
Reply Utf 3/19/2010 9:14:01 AM

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
> 
0
Reply Utf 3/19/2010 9:25:01 AM


1 Replies
800 Views

(page loaded in 0.031 seconds)

Similiar Articles:
















7/22/2012 7:20:11 PM


Reply: