Seperate Data Entries with Tabs (Write Delimited Spreadsheet)

[Apollito]

I'm trying to simulate the continuous measurement and saving of 2D data I get from a measurement device. It works perfectly, only the formatting is an issue to me right now. In the description of the Write Delimited Spreadsheet function it says that the data entries are seperated with a tabulator (\t) by default. In my mind, the data entries being seperated with a tab would write them in seperate columns next to each other, but it doesn't.

Attached are the program I use to simulate the measurement, how it is saved and also how I would like for it to be saved.

Any help is appreciated. ^^

[alexderjuengere · Accepted solution]

you may want to use Apache's open office to get the formating of the .csv created right, but tab \t should exactly do what you want.

moreover, labview is usually using utf-8 encoding...

if you want to open this .csv via double-left click in EXCEL, in Europe the  ; is usually used as default delimiter, therefore you should change /t to ;

this is very likely different in the US

with /t	with ;

fun fact: if you copy a range of cells in excel and copy it via clipboard to the Body of a forum post, this will spawn a nice html-table

[Apollito]

Thank you very much, I appreciate it a lot.

It is weird to me, though, that it doesn't show you a list of delimiters/how for example a tab is to be defined in the delimiters constant. (or maybe I just didn't read well enough)

[alexderjuengere]

---

@Apollito wrote:

Thank you very much, I appreciate it a lot.

It is weird to me, though, that it doesn't show you a list of delimiters/how for example a tab is to be defined in the delimiters constant. (or maybe I just didn't read well enough)

---

well, this is probably a "read the fine manual"-issue