Separator within Results window

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

Separator within Results window

CARL Philippe (LBP)
Dear all,
When saving data from a results window, the created file has the extension ".csv" with "," as separator.
When trying to open such a generated file within Excel (at least with a french version of the software) either through a Drag&Drop or File>Open process, the file gets imported as a simple text, i.e. without taking into account the "," delimiters.
Thus the only way to correctly open such generated file is either to rename the file extension from ".csv" to ".txt" (and then open the file using the Excel importer assistant) or to make a replacement of the "," delimiter into a tabulation.
As far as I'm concerned making such gymnastics is trivial and straight forward, nevertheless it is very unfortunately not the case for more beginner users.
So would it be of common interest to have a delimiter definition option within Results>Options... of the Results window?
My best regards,
Philippe

PS: If the answer is positive I could write the needed code for submission and validation.

Philippe CARL
Laboratoire de Bioimagerie et Pathologies
UMR 7021 CNRS - Université de Strasbourg
Faculté de Pharmacie
74 route du Rhin
67401 ILLKIRCH
Tel : +33(0)3 68 85 42 89

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html
Reply | Threaded
Open this post in threaded view
|

Re: Separator within Results window

Herbie
Bonsoir Philippe,

usually I save Result tables as text files that use tab-delimiters.
Under "I/O Options" you can set the file extension for tables.
"Tab-separated values" is also supported.

HTH

Herbie

:::::::::::::::::::::::::::::::::::::::::::::::::
Am 21.01.20 um 17:43 schrieb CARL Philippe (LBP):

> Dear all,
> When saving data from a results window, the created file has the extension ".csv" with "," as separator.
> When trying to open such a generated file within Excel (at least with a french version of the software) either through a Drag&Drop or File>Open process, the file gets imported as a simple text, i.e. without taking into account the "," delimiters.
> Thus the only way to correctly open such generated file is either to rename the file extension from ".csv" to ".txt" (and then open the file using the Excel importer assistant) or to make a replacement of the "," delimiter into a tabulation.
> As far as I'm concerned making such gymnastics is trivial and straight forward, nevertheless it is very unfortunately not the case for more beginner users.
> So would it be of common interest to have a delimiter definition option within Results>Options... of the Results window?
> My best regards,
> Philippe
>
> PS: If the answer is positive I could write the needed code for submission and validation.
>
> Philippe CARL
> Laboratoire de Bioimagerie et Pathologies
> UMR 7021 CNRS - Université de Strasbourg
> Faculté de Pharmacie
> 74 route du Rhin
> 67401 ILLKIRCH
> Tel : +33(0)3 68 85 42 89
>
> --
> ImageJ mailing list: http://imagej.nih.gov/ij/list.html
>

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html
Reply | Threaded
Open this post in threaded view
|

Re: Separator within Results window

Kenneth R Sloan-2
Many of my plugins check the current Locale and write output files using a format specific to that Locale.  The code to do that
is a bit messy, but I have evolved towards a stylized method that is not too difficult to write (it *is* a bit confusing to READ the code).  For various reasons, I have little experience dealing with the Results Table outputs.  Generally, I roll my own.
The main difference is between comma-separated .csv files (is that redundant?) and TAB-separated .txt files.

After decades of experience with this, my conclusion is that .txt files with TAB delimiters is most portable format.  Of course, the main problem with .csv files is the use of ',' as a field separator when in Locales which use ',' as a decimal separator.  I have not encountered similar problems with TAB being commonly used for something other than a field separator.

I may start to standardize on this, and stop worrying about Locale.

The good news is that recent releases of Excel (for example) generally do a good job parsing these files.  If memory serves, the lack of "easy import" for TAB-delimited .txt files was the initial motivation for using .csv files where possible.

--
Kenneth Sloan
[hidden email]
Vision is the art of seeing what is invisible to others.

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html
Reply | Threaded
Open this post in threaded view
|

Re: Separator within Results window

CARL Philippe (LBP)
In reply to this post by Herbie
Grüss Gott Herbie,
Thanks a lot for your answer, but are you using a "vanilla" version of ImageJ or rather Fiji?
Unless I really need to think about using glasses, I don't see any tab-delimiters within Edit>Options>Input/Ouput...
As for the "file extension setting for tables" I indeed validate your answer.
My best regards,
Philippe

