new line on excel not requested

[Ayoubas01]

Hello,
I record data from a pump controller on Excel, I have a problem there is in my file a line break each time and I do not want it to be displayed
Is there a possibility to avoid this line break and I don't know where it comes from?
I put you a screenshot and my vi

thank you for all 

[Jay14159265]

Hello, 

What does that file look like in a text editor? There may be an extra tab or newline in there causing that. When I am doing this kind of thing I typically use comma separated instead if tab, then you can just name your file <file name>.csv and excel will just open it, you don't have to import it. 

[crossrulz · Accepted solution]

Your device is sending the Carriage Return and/or Line Feed, ie an End Of Line.  And then another End Of Line is added by the Write Delimited File (has build into is an Array To Spreadsheet String which appends the EOL).  Just use a Trim Whitespace to remove the EOL after the VISA Read.

[wiebe@CARYA]

Also, right click a (almost any) wire and select Clean Up Wire.

Or select a wire part and move it with mouse or arrows works too.

Even the automatic diagram cleanup will probably tidy up your code... 

[altenbach]

While your primary problem seems solved, there are also some glaring curiosities.

For example having different stall durations in the same frame seems completely pointless. No matter what, the slower wins. Why not just place a 100ms wait in the frame and just wire across? 😄

(Of course we cannot tell what's in the other cases)

 

[wiebe@CARYA]

---

@altenbach wrote:

(Of course we cannot tell what's in the other cases)

---

There was a VI attached this time!

[Ayoubas01]

the problem is solved I removed the line break after Read VISA thank you all 

[wiebe@CARYA]

---

@Ayoubas01 wrote:

the problem is solved I removed the line break after Read VISA thank you all 

---

My honor to give you your first kudo (for selecting a solution and keeping us informed)!

[Ayoubas01]

thanks to you also for the time spent, this little trick saved me

[altenbach]

---

wiebe@CARYA wrote:

---

@altenbach wrote:

(Of course we cannot tell what's in the other cases)

---

There was a VI attached this time!

---

Ah, I did not see the first post, just the image in a later answer. Looking at the code, each case has a longest wait of 100ms and all they do is delay the display of values and (probably more importantly!) the completion of the case structure. All it needs is a single 100ms wait  there. Ugh!