rkse

Personal Notepad

2015-07-15

Forcing Excel to use a csv field separator other than the local list separator

Add the line
sep=|
at the beginning of the csv-file, to instruct excel to use the pipe character as the field separator.
Posted by Ralf at 18:05 No comments:
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Whos.amung.us?

whos online

Ralf"s shared items

Books to Read

  • Becomming a Technical Leader - Gerald M. Weinberg
  • Refactoring to Patterns - Joshua Kerievsky
  • BUGS in Writing: A Guide to Debugging Your Prose -- Lyn Dupré

Blog Archive

  • ►  2017 (2)
    • ►  June (1)
    • ►  May (1)
  • ▼  2015 (3)
    • ►  December (1)
    • ▼  July (1)
      • Forcing Excel to use a csv field separator other t...
    • ►  April (1)
  • ►  2009 (24)
    • ►  December (1)
    • ►  July (4)
    • ►  June (2)
    • ►  May (2)
    • ►  April (5)
    • ►  March (10)
  • ►  2007 (19)
    • ►  July (1)
    • ►  June (7)
    • ►  May (8)
    • ►  April (1)
    • ►  March (2)
  • ►  2006 (1)
    • ►  October (1)
Awesome Inc. theme. Powered by Blogger.