----- Le 21 Jan 20, à 20:42, Herbie [hidden email] a écrit :

Bonsoir Philippe,

usually I save Result tables as text files that use tab-delimiters.
Under "I/O Options" you can set the file extension for tables.
"Tab-separated values" is also supported.

HTH

Herbie

:::::::::::::::::::::::::::::::::::::::::::::::::
Am 21.01.20 um 17:43 schrieb CARL Philippe (LBP):

> Dear all,
> When saving data from a results window, the created file has the extension ".csv" with "," as separator.
> When trying to open such a generated file within Excel (at least with a french version of the software) either through a Drag&Drop or File>Open process, the file gets imported as a simple text, i.e. without taking into account the "," delimiters.
> Thus the only way to correctly open such generated file is either to rename the file extension from ".csv" to ".txt" (and then open the file using the Excel importer assistant) or to make a replacement of the "," delimiter into a tabulation.
> As far as I'm concerned making such gymnastics is trivial and straight forward, nevertheless it is very unfortunately not the case for more beginner users.
> So would it be of common interest to have a delimiter definition option within Results>Options... of the Results window?
> My best regards,
> Philippe
>
> PS: If the answer is positive I could write the needed code for submission and validation.
>
> Philippe CARL
> Laboratoire de Bioimagerie et Pathologies
> UMR 7021 CNRS - Université de Strasbourg
> Faculté de Pharmacie
> 74 route du Rhin
> 67401 ILLKIRCH
> Tel : +33(0)3 68 85 42 89
>
> --
> ImageJ mailing list: http://imagej.nih.gov/ij/list.html
>

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html
Reply | Threaded
Open this post in threaded view
|

Re: Separator within Results window

Herbie
Mmh Philippe,

I use plain ImageJ but I don't think Fiji is much different...

What I wanted to express, and I think I did, is that if you choose the
".txt"-extension in the I/O-options dialog, then Results tables are
saved with tab-delimiters. If you want to get such data back in an
ImageJ-table then you can use "File >> Import >> Table".

Just try it!

Kind regards

Herbie

::::::::::::::::::::::::::::::::::::::::::::::::
Am 21.01.20 um 21:19 schrieb CARL Philippe (LBP):

> Grüss Gott Herbie,
> Thanks a lot for your answer, but are you using a "vanilla" version of ImageJ or rather Fiji?
> Unless I really need to think about using glasses, I don't see any tab-delimiters within Edit>Options>Input/Ouput...
> As for the "file extension setting for tables" I indeed validate your answer.
> My best regards,
> Philippe
>
> ----- Le 21 Jan 20, à 20:42, Herbie [hidden email] a écrit :
>
> Bonsoir Philippe,
>
> usually I save Result tables as text files that use tab-delimiters.
> Under "I/O Options" you can set the file extension for tables.
> "Tab-separated values" is also supported.
>
> HTH
>
> Herbie
>
> :::::::::::::::::::::::::::::::::::::::::::::::::
> Am 21.01.20 um 17:43 schrieb CARL Philippe (LBP):
>> Dear all,
>> When saving data from a results window, the created file has the extension ".csv" with "," as separator.
>> When trying to open such a generated file within Excel (at least with a french version of the software) either through a Drag&Drop or File>Open process, the file gets imported as a simple text, i.e. without taking into account the "," delimiters.
>> Thus the only way to correctly open such generated file is either to rename the file extension from ".csv" to ".txt" (and then open the file using the Excel importer assistant) or to make a replacement of the "," delimiter into a tabulation.
>> As far as I'm concerned making such gymnastics is trivial and straight forward, nevertheless it is very unfortunately not the case for more beginner users.
>> So would it be of common interest to have a delimiter definition option within Results>Options... of the Results window?
>> My best regards,
>> Philippe
>>
>> PS: If the answer is positive I could write the needed code for submission and validation.
>>
>> Philippe CARL
>> Laboratoire de Bioimagerie et Pathologies
>> UMR 7021 CNRS - Université de Strasbourg
>> Faculté de Pharmacie
>> 74 route du Rhin
>> 67401 ILLKIRCH
>> Tel : +33(0)3 68 85 42 89
>>
>> --
>> ImageJ mailing list: http://imagej.nih.gov/ij/list.html
>>

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html
Reply | Threaded
Open this post in threaded view
|

