All Tags ›
CSV and TSV output targets (
RSS)
Sorry, but there are no more tags available to filter with.
-
Even when opening the file directly from disk in Excel 2003 I have the problem. This works: sep=, "Url","Aantal" "/bbfaq/results.html","3499" "/bbfaq/main.html","3439" "/bbfaq/index.html","3269" "/bbfaq/topbar.html","3236" "/bbfaq/hidden.html","3232" This does not: "Url","Aantal" "/bbfaq/results.html...
-
Well, I find that odd, since if you use Excel to open the file directly from the disk, you won't hit that problem (have you verified that?). It seems you're having this problem only when opening the file through IE. CSV files don't need to say "sep=,", because CSV means "comma-separated values" and by...
-
Hello Gabriele Yes, I was already using the contenttype but still had the same problem in Excel 2003. As I wrote in my last message I've solved it by inserting a 'header' line as first line into the CSV file, works great this way. Best regards, Emil Zegers
-
Have you experimented with the Content-Type header?
-
Workaround for csv files in Excel 2003 is to add the following as first line in the file: sep=, This line will not be displayed in Excel but will make sure Excel uses the comma as separator. Maybe an enhancement for Log Parser to offer this as a property? For now i will add this line through the filesystemobject...
-
Hello Gabriele, Thanks for your quick reply and your feedback on point 1. and 2. Some more info on point 3: It looks like Excel 2003 doesn't treat csv files right, cause when I save the data you wrote down into the file test.csv and open this file directly in Excel 2003 (by double clicking and also when...
-
Thanks so much for the detailed report!!!! Here are some replies: 1. The problem you are having with the "tabs" property of the CSV output format is by design. This property is an ON/OFF property; according to the documentation, its COM type is a Boolean: The value type accepted and returned by an input...
-
Hey, a new version of 2.2 is released! My document was based upon the initial 2.2 realease. Will test same scenarios with new release again.
-
Hello, In the attached zipped doc (600 kB) I've described some errors I encounter when using Log Parser 2.2 with ASP VBScript on IIS 5.1/Win XP Pro. I hope this feedback is useful to improve the Log Parser tool even further (or to improve my programming quality if I'm making mistakes :-) Regards, Emil...