save data to CSV text file

[tominsek]

here is 2019 version

[GerdW · Accepted solution]

Hi Tim,

---

@tominsek wrote:

here is 2019 version

---

Thanks.

Try this:

Add the column headers as row before the item string array: as you write the whole MCLB content at once there is no need for two file write calls.

And I guess from your images there are EOL chars in the SQL data: remove them before creating CSV files!

Yes there are EOL chars:

(Maybe you should delete the EOL chars right after reading from SQL DB?)

[tominsek]

Gerdw

how do i delete EOL chars?

[tominsek]

Hi Gerdw 

we are closer to the solution...

the data are written in only one column in excel. it needs to be written 1 thing in 1 column

[GerdW]

Hi Tim,

---

@tominsek wrote:

how do i delete EOL chars?

---

I embedded an image in my message…

(The function is called TrimWhiteSpace.)

Other stuff:

• Don't hide labels in the block diagram.
• Don't place too much code inside case structures, especially when it is the same for all cases:
  
• Are you sure you need a timeout between VISAWrite and VISARead?
• You really should handle statemachine data in a cluster in a shift register! No need for all those local variables in the "SQL" state (and others)…
• Are you sure you need more than one event structure in this VI?

[GerdW · Accepted solution]

Hi Tim,

---

@tominsek wrote:

we are closer to the solution...

the data are written in only one column in excel. it needs to be written 1 thing in 1 column

---

Now you are running into Excel-internal problems!

Your Excel doesn't handle the TAB delimiter (default in LabVIEW) as it should.

I guess it expects a semicolon instead (as my German Excel does).

You can easily define the delimiter at the WriteSpreasheetFile function!

[tominsek]

Hi Gerdw, 

Thank you the only problem was that i needed to set delimiter in write delimited spreadheet to ( ; ) and now it works,...

Very thank you

[tominsek]

Someone helped me with this programm because im new to labview and honestly speaking i dont really know what im doing haha...

[Bob_Schor]

---

@tominsek wrote:

Someone helped me with this programm because im new to labview and honestly speaking i dont really know what im doing haha...

---

Don't worry, most of us who read your posts knew that ...  Please teach him (or her) what you learned from us.

Bob Schor