Re: Separator within Results window

CARL Philippe (LBP)
Dear Herbie,
I indeed completely missed your point!!!
How is it again? Something like: "When the sage points at the moon, the fool looks at the finger"
Thanks a lot for pointing me on this, given that you save me the time to write an "ad hoc" code to save Results data with tabulation separators.
And the users can live with file extensions being ".txt" instead of ".csv".
Have a nice evening,
Philippe

----- Mail original -----
De: "l16" <[hidden email]>
À: "CARL Philippe, LBP" <[hidden email]>, "imagej" <[hidden email]>
Envoyé: Mardi 21 Janvier 2020 21:30:10
Objet: Re: Separator within Results window

Mmh Philippe,

I use plain ImageJ but I don't think Fiji is much different...

What I wanted to express, and I think I did, is that if you choose the
".txt"-extension in the I/O-options dialog, then Results tables are
saved with tab-delimiters. If you want to get such data back in an
ImageJ-table then you can use "File >> Import >> Table".

Just try it!

Kind regards

Herbie

::::::::::::::::::::::::::::::::::::::::::::::::
Am 21.01.20 um 21:19 schrieb CARL Philippe (LBP):

> Grüss Gott Herbie,
> Thanks a lot for your answer, but are you using a "vanilla" version of ImageJ or rather Fiji?
> Unless I really need to think about using glasses, I don't see any tab-delimiters within Edit>Options>Input/Ouput...
> As for the "file extension setting for tables" I indeed validate your answer.
> My best regards,
> Philippe
>
> ----- Le 21 Jan 20, à 20:42, Herbie [hidden email] a écrit :
>
> Bonsoir Philippe,
>
> usually I save Result tables as text files that use tab-delimiters.
> Under "I/O Options" you can set the file extension for tables.
> "Tab-separated values" is also supported.
>
> HTH
>
> Herbie
>
> :::::::::::::::::::::::::::::::::::::::::::::::::
> Am 21.01.20 um 17:43 schrieb CARL Philippe (LBP):
>> Dear all,
>> When saving data from a results window, the created file has the extension ".csv" with "," as separator.
>> When trying to open such a generated file within Excel (at least with a french version of the software) either through a Drag&Drop or File>Open process, the file gets imported as a simple text, i.e. without taking into account the "," delimiters.
>> Thus the only way to correctly open such generated file is either to rename the file extension from ".csv" to ".txt" (and then open the file using the Excel importer assistant) or to make a replacement of the "," delimiter into a tabulation.
>> As far as I'm concerned making such gymnastics is trivial and straight forward, nevertheless it is very unfortunately not the case for more beginner users.
>> So would it be of common interest to have a delimiter definition option within Results>Options... of the Results window?
>> My best regards,
>> Philippe
>>
>> PS: If the answer is positive I could write the needed code for submission and validation.
>>
>> Philippe CARL
>> Laboratoire de Bioimagerie et Pathologies
>> UMR 7021 CNRS - Université de Strasbourg
>> Faculté de Pharmacie
>> 74 route du Rhin
>> 67401 ILLKIRCH
>> Tel : +33(0)3 68 85 42 89
>>
>> --
>> ImageJ mailing list: http://imagej.nih.gov/ij/list.html
>>

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html
Reply | Threaded
Open this post in threaded view
|

Re: Separator within Results window

Stein Rørvik
In reply to this post by CARL Philippe (LBP)
Use the file extension .tsv, then you get a tab separated table. Excel will open this directly with no conversion needed.

Stein

Sendt fra min iPhone

> 21. jan. 2020 kl. 21:24 skrev CARL Philippe (LBP) <[hidden email]>:
>
> Grüss Gott Herbie,
> Thanks a lot for your answer, but are you using a "vanilla" version of ImageJ or rather Fiji?
> Unless I really need to think about using glasses, I don't see any tab-delimiters within Edit>Options>Input/Ouput...
> As for the "file extension setting for tables" I indeed validate your answer.
> My best regards,
> Philippe
>
> ----- Le 21 Jan 20, à 20:42, Herbie [hidden email] a écrit :
>
>

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html
Reply | Threaded
Open this post in threaded view
|

