• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

csv format and splitters

i use a program called csv splitter (
http://www.fxfisherman.com/downloads/csv-splitter-1.1.zip)

it is able to process the format from manual copy/paste or excel to generate from a query directly, but not the format from sql server - save as csv option.

could you see why it may reject the system output of csv from sql server?

csv-formats-and-splitters.jpg
0
25112
Asked:
25112
  • 2
  • 2
1 Solution
 
lisfolksCommented:
I can't tell anything by the image. Everything looks correct regardless of the method used to output the CSV file. However, I'm wondering if the SQL Server version has some "invisible" characters in it.

Are you simply typing the CR/LF text for the sake of the image, or are you 100% certain that there is a CR/LF combination at the end of each file?

Try reading the files into a hex editor (some programming editors have one built in) and compare. You should be able to see that way if anything at all is different, 'cause it will show you character-by-character the contents of the file.
0
 
25112Author Commented:
i got them in notepad++ is that hex editor?
0
 
lisfolksCommented:
Notepad++ isn't a hex editor on its own; however, there's a plug-in for it that enables hex editing. See instructions and info here:

SourceForge.net: Notepad++: Topic: Hex editor
0
 
25112Author Commented:
this definitely  helps.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now