Re: Separator within Results window

CARL Philippe (LBP)
Dear Stein (and Wayne)
Thanks a lot for this info.
With the possibility to reimport such tables files within ImageJ and the IJ.renameResults method I moved the code much further.
My best regards,
Philippe

----- Mail original -----
De: "Stein Rørvik" <[hidden email]>
À: "imagej"
Envoyé: Mercredi 22 Janvier 2020 11:28:53
Objet: Re: Separator within Results window

Use the file extension .tsv, then you get a tab separated table. Excel will open this directly with no conversion needed.

Stein

Sendt fra min iPhone

> 21. jan. 2020 kl. 21:24 skrev CARL Philippe (LBP) <[hidden email]>:
>
> Grüss Gott Herbie,
> Thanks a lot for your answer, but are you using a "vanilla" version of ImageJ or rather Fiji?
> Unless I really need to think about using glasses, I don't see any tab-delimiters within Edit>Options>Input/Ouput...
> As for the "file extension setting for tables" I indeed validate your answer.
> My best regards,
> Philippe
>
> ----- Le 21 Jan 20, à 20:42, Herbie [hidden email] a écrit :
>
>

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html
Reply | Threaded
Open this post in threaded view
|

Re: Separator within Results window

Herbie
Salut Philippe,

that's funny because I've mentioned the "Tab Separated Values"-file
format (.tsv) before:

"Under "I/O Options" you can set the file extension for tables.
"Tab-separated values" is also supported."

Furthermore and mentioned as well before, there is no problem to
correctly open Results-tables saved as text-files in ImageJ per Import...

Just wondering

Herbie

:::::::::::::::::::::::::::::::::::::::::::::::::
Am 22.01.20 um 18:37 schrieb CARL Philippe (LBP):

> Dear Stein (and Wayne)
> Thanks a lot for this info.
> With the possibility to reimport such tables files within ImageJ and the IJ.renameResults method I moved the code much further.
> My best regards,
> Philippe
>
> ----- Mail original -----
> De: "Stein Rørvik" <[hidden email]>
> À: "imagej"
> Envoyé: Mercredi 22 Janvier 2020 11:28:53
> Objet: Re: Separator within Results window
>
> Use the file extension .tsv, then you get a tab separated table. Excel will open this directly with no conversion needed.
>
> Stein
>
> Sendt fra min iPhone
>
>> 21. jan. 2020 kl. 21:24 skrev CARL Philippe (LBP) <[hidden email]>:
>>
>> Grüss Gott Herbie,
>> Thanks a lot for your answer, but are you using a "vanilla" version of ImageJ or rather Fiji?
>> Unless I really need to think about using glasses, I don't see any tab-delimiters within Edit>Options>Input/Ouput...
>> As for the "file extension setting for tables" I indeed validate your answer.
>> My best regards,
>> Philippe
>>
>> ----- Le 21 Jan 20, à 20:42, Herbie [hidden email] a écrit :
>>
>>
>
> --
> ImageJ mailing list: http://imagej.nih.gov/ij/list.html
>
> --
> ImageJ mailing list: http://imagej.nih.gov/ij/list.html
>

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html
Reply | Threaded
Open this post in threaded view
|

Re: Separator within Results window

CARL Philippe (LBP)
Servus Herbie,
I fully confirm that you had already indicated me the "Tab Separated Values" files within your very first reply.
But as I already mentionned it: "When the sage points at the moon, the fool looks at the finger"!!!
Thus following your mail, I was expecting this feature to be accesible through a checkbox choice within the "I/O Options" which I actually didn't see.
This is why I had replied to you asking whether what you were mentioning was an ImageJ or only a Fiji feature.
I didn't get it that the use of "Tab Separated Values" actually meant just saving the files with the extension ".tsv".
And it is only following a private mail I received later from Wayne that I had fully understand what you meant on the first place.
So I'm a very fast learner, but only if somebody explains things for a long time, a very long time!!!
Kindest regards,
Philippe

----- Mail original -----
De: "l16" <[hidden email]>
À: "imagej" <[hidden email]>, "CARL Philippe, LBP" <[hidden email]>
Envoyé: Mercredi 22 Janvier 2020 19:08:28
Objet: Re: Separator within Results window

Salut Philippe,

that's funny because I've mentioned the "Tab Separated Values"-file
format (.tsv) before:

"Under "I/O Options" you can set the file extension for tables.
"Tab-separated values" is also supported."

Furthermore and mentioned as well before, there is no problem to
correctly open Results-tables saved as text-files in ImageJ per Import...

Just wondering

Herbie

:::::::::::::::::::::::::::::::::::::::::::::::::
Am 22.01.20 um 18:37 schrieb CARL Philippe (LBP):

> Dear Stein (and Wayne)
> Thanks a lot for this info.
> With the possibility to reimport such tables files within ImageJ and the IJ.renameResults method I moved the code much further.
> My best regards,
> Philippe
>
> ----- Mail original -----
> De: "Stein Rørvik" <[hidden email]>
> À: "imagej"
> Envoyé: Mercredi 22 Janvier 2020 11:28:53
> Objet: Re: Separator within Results window
>
> Use the file extension .tsv, then you get a tab separated table. Excel will open this directly with no conversion needed.
>
> Stein
>
> Sendt fra min iPhone
>
>> 21. jan. 2020 kl. 21:24 skrev CARL Philippe (LBP) <[hidden email]>:
>>
>> Grüss Gott Herbie,
>> Thanks a lot for your answer, but are you using a "vanilla" version of ImageJ or rather Fiji?
>> Unless I really need to think about using glasses, I don't see any tab-delimiters within Edit>Options>Input/Ouput...
>> As for the "file extension setting for tables" I indeed validate your answer.
>> My best regards,
>> Philippe
>>
>> ----- Le 21 Jan 20, à 20:42, Herbie [hidden email] a écrit :
>>
>>
>
> --
> ImageJ mailing list: http://imagej.nih.gov/ij/list.html
>
> --
> ImageJ mailing list: http://imagej.nih.gov/ij/list.html
>

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html
Reply | Threaded
Open this post in threaded view
|

Re: Separator within Results window

Stein Rørvik
Just a small note on an advantage of using .tsv instead of .txt (even though the file contents should be identical in the two cases):

If you are on windows, you can easily associate the .tsv extension with your favorite statistics program (or ImageJ if you want), and then just double-click the file for a direct import there. If you use the command "assoc .tsv=Excel.Sheet" in a command-line window with administrator rights, Windows will thereafter open the file directly and correctly in Excel without Excel doing any (usually wrong) attempt to guess the format of the contents, as it does with the .txt extension.

Stein

-----Original Message-----
From: ImageJ Interest Group <[hidden email]> On Behalf Of CARL Philippe (LBP)
Sent: 22. januar 2020 22:27
To: [hidden email]
Subject: Re: Separator within Results window

Servus Herbie,
I fully confirm that you had already indicated me the "Tab Separated Values" files within your very first reply.
But as I already mentionned it: "When the sage points at the moon, the fool looks at the finger"!!!
Thus following your mail, I was expecting this feature to be accesible through a checkbox choice within the "I/O Options" which I actually didn't see.
This is why I had replied to you asking whether what you were mentioning was an ImageJ or only a Fiji feature.
I didn't get it that the use of "Tab Separated Values" actually meant just saving the files with the extension ".tsv".
And it is only following a private mail I received later from Wayne that I had fully understand what you meant on the first place.
So I'm a very fast learner, but only if somebody explains things for a long time, a very long time!!!
Kindest regards,
Philippe

----- Mail original -----
De: "l16" <[hidden email]>
À: "imagej" <[hidden email]>, "CARL Philippe, LBP" <[hidden email]>
Envoyé: Mercredi 22 Janvier 2020 19:08:28
Objet: Re: Separator within Results window

Salut Philippe,

that's funny because I've mentioned the "Tab Separated Values"-file format (.tsv) before:

"Under "I/O Options" you can set the file extension for tables.
"Tab-separated values" is also supported."

Furthermore and mentioned as well before, there is no problem to correctly open Results-tables saved as text-files in ImageJ per Import...

Just wondering

Herbie

:::::::::::::::::::::::::::::::::::::::::::::::::

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html